Using simple moving averages and the following time series data, respond to each of the items.   Period Demand 1 104 2 132 3 143 4 137 5 146 6 150 7 101 8 126 9 116 10 115         Click here for the Excel Data File   b. Compute all possible forecasts using a three-period simple moving average model. (Round your answers to 2 decimal places.)   c. Compute the MAD. (Round your answer to 2 decimal places.)   d. What is the forecast demand for period 11?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 1BGP
icon
Related questions
Question

Using simple moving averages and the following time series data, respond to each of the items.
 

Period Demand
1 104
2 132
3 143
4 137
5 146
6 150
7 101
8 126
9 116
10 115
 

 

 

  Click here for the Excel Data File
 
b. Compute all possible forecasts using a three-period simple moving average model. (Round your answers to 2 decimal places.)

 



c. Compute the MAD. (Round your answer to 2 decimal places.)

 



d. What is the forecast demand for period 11?

 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
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
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning