Question: Hi, please send the answer in excel file format, I just badly need your help. Please see the attached photo below. Thank you so much

Hi, please send the answer in excel file format, I just badly need your help. Please see the attached photo below. Thank you so much

Hi, please send the answer in excel file format, I just badly

P3. The table below contains data on the monthly amount, in millions of dollars, which was spent by "leading national advertisers" for advertising apparel and accessories in magazines, in four recent years. Year Month 1 2 3 4 January $6.7 $7.9 $ 8.8 $ 7.4 February 6.2 8.4 10.3 17.4 March 12.1 15.1 20.4 26.1 April 14.4 15.9 17.3 26.6 May 11.1 11.8 15.7 17.0 June 7.4 5.5 9.0 10.4 July 6.4 7.6 8.9 7.9 August 12.9 13.0 20.0 24.7 September 21.1 23.2 32.6 35.6 October 15.4 17.2 24.2 24.8 November 16.5 16.7 22.0 22.2 December 11.6 11.9 16.9 19.8 Source: Survey of Current Business, U.S. Department of Commerce, Washington, D.C., various dates. Use the above data to complete the following: a. Construct the worksheet for single-factor exponential smoothing with o = 0.20 to obtain the forecasts for the months of February through December of Year 1. Assume that the forecast for January of Year 1 is the same as the actual for January of Year 1. b. Draw the graph of the actual values and the forecasted values for both a = 0.20 & a = 0.80 c. Explain the graph with references to the difference of 0.20 and 0.80 alphas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!