Question

Based on the time series values from problem number 2, consider the following table of exponential...

Based on the time series values from problem number 2, consider the following table of exponential smoothing values using ? = ?. ? for the time series.

Month

Units Sold (Thousands)

Forecast (F)

error

Squared error

1

9

*

* *

2

3

(i)?

(ii)?

36

3

6

7.2000

-1.2000

1.44

4

6

6.8400

-0.8400

0.7056

5

12

6.5880

5.4120

29.2897

6

9

8.2116

0.7884 0.6216

7

(iii)?

a) b) c) d) e)

a. Compute the number (i): Show your work for full credit
b. Compute the number (ii): Show your work for full credit
c. Compute the number (iii): Show your work for full credit
d. What is the mean square error (MSE)? Show your work for full credit

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Assuming Forecast for first month = Units sold = 9

Forecast for Month 2: F2 = F1 + ?*(A1-F1) = 9+0.3*(9-9) = 9

b) Error for month 2 = Actual-Forecast = 3-9 = -6

c) Forecast for Month 7: F7 = F6 + ?*(A6-F6) = 8.2116+0.3*(9-8.2116) = 8.2116+0.3*0.7884 = 8.2116+0.2365 = 8.4481

d) MSE = Sum of squared errors/n = (36+1.44+0.7056+29.2897+0.6216)/5 = 68.0569/5 = 13.6114

Add a comment
Know the answer?
Add Answer to:
Based on the time series values from problem number 2, consider the following table of exponential...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Q3. error Based on the time series values from problem number 2, consider the following table...

    Q3. error Based on the time series values from problem number 2, consider the following table of exponential smoothing values using a = 0.3 for the time series. Units Sold Forecast (F) Squared error Month (Thousands) 9 2 3 (0)? (ii)? 36 3 6 7.2000 -1.2000 1.44 4 6 6.8400 -0.8400 0.7056 5 12 6.5880 5.4120 29.2897 6 9 8.2116 0.7884 0.6216 7 (iii)? a) (3pt) Compute the number (i): Show your work for full credit b) (3pt) Compute the...

  • Q3 A-E Q3. Based on the time series values from problem number 2, consider the following...

    Q3 A-E Q3. Based on the time series values from problem number 2, consider the following table of exponential smoothing values using a = 0.3 for the time series. Units Sold Forecast (F) error Month (Thousands) Squared error 9 2 3 (i)? (ii)? 36 6 7.2000 -1.2000 1.44 4 6 6.8400 -0.8400 0.7056 5 12 6.5880 5.4120 29.2897 6 9 8.2116 0.7884 0.6216 7 (iii)? 3 a) (3pt) Compute the number (i): Show your work for full credit b) (3pt)...

  • Q3 A-E Q3. Based on the time series values from problem number 2, consider the following...

    Q3 A-E Q3. Based on the time series values from problem number 2, consider the following table of exponential smoothing values using a = 0.3 for the time series. Forecast (F) error Squared error Month Units Sold (Thousands) 9 * 1 2 برا برا 6 6 4 5 (i)? 7.2000 6.8400 6.5880 8.2116 (iii)? (ii)? -1.2000 -0.8400 5.4120 0.7884 36 1.44 0.7056 29.2897 0.6216 12 9 6 7 a) (3pt) Compute the number (i): Show your work for full credit...

  • - + Fit to page ID Page view A) Read alouc * Q3. Based on the...

    - + Fit to page ID Page view A) Read alouc * Q3. Based on the time series values from problem number 2, consider the following table of exponential smoothing values using a = 0.3 for the time series. Units Sold Forecast (F) error Month (Thousands) Squared error 9 2 3 (i)? (ii)? 36 3 6 7.2000 -1.2000 1.44 4 6 6.8400 -0.8400 0.7056 5 12 6.5880 5.4120 29.2897 6 9 8.2116 0.7884 0.6216 (iii)? 1 7 a) (3pt) Compute...

  • Question 2 A-E. 1 Q2. The following time series shows the number of units of a...

    Question 2 A-E. 1 Q2. The following time series shows the number of units of a product sold over the past six months. Units Sold Month (Thousands) 9 2 3 3 6 4 6 5 12 6 9 Consider the following 3-month moving average for the above time series and forecast the sales volume for month 7. Month Units Sold 3-month moving (Thousands) average Forecast (F) error Squared Error 9 * * ذرا * * * * ** 2 3...

  • The following time series shows the number of units of a particular product sold over the...

    The following time series shows the number of units of a particular product sold over the past six months. a. Use = 0.2 to compute the exponential smoothing values for the time series, forecast the sales volume for month 7, and fill in the unknown spaces. Compute the number (i): Compute the number (ii): Compute the number (iii): What is the mean square error (MSE)? b. Consider the following 3-month moving average for the above time series and forecasting the...

  • Question 3 part a & b. please show work! 3. The following time series shows the...

    Question 3 part a & b. please show work! 3. The following time series shows the number of units of a particular product sold over the past six months. Units Sold Month (Thousands) 23 2 17 3 17 4 5 26 11 23 6 a. Use a = 0.2 to compute the exponential smoothing values for the time series, forecast the sales volume for month 7, and fill in the unknown spaces. Units Sold Forecast (F) error Squared error Month...

  • Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1...

    Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Choose the correct time series plot Month (iv) Month Select your answer What type of pattern exists in the data? Select your answer- (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal...

  • Consider the following time series data. Week 1 2 3 4 5 6 Value 17 13...

    Consider the following time series data. Week 1 2 3 4 5 6 Value 17 13 15 11 15 13 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Horizontal PatternTrend PatternItem 2 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers...

  • Omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a....

    omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT