Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

eBook Problem 15-07 Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 21 3

eBook

Problem 15-07

Refer to the gasoline sales time series data in the given table.

Week Sales (1000s of gallons)
1 17
2 21
3 19
4 23
5 18
6 16
7 20
8 18
9 22
10 20
11 15
12 22

  1. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
Week Sales 4-Week Moving Average 5-Week Moving Average
1 17
2 21
3 19
4 23
5 18

fill in the blank 1

6 16

fill in the blank 2

fill in the blank 3

7 20

fill in the blank 4

fill in the blank 5

8 18

fill in the blank 6

fill in the blank 7

9 22

fill in the blank 8

fill in the blank 9

10 20

fill in the blank 10

fill in the blank 11

11 15

fill in the blank 12

fill in the blank 13

12 22

fill in the blank 14

fill in the blank 15

  1. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations to two decimal places and round your final answers to two decimal places. MSE for four-week moving average = fill in the blank 16 MSE for five-week moving average = fill in the blank 17
  2. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that MSE for the three-week moving average is 10.22.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Differential Equations

Authors: Kumari Vandana

1st Edition

9353147123, 9789353147129

More Books

Students also viewed these Mathematics questions

Question

List the four types of master records that are used in SAP ERP.

Answered: 1 week ago

Question

How do the events of normal aging affect life satisfaction?

Answered: 1 week ago