Question

Can you please answer number 6! Its the only one i need thanks!!! The actual values...

Can you please answer number 6! Its the only one i need thanks!!!

The actual values for 12 periods (shown in order) are:

(1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 55  (7) 64  (8) 58  (9) 73  (10) 66  (11) 69  (12) 74

Using a 5 period simple moving average, the forecast for period 13 will be:

QUESTION 2

  1. Using the 4 period weighted moving average, the forecast for period 13 will be:

QUESTION 3

  1. With exponential smoothing, the forecast for period 13 will be:

QUESTION 4

  1. With linear regression, the forecast for period 13 will be:

QUESTION 5

  1. With quadratic regression, the forecast for period 13 will be:

QUESTION 6

  1. Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Homework Answers

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
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. A. The...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
In Excel, create a forecast for periods 6-13 using the following method: Quadratic regression with the...
In Excel, create a forecast for periods 6-13 using the following method: Quadratic regression with the equation based on all 12 periods.   With quadratic regression, the forecast for period 13 will be: _____ Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving...
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving average. Weights: (0.63, 0.26, 0.08, 0.03) Using the 4 period weighted moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
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
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)...