Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 17.5, Problem 31E

Air pollution control specialists in southern California monitor the amount of ozone, carbon dioxide, and nitrogen dioxide in the air on an hourly basis. The hourly time series data exhibit seasonality, with the levels of pollutants showing patterns that vary over the hours in the day. On July 15, 16, and 17, the following levels of nitrogen dioxide were observed for the 12 hours from 6:00 A.M. to 6:00 P.M.

Chapter 17.5, Problem 31E, Air pollution control specialists in southern California monitor the amount of ozone, carbon

  1. a. Construct a time series plot. What type of pattern exists in the data?
  2. b. Use the following dummy variables to develop an estimated regression equation to account for the seasonal effects in the data.

    Hour1 = 1 if the reading was made between 6:00 A.M. and 7:00 A.M.; 0 otherwise

    Hour2 = 1 if if the reading was made between 7:00 A.M. and 8:00 A.M.; 0 otherwise

    .

    .

    .

    Hour11 = 1 if the reading was made between 4:00 P.M. and 5:00 P.M., 0 otherwise.

    Note that when the values of the 11 dummy variables are equal to 0, the observation corresponds to the 5:00 P.M. to 6:00 P.M. hour.

  3. c. Using the estimated regression equation developed in part (a), compute estimates of the levels of nitrogen dioxide for July 18.
  4. d. Let t = 1 to refer to the observation in hour 1 on July 15; t = 2 to refer to the observation in hour 2 of July 15; … and t = 36 to refer to the observation in hour 12 of July 17. Using the dummy variables defined in part (b) and t, develop an estimated regression equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute estimates of the levels of nitrogen dioxide for July 18.
Blurred answer
Students have asked these similar questions
sam and ava compared the weights of their puppies each month during the first half of 2015. The graphs generated from this data are shown below
air pollution control specialists in southern california monitor the amount of ozone, carbon dioxide, and nitrogen dioxide in the air on an hourly basis. the hourly time series dataexhibit seasonality, with the levels of pollutants showing patterns over the hours in theday. on july 15, 16, and 17, the following levels of nitrogen dioxide were observed in thedowntown area for the 12 hours from 6:00 a.m. to 6:00 p.m.July 15: 25 28 35 50 60 60 40 35 30 25 25 20July 16: 28 30 35 48 60 65 50 40 35 25 20 20July 17: 35 42 45 70 72 75 60 45 40 25 25 25a. construct a time series plot. What type of pattern exists in the data?
air pollution control specialists in southern california monitor the amount of ozone, carbon dioxide, and nitrogen dioxide in the air on an hourly basis. the hourly time series dataexhibit seasonality, with the levels of pollutants showing patterns over the hours in theday. on july 15, 16, and 17, the following levels of nitrogen dioxide were observed in thedowntown area for the 12 hours from 6:00 a.m. to 6:00 p.m.July 15: 25 28 35 50 60 60 40 35 30 25 25 20July 16: 28 30 35 48 60 65 50 40 35 25 20 20July 17: 35 42 45 70 72 75 60 45 40 25 25 25a. construct a time series plot. What type of pattern exists in the data?b. identify the hourly seasonal indexes for the 12 readings each day.c. deseasonalize the time series.d. Using Minitab or excel, compute the linear trend equation for the deseasonalized data.e. compute the deseasonalized trend forecasts for the 12 hours for july 18 and then adjustthe trend forecasts using the seasonal indexes computed in part (b).

Chapter 17 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in $...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series. Construct a...Ch. 17.5 - Consider the following time series...Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies, Inc., supplies milk to several...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY