Question: all the answers given are wrong. i got all th answers wrong Refer to the gasoline sales time series data in the given table. Week

all the answers given are wrong. i got all th

all the answers given are wrong.

i got all th answers wrong

Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) | | 12 120 1 3 18 4 24 5 18 6 16 7 22 9 22 10 20 11 16 11222 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Moving Average Moving Average Week Sales 17 1 2 3 4 20 18 24 1 19.75 20 19.40 19 19.20 20 19.60 22 | 18.75 19.80 19.40 19.75 20.75 19.25 16 22 19.80 12 19.80 b. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. MSE for four-week moving average = 8.73 MSE for five-week moving average = 6.32 c. 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.93. Five

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Refer to the gasoline sales time series data in Table below to answer the following (Copy the file to Excel when done submit here) 1. Compute two- week , three-week and four-week moving averages for...

Refer to the gasoline sales time series data in Table 15.1. a. Compute four-week and five-week moving averages for the time series. b. Compute the MSE for the four-week and five-week moving average...

Can you show how to do it in Excel with the formulas? 7. Refer to the gasoline sales time series data in Table 15.1. a. Compute four-week and five-week moving averages for the time series. b. Compute...

only part C with methodology Problems / Solutions 7. Refer to the gasoline sales time series data in Table 6.1. Compute four-week and five week moving averages for the time series. a. Sales Week...

refer to the gasoline sales time series data in Table 6.1. a. Compute four-week and five-week moving averages for the time series. b. Compute the mSe for the four-week and five-week moving average...

SOLVE IN EXCEL 7. Refer to the gasoline sales time series data in Table 15.1. A. Compute four-week and five-week moving averages for the time series. B. Compute the MSE for the four-week and...

Refer to the gasoline sales time series data in the given table. I will thumbs up. Thank you! Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales...

Refer to the gasoline sales time series data in the given table Week 1 Sales (1,000s of gallons) 17 23 2 3 14 4 25 5 17 6 16 7 22 19 9 21 10 19 11 12 12 23 (a) Compute four-week and five-week moving...

Question Content Area Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 20 3 19 4 23 5 19 6 15 7 22 8 17 9 23 10 19 11...

The 16-point signal x(n) is given by x(n) = sin(22n/N) , 0 n N 1 where N = 16 (a) Roughly sketch the signal for 0 n 15. Do not explicitly calculate the values. (b) Find the DFT coefficients of...

Write a paper about Bank of Montreal presenting your article provide a brief summary and make clear its connection to your analysis. Develop the important facts in the case that need to be...

which governmental fund includes resources that are legally restricted so that the government entity must maintain

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...