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?
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
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781938168383/9781938168383_smallCoverImage.gif)
![Functions and Change: A Modeling Approach to Coll…](https://www.bartleby.com/isbn_cover_images/9781337111348/9781337111348_smallCoverImage.gif)
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781938168383/9781938168383_smallCoverImage.gif)
![Functions and Change: A Modeling Approach to Coll…](https://www.bartleby.com/isbn_cover_images/9781337111348/9781337111348_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
![Trigonometry (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337278461/9781337278461_smallCoverImage.gif)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning