Question

I've been trying to figure it out for hours but I am still confused. What is...

I've been trying to figure it out for hours but I am still confused.

What is the value of MAD?

Week

Time Series Value

Forecast

1

6

7.00

2

5

3.00

3

4

3.00

4

7

4.00

What is the value of MSE?

Month

Actuals

Forecast

1

7

4.00

2

5

3.00

3

4

4.00

4

3

6.00

Homework Answers

Answer #1

Solution:

Part a) What is the value of MAD?

Given:

Week Time Series Value Forecast
1 6 7
2 5 3
3 4 3
4 7 4

We have to find MAD , that is mean absolute deviation.

Thus

Part b) What is the value of MSE?

Given:

Month Actuals Forecast
1 7 4
2 5 3
3 4 4
4 3 6

Formula:

Thus

Month At: Actuals Ft  : Forecast Ft  - At (Ft  - At)^2
1 7 4 =(4-7)=-3 9
2 5 3 =(3-5)=-2 4
3 4 4 =(4-4)=0 0
4 3 6 =(6-3)=3 9

Thus

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Using the data below, what is the value of RMSE? Week Time Series Value Forecast...
1. Using the data below, what is the value of RMSE? Week Time Series Value Forecast 1 3 7.00 2 5 4.00 3 2 5.00 4 8 8.00 2. Using the data below, calculate the squared error for the 4th week. Use the 2 period moving average to create the forecast. Week Time Series Value 1 19.00 2 11.00 3 22.00 4 7.00 Please, do the all the work and show processes
Problem 15-05 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...
Problem 15-05 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 16 13 18 11 15 14 Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time Series Value Forecast 1 16 2 13 3 18 4 11 5 15 6 14 MSE: _______ The forecast for week 7: ______ Use  = 0.2 to compute the exponential smoothing values...
I need the answer for (e) : Use trial and error to find a value of...
I need the answer for (e) : Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.20. Use a two-decimal digit precision. Consider the following time series data. Week 1 2 3 4 5 6 Value 18 15 15 13 17 14 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required,...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 24 13 18 12 18 23 15 b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as negative number. Month Time Series Value Forecast Forecast Error Squared Forecast Error 1 24 2 13 3 18 4 12 ? ? ? 5 18 ? ? ? 6 23...
I am trying to figure out the probability, expected value, variance, and standard deviation for a...
I am trying to figure out the probability, expected value, variance, and standard deviation for a series of dice rolls. For example, if I roll a six-sided die in an attempt to roll a 1, and it takes me 13 rolls before a 1 appears, what are those answers? I believe I have figured out the probability equation: P(P-1)^x where x is the number of rolls - 1 so for 13 rolls the probability would be: 1/6(1-1/6)^12 = .01864045 Is...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.1. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97 Group of answer choices A) MAD=296.6, MSE=1266.5 B) MAD=296.6 , MSE=11398.5 C)...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97 Group of answer choices a) MAD=9.7, MSE=1585.6 b) MAD=9.7, MSE=176.2 c) MAD=10.2,...
I am trying to figure out the correct formula in statistics that I need to use...
I am trying to figure out the correct formula in statistics that I need to use for this question. When you or anyone else attempts to tell me and my associates that 1223 persons account for our opinions and tastes here in America, I get mad as hell! How dare you! When you or anyone else tells me that 1223 people represent America; it is astounding and unfair and should be outlawed. The writer then goes on to claim that...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A) What type of pattern exists in the data? (HORIZONTAL OR TREND) B) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time Series Value Forecast 1 18 2 13 3 16 4 11 _______ 5 17 _______ 6 14 _______ MSE:...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 15 12 16 14 c)Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 2 13 18 3 15 4 12 5 16 6 14 Compute MSE. (Round your answer to two decimal places.) MSE =____ What is the forecast for week 7? (Round your answer to two decimal places.) ____ (e)Use a...