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

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
Get step-by-step solutions from verified subject matter experts
