STATISTICS

profilehelphelp

 

FORECASTING

Random Variations Only

5-17

5-21

Trend and Random Variations

5-25

Seasonal and Random Variations

5-38

Trend, Seasonal, and Random Variations

5-33 

Unless otherwise specified below, you must show all your calculations either manually or by using a traditional Excel worksheet.  You are welcome to check your work with Excel QM and you may even submit it if you wish, but credit will only be given if you do your own work as described above and that work is readily visible and obvious. 

The exceptions to the mandated instructions described above are:

  1. To answer 5-25, you may use either Excel Data Analysis or Excel QM.
  2. On 5-33, you may use either Excel Data Analysis or Excel QM to find the equation of the trend line of the deseasonalized data. The remainder of the problem is to be answered as described above.

Attachements

  • 6 years ago
  • 10
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    forecasting.xlsx