4. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare a three-month moving average forecast with an exponential smoothing forecast for a-0.2. Which provides the better forecasts using MSE as the measure of model accuracy? c. What is the forecast for next month?

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter9: Solving Quadratic Functions
Section: Chapter Questions
Problem 4CA
icon
Related questions
Question
PLEASE ANSWER ASAP. STRICTLY DONT USE EXCEL!!
4. For the Hawkins Company, the monthly percentages of all shipments received on
time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.
a. Construct a time series plot. What type of pattern exists in the data?
b. Compare a three-month moving average forecast with an exponential
smoothing forecast for a-0.2. Which provides the better forecasts using MSE
as the measure of model accuracy?
c. What is the forecast for next month?
Transcribed Image Text:4. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare a three-month moving average forecast with an exponential smoothing forecast for a-0.2. Which provides the better forecasts using MSE as the measure of model accuracy? c. What is the forecast for next month?
Expert Solution
steps

Step by step

Solved in 4 steps with 12 images

Blurred answer
Recommended textbooks for you
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
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning