Question: Question Set 3. Using only the Seattle sales data: 1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to

Question Set 3. Using only the Seattle sales data: 1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.7 Assume the sales forecast for January 4th was 456. (6pts) 2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5 through January 29th. Again, you should not include the forecast for January 30th since there is no corresponding sales figure for that date. (4pts) 3. Using your forecasts from Q3.1, find the mean squared error of the sales forecasts for January 5th through January 29th (4pts) Reminder: Check your work to make sure you have onbe included fo C D - E E A B 1 Date Seattle 2 1/4/2020 452 3 1/5/2020 647 4. 1/6/2020 603 5 1/7/2020 617 6 1/8/2020 613 7 7 1/9/2020 520 81/10/2020 594 9 1/11/2020 689 101/12/2020 586 11 1/13/2020 544 12 1/14/2020 716 13 1/15/2020 808 14 1/16/2020 590 15 1/17/2020 675 16 1/18/2020 765 17 1/19/2020 690 18 1/20/2020 532 19 1/21/2020 428 20 1/22/2020 580 21 1/23/2020 609 22 1/24/2020 582 23 1/25/2020 497 24 1/26/2020 640 25 1/27/2020 598 26 1/28/2020 435 27 1/29/2020 7701 28 1/30/2020 29 30 31

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 General Management Questions!

3. Using only the Seattle sales data: 1. Forecast sales for January 5 th through January 30 th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4 th was 456....

PLEASE SHOW WORK AND FORMULAS IN EXCEL SHEET Durhlington has tracked daily sales of coats for the three locations below: Date Chicago Nashville Seattle Seasonal Relatives for Chicago Sales 0.4 0.5...

Durhlinoton has tracked dailv sales of coats for the three locations below Question Set 3. Using only the Austin sales data: 1. Forecast sales for January 5th through January 30th using exponential...

For a like please use excel and show work with excel formulas. Durhlinoton has tracked dailv sales of coats for the three locations below Question Set 3. Using only the Austin sales data: 1. Forecast...

Question Set 3. Using only the Austin sales data: 1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th...

PLEASE USE EXCEL AND SHOW FORMULAS Durhlington has tracked daily sales of coats for the three locations below: Question Set 3. Using only the Austin sales data: 1. Forecast sales for January 5th...

PLEASE USE EXCEL SPREADSHEET AND EXCEL FORMULAS AND EXPLAIN THE PROCESS WITH CALCULATIONS. THIS IS MY THIRD TIME POSTING THE SAME QUESTION AND I HAVE NOT BEEN RECEIEVING A PROPER ANSWER. IF THE...

Please do everything on excel and show formulas Questions Durhlington has tracked daily sales of coats for the three locations below: Date Chicago Nashville Seattle Seasonal Relatives for Chicago...

1. The following revenues were among those reported by Tosa Township in 2018: Net rental revenue (after depreciation) from a parking garage owned by Tosa. . .. . . $ 40,000 Interest earned on...

At 1000 K, a sample of pure NO2 gas decomposes: The equilibrium constant KP is 158. Analysis shows that the partial pressure of O2 is 0.25 atm at equilibrium. Calculate the pressure of NO and NO2 in...

Determine the specific eight - digit Codification citation ( XXX - XX - XX - X ) detailing the disclosure requirements for maturities of long - term debt.

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...