Question
I have the correct answers but require a detailed step-by-step explanation of how to do each question by hand. Use the following information to calculate
I have the correct answers but require a detailed step-by-step explanation of how to do each question by hand.
Use the following information to calculate your answers to questions 1 through 7.
Consider the following annual series on the number of people assisted by a county's human resources department.
Year | People (in 100s) |
1 | 22 |
2 | 24 |
3 | 28 |
4 | 24 |
5 | 22 |
6 | 24 |
7 | 20 |
8 | 26 |
9 | 24 |
10 | 28 |
11 | 26 |
1. What is the 3-year moving average for period 4? The correct answer is: 24.67
2. What is the 3-year moving average forecast for period 12? The correct answer is: 26.00
3. What is the Mean Square Error (MSE) for the 3-year moving average?The correct answer is: 7.67
4. Using a smoothing constant of 0.4, what is the exponential smoothing value to be used as forecasts for period 4?The correct answer is: 24.88
5. Using a smoothing constant of 0.4, what is the exponential smoothing value to be used as forecasts for period 12?The correct answer is: 25.70
6. Using a smoothing constant of 0.4, what is the Mean Square Error (MSE) for exponential smoothing?The correct answer is: 8.41
7. When comparing the accuracy of both forecasting techniques (3-year moving average and exponential smoothing with a 0.4 smoothing constant) we can conclude thatThe correct answer is: the 3-year moving average is more accurate since its MSE is less than that of exponential smoothing.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started