Question: 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

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 was 644 . (6pts) 2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5th 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 only included forecasts and accuracy measures for the exact date ranges specified. Also, please copy these tables into your Excel file while solving

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!

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...

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...

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...

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 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...

Date Washington Newyork Houston 1/4/21 1/5/21 1/6/21 1/7/21 1/8/21 1/9/21 1/10/21 1/11/21 1/12/21 1/13/21 1/14/21 1/15/21 1/16/21 1/17/21 1/18/21 1/19/21 1/20/21 1/21/21 1/22/21 1/23/21 1/24/21...

Please Make an excel work sheet solving this question. Please make sure answers are in Excel formulas (and show said excel formulas) Durhlinoton has tracked dailv sales of coats for the three...

Who reads financial statements? List at least three different categories of people. For each category, provide an example of the type of information they might be interested in and discuss why.

Prove the K-K-M theorem directly, using Sperner's lemma. Let A0, A1,..., An be closed subsets of an n-dimensional simplex S with vertices x0, x1,..., xn. If for every I {0, 1,..., n} the face...

The diagram shows triangle DEF. DEF = 90, DFE = 45 and EDF = 45 DF has a length of 4 units. E 5- 4- 3-D 2- 1 F 0 1 2 3 4 5 6 7 8 x different equal shorter longer congruent smaller not congruent bigger

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...