Day Demand Day Demand

1 200 8 150

2 134 9 182

3 157 10 197

4 165 11 136

5 177 12 163

6 125 13 157

7 146 14 169

I need to develop a spreadsheet to answer the questions.

Calculate a forecast of the above demand using a three- and five-period moving average.

Graph these forecasts and the original data using Excel. What does the graph show?

Which of the above forecasts is best? Why?

### Recently Asked Questions

- what is the lower limit of the 99% confidence interval what is the upper limit of the 99% confidence interval

- A psychologist wants to estimate the standard deviation of IQ scores. It is widely believed that IQ scores follow a normal distribution. Her random sample of

- Show detail work 1. Iron (atomic mass 55.85 g/mol) crystallizes in a body-centered cubic unit cell. If the length of an edge of the unit cell is 287 pm, what