Refer to the gasoline sales time series data in the given table.Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places.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 12.89. Refer to the gasoline sales time series data in the given table.Week1234567891011Week121234a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.567891011122218221715211722Sales Moving Average Moving Average1819Sales (1000s of gallons)14234-Week1822182217152117MSE for four-week moving average =221914MSE for five-week moving average =235-Weekb. ompute MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal placc. 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 12.89.

The given time series data for the gasoline sales is as follows:WeekSales…

Refer to the gasoline sales time series data in the given table. Week 1 2 3 4 5 6 7 8 9 10 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 11 Week 12 1 2 3 4 5 6 7 8 9 10 11 12 18 22 17 15 21 17 22 Sales Moving Average Moving Average 18 22 19 Sales (1000s of gallons) 14 23 18 22 18 22 17 15 21 17 22 4-Week 19 14 23 5-Week 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 = MSE for five-week moving average = 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 12.89.

Refer to the gasoline sales time series data in the given table. Week 1 2 3 4 5 6 7 8 9 10 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 11 Week 12 1 2 3 4 5 6 7 8 9 10 11 12 18 22 17 15 21 17 22 Sales Moving Average Moving Average 18 22 19 Sales (1000s of gallons) 14 23 18 22 18 22 17 15 21 17 22 4-Week 19 14 23 5-Week 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 = MSE for five-week moving average = 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 12.89.

Algebra & Trigonometry with Analytic Geometry

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter5: Inverse, Exponential, And Logarithmic Functions

Section5.6: Exponential And Logarithmic Equations

Problem 69E

See similar textbooks

Similar questions

The following ratio-to-moving averages for the seasonally adjusted series were found by the decomposition method applied on a time series representing quarterly sales for January 2018 to December 2020 period: a. Calculate the Seasonal Index for every quarter. b. If the trend is described by the trend line T^ = 1,000 + 30 t, what is the forecast for the fourth quarter of 2021?
Using the time series data in the table, respond to the following items. Period Sales 1 $ 615 2 676 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 Please show work, thanks.
The table below contains the average price paid for a new home in a certain area from 2000 to 2010. a. Construct a time-series plot of new home prices. b. What pattern, if any, is present in the data? Year Average_Price_($_thousands)2000 351.12001 330.52002 310.52003 296.72004 229.72005 182.32006 154.52007 156.32008 154.72009 154.52010 154.5
consider the following time series data.Month 1 2 3 4 5 6 7Value 24 13 20 12 19 23 15a. compute MSe using the most recent value as the forecast for the next period. Whatis the forecast for month 8?b. compute MSe using the average of all the data available as the forecast for the nextperiod. What is the forecast for month 8?c. Which method appears to provide the better forecast?
Refer to the gasoline sales time series data in the given table. Click on the datafile logo to reference the data. 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. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (b) Compute the MSE for the four-week and five-week moving average forecasts. If required, round your intermediate calculations to four decimal places and round your final answers to three decimal places. MSE for four-week moving average = MSE for five-week moving average = (c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving…
The following data set provides the total number of shipments of core major household appliances in the U.S. from 2000 to 2016 (in millions): Year Shipments (millions) 2000 38.4 2001 38.2 2002 40.8 2003 42.5 2004 46.1 2005 47.0 2006 46.7 2007 44.1 2008 39.8 2009 36.5 2010 38.2 2011 36.0 2012 35.8 2013 39.2 2014 41.5 2015 42.9 2016 44.7 a. Plot the time series. b. Fit a three-year moving average to the data and plot the results. c. Fit a five-year moving average to the data and plot the results. d. Compute a linear trend forecasting equation and plot the trend line. e. Compute a quadratic trend forecasting equation and plot the results.
The following table shows the daily receipts in millions of dollars of the movie "Avatar" for successive Fridays after its opening on Friday 18 December 2009. Weeks $Receipts 2 68.49 4 42.785 6 31.28 8 23.611 10 13.655 12 6.526 14 2.047 16 0.844 18 0.92 20 0.425 22 0.188 24 0.076 26 0.045 28 0.028 Estimate the instantaneous rate of change of daily receipts 14 weeks after the opening day. Round to four decimal places..
The following is a time series for the last 6 months of 2016 50 54 65 58 70 68 The three (3) point moving averages are:
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 22 3 18 4 22 5 18 6 16 7 20 8 19 9 23 10 21 11 14 12 23 Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 PeriodMoving Average 5 PeriodMoving Average 1 18 2 22 3 18 4 22 5 18 6 16 7 20 8 19 9 23 10 21 11 14 12 23 Compute the MSE for the four-week and five-week moving average forecasts. If required, round your intermediate calculations to four decimal places and round your final answers to three decimal places.MSE for four-week moving average = MSE for five-week moving average =
John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)
Each person in random samples of 207 male and 263 female working adults living in a certain town in Canada was asked how long, in minutes, his or her typical daily commute was. (Use a statistical computer package to calculate the P-value. Use μmales − μfemales. Round your test statistic to two decimal places, your df down to the nearest whole number, and your P-value to three decimal places.) Males Females Samplesize x s Samplesize x s 207 29.6 24.0 263 27.3 24.3 t = df = P-value =
Kaitlyn measures the upload speed in megabits per second of her home broadband internet connection during peak hours and off-peak hours. The results are provided in the accompanying table. Peak Off-Peak 5.83 5.14 6.05 6.80 7.14 6.98 3.54 5.77 5.45 7.27 5.90 6.62 5.81 6.19 4.82 6.08 6.37 6.59 4.65 5.58 5.30 7.41 6.48 6.26 5.96 6.37 5.79 6.31 6.84 6.55 5.06 4.95 5.61 7.03 6.45 6.77 Examine the results of Kaitlyn's test to determine the statements that compare the medians and interquartile ranges of the data sets to each other in terms of this situation. Select the two correct answers. The median upload speed during peak hours is 5.905 megabits per second, which is less than the median upload speed during off-peak hours, 7.005 megabits per second. The upload speeds during peak hours are slower on average compared to off-peak times. The median upload speed during peak hours is 6.37 megabits per second, which is greater than the median upload speed during…