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
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.6, Problem 39E
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 over the hours in the day. On July 15, 16, and 17, the following levels of nitrogen dioxide were observed in the downtown area for the 12 hours from 6:00 A.M. to 6:00 P.M.
- a. 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. Compute the linear trend equation for the deseasonalized data.
- e. Compute the deseasonalized trend forecasts for the 12 hours for July 18 and then adjust the trend forecasts using the seasonal indexes computed in part (b).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Athletes' heart rates were recorded after doing one minute of jumping jacks. The results were recorded in the shown frequency table. What is the median heart rate?
Explain if it is possible to obtain a negative value for SS (e.g. when calculating
variability for something like temperature).
MacBook Air
Pyramid Lake, Nevada, is described as the pride of the Paiute Indian Nation. It is a beautiful desert lake famous for very large trout. The elevation of the lake surface (feet above sea level) varies according to the annual flow of the Truckee River from Lake Tahoe. Assume that the U.S. Geological Survey provided the following data:
Year
1986
1987
1988
1989
1990
1991
1992
1993
Elevation
3817
3815
3810
3812
3808
3803
3798
3797
Year
1994
1995
1996
1997
1998
1999
2000
Elevation
3795
3797
3802
3807
3811
3816
3817
Make a time series graph.
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. With a smoothing constant of α = .2, equation...
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
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.Similar questions
- An earthquake in Mexico in 1985 had and intensity level about 125, 000, 000 times the reference intensity. Find the Richter number for that earthquake.arrow_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardWhen the light turns yellow, should you stop or go through it? A 2011 article defines the "indecision zone" as the period when a vehicle is between 2.5 and 5.5 seconds away from an intersection. At the intersection of Route 7 and North Shrewsbury in Clarendon, Vermont, 150 vehicles were observed to encounter a yellow light in the indecision zone, and 21 of them ran the red light. At the intersection of Route 62 and Paine Turnpike in Berlin, Vermont, 175 vehicles entered the intersection in the indecision zone, and 20 ran the red light. Can you conclude that the proportion of red-light runners differs between the two intersections? (A) Yes (B) Noarrow_forward
- The owner of Backstone Inc. opened 3 stores in different arts of the city and would like to compare the number of sales transactions made after 2months of operation. The number of sales transactions at the 3 stores are displayed in the chart below:arrow_forwardGraph the data in a scatter diagram: Age Calories 765 1520 15 2540 500 5. 795 17 2350 6. 1900 Use the paperclip button below to attach files. XDG BIUに ..arrow_forwardA researcher records the gender of each child born in the county hospital during the month of June. This researcher is measuring a discrete variable. O True O Falsearrow_forward
- When the light turns yellow, should you stop or go through it? An article defines the “indecision zone” as the period when a vehicle is between 2.5 and 5.5 seconds away from an intersection. At the intersection of Route 7 and North Shrewsbury in Clarendon, Vermont, 154 vehicles were observed to encounter a yellow light in the indecision zone, and 23 of them ran the red light. At the intersection of Route 62 and Paine Turnpike in Berlin, Vermont, 183 vehicles entered the intersection in the indecision zone, and 20 ran the red light. Can you conclude that the proportion of red-light runners differs between the two intersections? Find the P-value and state a conclusion. Round the answer to four decimal places. The P-value is 0.4472 0.4472 Incorrect . We can Incorrectconclude that the proportion of red-light runners differs between the two intersectionsarrow_forwardNow consider a bag of ten colorful marbles. You reach into the bag 100 times. Each time you pull out a marble, write down what color it was, then put it back in the bag and do it again. You record the following data: Table describing marble frequency Color Frequency Red 22 Yellow 9 Green 41 Blue 28arrow_forwardA hospital is using X bar and R charts to record the time it takes to process patient account information. A sample of five applications is taken each day. The first four weeks’ (20 days’) data give the following values: =16 min =7 min If the upper and lower specifications are 21 minutes and 13 minutes respectively, calculate , Cp and Cpk. Interpret the indices.arrow_forward
- A restaurant uses comment cards to get feedback from its customers about newly added items to the menu. It recently introduced homemade organic veggie burgers. Customers who tried the new burger were asked if they would order it again. The data is summarized in the table and bar graph. A. Convert this table into a relative frequency Round answers to the nearest tenth. B. Based upon the bar chart and the relative frequency table, would you recommend that the restaurant owner keeps the organic veggie burger on the menu? Explain yourarrow_forwardUse StatCrunch with the vehicle counts to the right observed during a survey of a student parking lot. Complete part A below. Category of vehicle Frequency American cars 28 Japanese cars 27 English cars 6 Other European cars 12 Motorcycles 7 a. Make a frequency table for the data. Include columns for relative and cumulative frequencies, and include a row at the bottom listing the totals for each column. Complete the frequency table below. Category of vehicle Frequency Relative Frequency Cumulative Frequency American cars 28 Japanese cars 27 English cars 6 Other European cars 12 Motorcycles 7 Totalarrow_forwardConstruct one table that includes relative frequencies based on the frequency distributions shown below, then compare the amounts of tar in nonfiltered and filtered cigarettes. Do the cigarette filters appear to be effective? (Hint: The filters reduce the amount of tar ingested by the smoker.) Click the icon to view the frequency distributions. Complete the following relative frequency table.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Algebra for College StudentsAlgebraISBN:9781285195780Author:Jerome E. Kaufmann, Karen L. SchwittersPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Intermediate AlgebraAlgebraISBN:9781285195728Author:Jerome E. Kaufmann, Karen L. SchwittersPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY