You should write a short summary of the technique used

Assignment Help Other Subject
Reference no: EM13531053

Tutorial – Using Excel Data Forecasting Tools 

The table below shows the marketing expenditure and corresponding sales figures on a month by month basis for SM Heating Products. 

You are asked to produce an analysis of these figures for inclusion in a report to be presented to the board of directors. In doing this you will need to establish trends over the period shown for both expenditure and revenue and determine the relationship between these. This will require the use of statistical analysis tools available in Excel. 

You will need to select appropriate trend-lines and relationship functions to bring the data into an understandable form. You must justify your selection. 

Finally you should write a short summary of the technique used in the analysis and critically evaluate your results. 

Month Marketing Expenditure (£000''s) Sales (£000''s) 

Jul-08 300 530 

Aug-08 346 635 

Sep-08 834 1000 

Oct-08 723 938 

Nov-08 130 274 

Dec-08 624 793 

Jan-09 345 536 

Feb-09 768 1450 

Mar-09 464 800 

Apr-09 624 826 

May-09 270 373 

Jun-09 389 403 

Jul-09 917 1592 

Aug-09 836 1632 

Sep-09 613 804 

Oct-09 741 1064 

Nov-09 456 582 

Dec-09 246 425 

Jan-10 734 903 

Feb-10 824 946 

Mar-10 234 306 

Apr-10 423 623 

May-10 682 835 

Jun-10 234 352 

Reference no: EM13531053

Questions Cloud

Evaluate the acceleration of the system : Two crates of mass 65 kg and 125 kg are in contact and at rest on horizontal surface. A 650 N force is excerted horizontally on the 65 kg crate. evaluate the acceleration of the system
What is the tension when the rock is at the bottom : A rock of mass m = 1.1 kg is tied to a string of length L = 2.5 m and is twirled in a vertical circle, what is the tension when the rock is at the bottom
Find the minimum speed that car can have without slipping : A car rounds a curve that is banked inward. The radius of curvature of the road is R = 139, the banking angle is ? = 31°, Find the minimum speed that the car can have without slipping
Estimate the size of the friction force : Estimate the size of the friction force on a baseball player sliding into second base. Assume a mass of 84 and uk = 0.42
You should write a short summary of the technique used : You will need to select appropriate trend-lines and relationship functions to bring the data into an understandable form. You must justify your selection.
What current must a wire carry : Some pacemakers employ magnetic reed switches to enable doctors to change their mode of operation without surgery. What current must a wire carry if it is to produce a 5.02E-4 T field at a distance of 0.468 m
Determine how big is the resultant of the three forces : Three athletes are tugging on a ring. Martha pulls with a force of 150N in the northernly direction. How big is the resultant of the three forces
Determine the net work done by the force of gravity : A bead of mass m = 3.10 kg is released from point A and slides on the frictionless track as shown in the figure below. The height of A is ha = 6.70 m. Determine the net work done by the force of gravity in moving the bead from A to C
What are the tax consequences of the stock redemption : Fred is the sole shareholder of Ponce Corporation, having a basis of $90,000 in 1,000 shares of Ponce common stock. Last year, Ponce (E & P of $500,000) issued a dividend of 2,000 shares of preferred stock to Fred

Reviews

Write a Review

Other Subject Questions & Answers

  Analyze causes of anorexia in hospitalized patients

Provide three patient scenarios that commonly result in decreased food intake during prolonged hospitalizations. For each scenario:

  Find the mean and the median of the class sizes

Lauren is a college sophomore majoring in business. This semesterLauren is taking coursesin accounting, economics, management information systems, public speaking and statistics. The sizes of these classes are, respectively, 350, 45, 35, 25, and 40. ..

  Explain the image of social change and fundamental elements

How do I explain the image of social change and the fundamental elements dealing with each three theoretical frameworks?

  Cartoon illustrates the sociological concept

Five specific cartoons that to be illustrations of many sociological concepts, ideas or processes. For each cartoon,describes what, how, and why the cartoon illustrates the sociological concept, idea, or process

  Classical and contemporary ideology

Provide an example of a Classical and a Contemporary ideology that you personally feel is viable. Why should the United States in 2011 begin to move toward these approaches?

  Democracy automatically creates two classes of people

Aristophanes is right in The Clouds: democracy automatically creates two classes of people--knaves and fools-and if it were not for support it gets from knaves and fools.

  Common tools for managed care organizations

The uses of bonuses, financial incentives and sanctions have become common tools for managed care organizations seeking to save costs. What guidelines should there be for employees of such organizations?

  Economy globalizes

As the economy globalizes, would it be beneficial for labor movements to become global as well? What are the advantages and disadvantages of a global labor movement?

  Explaining the domestic violence

Alice pressed charges for domstic violence against her now ex-spouse Robert. Despite the charges, Robert is still and large and Alice is frightened.

  In regards to memory-problem solving and language skills

In regards to memory, problem solving , and language skills, how would you teach older adult students versus students of traditional college age? Be sure to include how achievement motivation affects adults in your answer.

  Langdon winner

The majority of us in this country are free thinking individuals who take control of our own lives, and who view technology as not as masters, but as surrogates to our own needs. I believe folks like Winner wish it weren't so.

  Objective and subjective thinking

How does the conception of "free will" impact the conversation about objective and subjective thinking?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd