Project #26242 - Statistics HW

1.   The Excel file  Closing Stock Prices  provides data for four

 stocks over a one-month period.

 a.   Develop spreadsheet models for forecasting each of

 the stock prices using single moving average and

 single exponential smoothing.

 b.   Using MAD, MSE, and MAPE as guidance, find the

 best number of moving average periods and best

 smoothing constant for exponential smoothing. 

 

 

2.   Use the data in the Excel file  Baseball Attendance  to do

 the following:

 a.   Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing.

 b.   Using MAD, MSE, and MAPE as guidance, find the

 best number of moving average periods and best

 smoothing constant for exponential smoothing.

 

4.   For the data in the Excel file  Gasoline Prices  do the

  following:

 a.   Develop spreadsheet models for forecasting prices

 using single moving average and single exponential

 smoothing.

 b.   Using MAD, MSE, and MAPE as guidance, find the

 best number of moving average periods and best

 smoothing constant for exponential smoothing.  

 

5.   Consider the prices for the DJ Industrials in the Excel

 file  Closing Stock Prices. The data appear to have a linear

 trend over the time period provided. Use simple linear

 regression to forecast the data. What would be the forecasts for the next three days?

Subject General
Due By (Pacific Time) 03/31/2014 08:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy