Homework Assignment using XLSTAT in Excel
BluSkyy7571. A hotdog stand owner who sales hotdogs only on Saturdays has collected the following time series data on the number of hotdogs sold over the past 12 quarters.
Year Quarter Demand
1 Winter 29
1 Spring 65
1 Summer 56
1 Fall 45
2 Winter 23
2 Spring 57
2 Summer 48
2 Fall 32
3 Winter 14
3 Spring 55
3 Summer 52
3 Fall 25
A) Forecast next weekly rate using a 3 period moving average.
B) Forecast the next weekly rate using a 2 period moving average. Which one of these (A or B) is a better forecast and why? Please explain it in writing.
C) Forecast the next weekly rate by using exponential smoothing with an alpha value of 0.3.
D) Forecast the next weekly rate by using a linear regression.
The Assignment has to be completed in Excel using the Add in XLSTAT.
- 2 years ago
- 25
Purchase the answer to view it
- ForecastingusingExcel.docx
- Hotdogstimeseries.xlsx
Purchase the answer to view it
- file..XLstat.docx
- movingaverage.xlsx
- Global climate change and health paper
- How many numbers of collision and broadcast domains does the network have?
- discussion#1
- spanish quiz
- A+ Work
- Create a 1100- to 1,400-word proposal for a themed film festival. The theme could be anything
- Assignment
- Assignment
- 1 Page Human Services on A movie " Losing Isiah"
- For "Yourstar Only"