I | J | K | L | M | |
9 | Month | Actuals | forecast | error | error^2 |
10 | 1 | 7 | 4 | 3 | 9 |
11 | 2 | 5 | 8 | -3 | 9 |
12 | 3 | 4 | 4 | 0 | 0 |
13 | 4 | 3 | 5 | -2 | 4 |
14 | |||||
15 | TOTAL | 22 | |||
Mean square error= error^2/ n | =22/4 | ||||
MSE= 5.50 |
formula:
I | J | K | L | M | |
9 | Month | Actuals | forecast | error | error^2 |
10 | 1 | 7 | 4 | =J10-K10 | =L10^2 |
11 | 2 | 5 | 8 | =J11-K11 | =L11^2 |
12 | 3 | 4 | 4 | =J12-K12 | =L12^2 |
13 | 4 | 3 | 5 | =J13-K13 | =L13^2 |
14 | |||||
15 | TOTAL | =SUM(M10:M13) |
Using the data below, what is the value of MSE? Month Actuals Forecast 4.00 on 8.00...
Using the data below, what is the simple exponential smoothing forecast for the 4th week where a=0.4? Week Time Series Value 6.00 4.00 3.00 Submit Answer format: Number: Round to: 1 decimal places. Using the data below, what is the value of MSE? Month Actuals Forecast 4.00 8.00 4.00 5.00 Submit Answer format: Number: Round to: 2 decimal places.
Using the data below, what is the value of MSE? Week Time Series Value Forecast 1 7 5.00 2 5 8.00 3 4 8.00 4 3 3.00 Answer Format: Number: Round to: 2 decimal places.
Using the data below, calculate the bias based on using the naive forecast method. Week Time Series Value 6.00 21.00 6.00 15.00 Submit Answer format: Number: Round to: 1 decimal places. Using the data below, what is the value of RMSE? Week Time Series Value Forecast 8.00 2.00 8.00 5.00 Submit Answer format: Number: Round to: 2 decimal places.
Using the data below and the SES forecast a=0.3, what is the error for the 3rd week? Week Time Series Value 12.00 13.00 20.00 5.00 Submit Answer format: Number: Round to: 1 decimal places.
Using the data below, what is the simple exponential smoothing forecast for the 3rd week where a=0.3? Week Time Series Value 2.00 8.00 6.00 3.00 Submit Answer format: Number: Round to: 1 decimal places Based on the data below for chocolate demand per week and using the naive forecasting method, how much you should order for 5th week? Week Time Series Value 15.00 14.00 23.00 6.00 Submit Answer format: Number: Round to: O decimal places.
Using the data below, what is the weighted moving average forecast for the 4th week? The weights are 20,30.50 (oldest period to most recent period) Week Time Series Value 17.00 17.00 7.00 20.00 Submit Answer format: Number: Round to: 1 decimal places. Using the data below and the SES forecast 00.3, what is the error for the 3rd week? Week Time Series Value 6.00 19.00 17.00 23.00 Submit
Stock X Year Stock Y unanswered 8.00% -16.00% not_submitted 12.00% 2 -5.00% 14.00% 0.00% 4 4.00% 5.00% What is the covariance of the returns of Stock X with the returns of Stock Y? Submit Answer format: Number: Round to: 6 decimal places.
Year Stock X Stock Y 8.00% -16.00% -5.00% 12.00% 14.00% 0.00% 4.00% 5.00% What is the standard deviation of Stock Y? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))
Year Stock X Stock Y 8.00% -16.00% -5.00% 12.00% 14.00% 0.00% 4 4.00% 5.00% What is the standard deviation of the returns of Stock X? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))
Consider the following time series data. Month Value 1 21 2 3 4 14 2014 5 18 6 21 7 15 Round your answers to two decimal places. a. Compute MSE using the most recent value as the forecast for the next period. Mean squared error is What is the forecast for month 8? b. Compute MSE using the average of all data available as the forecast for the next period Mean squared error is What is the forecast for...