Question

In: Math

Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...

Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks.

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

(a)

Compute four-week and five-week moving averages for the time series.

Week Time Series
Value
4-Week
Moving
Average
Forecast
5-Week
Moving
Average
Forecast
1 17
2 22
3 20
4 24
5 19
6 17
7 21
8 18
9 23
10 21
11 16
12 22

(b)

Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) __________

Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) ____________

Solutions

Expert Solution


Related Solutions

Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 21 8 19 9 23 10 21 11 16 12 23 (a) Using a weight of 1/2  for the most recent observation, 1/3 for the second most recent observation, and 1/6  for third most recent observation, compute a three-week weighted moving...
These data show the number of gallons of gasoline sold by a gasoline distributor in Bennington,...
These data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000s 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 (a) Compute four-week and five-week moving averages for the time series. Week Time Series Value 4-Week Moving Average Forecast 5-Week Moving Average Forecast 1 17 2 21 3 19...
Problem 1: The following table shows the number of gallons of gasoline sold by a gasoline...
Problem 1: The following table shows the number of gallons of gasoline sold by a gasoline distributor in Providence, Rhode Island, over the past 7 weeks. Forecast sales using a 3-week weighted moving average where the weights are 3, 2, and 1. Week Sales (100s of Gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20
Bob Nale would like to determine the mean number of gallons of gasoline sold to his...
Bob Nale would like to determine the mean number of gallons of gasoline sold to his customers. Assume the number gallons of gasoline sold is 2 gallons. From his records, he selects 64 samples and finds the mean is 9 gallons. Find the 95% confidence interval for the population mean.
Suppose that the number of gallons of milk sold per day at a local supermarket are...
Suppose that the number of gallons of milk sold per day at a local supermarket are normally distributed with mean and standard deviation of 419.9 and 26.93, respectively. What is the probability that on a given day the supermarket will sell between 432 and 438 gallons of milk? Question 2 options: 1) We do not have enough information to calculate the value. 2) 0.0036 3) 0.2508 4) 0.6734 5) 0.0758 Suppose that the mean and standard deviation of the scores...
Suppose that the average household in a state consumes 1000 gallons of gasoline per year. A...
Suppose that the average household in a state consumes 1000 gallons of gasoline per year. A 20-cent gasoline tax is introduced, coupled with a $160 annual tax rebate per household. Will the household be better or worse off under the new program? Graphically show how you arrived at your answer
The data in the table show the number of pounds of bananas sold per week at...
The data in the table show the number of pounds of bananas sold per week at a grocery store when the banana display was positioned in the produce, milk, and cereal sections of the store. a) Perform a one-way ANOVA using alphaαequals=0.05 to determine if there is a difference in the average number of pounds of bananas sold per week in these three locations. b) If warranted, perform a multiple comparison test to determine which pairs are different using alphaαequals=0.050...
The average number of gallons of lemonade sold during a baseball game is 20, with a...
The average number of gallons of lemonade sold during a baseball game is 20, with a standard deviation of 3 gallons. Assume the amount of lemonade sold is normally distributed. When a game is played, find the probability that the amount of lemonade sold is: A) If 10 games are played, find the probability that the mean amount of lemonade sold is less than 19 gallons
3. The general manager of Gordon's Self-Service Gasoline wants to estimate the mean number of gallons...
3. The general manager of Gordon's Self-Service Gasoline wants to estimate the mean number of gallons of gasoline that are purchased by customers at his Kansas City locations. He would like the estimate to be within plus or minus 0.50 gallons. Based on past studies, the standard deviation of the amount purchased is 4.0 gallons. a. How large must the sample be for him to be 99% confident about that estimate? b. How large must the sample be for him...
An underground gasoline tank can hold 1.00x10^3 gallons of gasoline at 52.0 degrees F. If the...
An underground gasoline tank can hold 1.00x10^3 gallons of gasoline at 52.0 degrees F. If the tank is being filled on a cool morning when the outdoor temperature (and the gasoline in the tanker truck) is 32.0 degrees F, how many gallons from the truck can be poured in the tank? (b) Generally speaking, coefficients of thermal expansion of metals are two magnitudes smaller than that of gasoline's. If you would like to maximize the time or distance between gas...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT