(b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. З Month 4 Month Month Sales Moving Average Moving Average 1 9.6 2. 9.4 3 9.2 4 9.7 9.40 9.8 9.43 9.48 6 9.9 9.57 9.53 7 9.7 9.80 9.65 10.6 9.80 O 9.78 9.9 10.07 10.00 10 9.6 10.07 10.03 11 9.7 10.03 9.95 12 9.5 9.73 9.95 Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits. 3-month 4-month moving moving average average MSE 0.170 0.229 9 9 9 9 O 9 9 OUUU
(b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. З Month 4 Month Month Sales Moving Average Moving Average 1 9.6 2. 9.4 3 9.2 4 9.7 9.40 9.8 9.43 9.48 6 9.9 9.57 9.53 7 9.7 9.80 9.65 10.6 9.80 O 9.78 9.9 10.07 10.00 10 9.6 10.07 10.03 11 9.7 10.03 9.95 12 9.5 9.73 9.95 Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits. 3-month 4-month moving moving average average MSE 0.170 0.229 9 9 9 9 O 9 9 OUUU
College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter1: Equations And Graphs
Section1.2: Graphs Of Equations In Two Variables; Circles
Problem 111E
Related questions
Question
Find the MSE for question (b)
![The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the
cost per unit for the firm's leading product over the past eight years.
Click on the datafile logo to reference the data.
DATA file
Year Cost/Unit ($)
Year Cost/Unit ($)
1.
20.00
26.60
2.
24.50
6.
30.00
3
28.20
31.00
4
27.50
8
36.00
(a) Choose the correct time series plot.
(i)
(ii)
40
40
35
35
30
30
25
10
10
5
5
1.
3
4
6
7
8
1
3
4
5
6
7
8
Year (t)
Year (t)
(ii)
40
(iv)
40
35
35
30
30
25
E 25
($) yun/as03
Cost/Unit ($)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd03418ea-202b-4e18-869c-af9abd70547a%2Fc0b947f2-2045-4f6f-b5c2-4c5666684737%2Ft0rjb9q_processed.png&w=3840&q=75)
Transcribed Image Text:The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the
cost per unit for the firm's leading product over the past eight years.
Click on the datafile logo to reference the data.
DATA file
Year Cost/Unit ($)
Year Cost/Unit ($)
1.
20.00
26.60
2.
24.50
6.
30.00
3
28.20
31.00
4
27.50
8
36.00
(a) Choose the correct time series plot.
(i)
(ii)
40
40
35
35
30
30
25
10
10
5
5
1.
3
4
6
7
8
1
3
4
5
6
7
8
Year (t)
Year (t)
(ii)
40
(iv)
40
35
35
30
30
25
E 25
($) yun/as03
Cost/Unit ($)
![(b) Develop three-month and four-month moving averages for this time series.
If required, round your answers to two decimal places.
з
З Month
4 Month
Month
Sales
Moving Average Moving Average
1
9.6
2
9.4
3
9.2
4
9.7
9.40
9.8
9.43
9.48
9.9
9.57
9.53
7
9.7
9.80 O
9.65
8
10.6
9.80
9.78
9
9.9
10.07
10.00
10
9.6
10.07
10.03
11
9.7
10.03
9.95
12
9.5
9.73
9.95
Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits.
3-month
4-month
moving
moving
average
average
MSE
0.170
0.229 8](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd03418ea-202b-4e18-869c-af9abd70547a%2Fc0b947f2-2045-4f6f-b5c2-4c5666684737%2Fmmvxw5v_processed.png&w=3840&q=75)
Transcribed Image Text:(b) Develop three-month and four-month moving averages for this time series.
If required, round your answers to two decimal places.
з
З Month
4 Month
Month
Sales
Moving Average Moving Average
1
9.6
2
9.4
3
9.2
4
9.7
9.40
9.8
9.43
9.48
9.9
9.57
9.53
7
9.7
9.80 O
9.65
8
10.6
9.80
9.78
9
9.9
10.07
10.00
10
9.6
10.07
10.03
11
9.7
10.03
9.95
12
9.5
9.73
9.95
Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits.
3-month
4-month
moving
moving
average
average
MSE
0.170
0.229 8
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781305115545/9781305115545_smallCoverImage.gif)
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
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/9781305115545/9781305115545_smallCoverImage.gif)
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
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