Question

The following time series shows the number of units of a particular product sold over the past six months.

a. Use \alpha = 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 (Thousands) 1 23 * * 2 17 (i)? (ii)? 36 3 17 21.8 -4.8 23.04 4 26 20.84 5.1

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 sales volume for month 7.

3-month Forecast (F) error Squared Units Sold moving Error Month (Thousands) average 1 23 ** * * * 2 17 ** ** 3 17 19 * * 4 2

Compute the number (i):
Compute the number (ii):
Compute the number (iii):
Compute the number (iv):
What is the mean square error (MSE)?

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

(11) Errol ch Mouth - Demand (Unit solel) - Forecast Erra= 23-10 Error = 5 (i) squared error of hared error of the Month (Err

Add a comment
Know the answer?
Add Answer to:
The following time series shows the number of units of a particular product sold over the...
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
  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • Problem II The following time series shows the sales of a clothing store over a 10-week...

    Problem II The following time series shows the sales of a clothing store over a 10-week period. Week Sales ($1,000s) 15 a. Compute a 4-week moving average for the above time series. b. Compute the mean square error (MSE) and mean Absolut deviation (MAD) for the 4. week moving average forecast. c. Use a -0.3 to compute the exponential smoothing values and MSE and MAD for the time series. d. Forecast sales for week 11. e. Which model is the...

  • 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