Homework Help is Here – Start Your Trial Now!
Math
Statistics
4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Actual Battery Sales Month January February March April Мay June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.

4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Actual Battery Sales Month January February March April Мay June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 23PPS
See similar textbooks
icon
Related questions
Question
11:-0 I O MAD 4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Month Actual Battery Sales January February March April May June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.
Transcribed Image Text:11:-0 I O MAD 4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Month Actual Battery Sales January February March April May June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.
Expert Solution
steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
SEE MORE TEXTBOOKS