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 the next month?

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter4: Linear Functions
Section4.3: Fitting Linear Models To Data
Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....
icon
Related questions
Question

Please provide excel computations

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 the next month?
Transcribed Image Text: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 the next month?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer