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 35E
Consider the following time series data.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Show the four-quarter and centered moving average values for this time series.
- c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The results from a survey that collected annual household income is shown in the given table. Which of the following data types best describe these values?
Click the icon to view the annual household income.
Annual Household Income
OA. Ordinal
OB. Time series
OC. Cross-sectional
OD. Nominal
Annual Household Income
Household
Income ($000)
Under $30
$30 to under $40
$40 to under $50
$50 to under $60
$60 to under $70
Over $70
Print
Number of
Households
67
111
125
21
38
40
Done
MacBook Air
- X
Time Remaining: 01:24:09
Next
Consider the following time series data.
Week
1
4
5
6
Value
16
15
17
13
16
13
3.
Consider the following time series data:
Week
3 4 5 6
2.
1.
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
- For the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95, 90, and 92. a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data? Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following: b. MSE for 3-month moving average method c. MSE for exponential-smoothing method : d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing": e. What is the forecast for next month using the preferred method?arrow_forwardDescribe the following time-series patterns: a. Horizontal Pattern b. Trend Pattern c. Seasonal Pattern d. Cyclical Patternarrow_forwardPlease answer part B and Carrow_forward
- Use the following data to create a time series graph. You may draw the graph by hand or use technology. Be sure to use a title, and label the axes of your graph. Year U.S. Birth Rate per 1000 1980 3,612 1985 3,761 1990 4,158 1995 3,900 2000 4,059 2005 4,138 2010 3,999arrow_forwardConsider the following data: Year Deaths 2000 17,050 Number of Deaths in the U.S. by Drug Overdose 2003 2004 2002 2005 14,311 13,352 17,771 14,516 2001 17,510 2006 2007 11,153 18,656 2008 16,643 Step 1 of 2: Find the two-period moving average for the year 2005. If necessary, round your answer to one decimal place.arrow_forwardConsider the following time series data: Quarter 1 2 3 4 Year1 6 Cyclical pattern 2 3 5 O Trend pattern without seasonality Year2 O Horizontal pattern O Trend with seasonal pattern 6 3 Construct a time series plot, what type of pattern exists in the data? 5 7 Year3 7 6 6 8arrow_forward
- Using the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from https://www.census.gov/retail/index.html#mrts. Find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for U.S. new car sales.). Year $ Sales (Millions) 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538 b. Test for autocorrelation using the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Year $ Sales (Millions) Predicted Residuals Lagged Residuals Squared Difference Squared Residuals 2009 486,565 2010 549,473 2011 608,788 2012 672,550 2013 735,374 2014 785,142 2015 842,122 2016 877,743 2017 911,157 2018 943,538…arrow_forwardNo Religious Affiliation Trends. The following table gives the percentage of first-year college students who answered “None” when asked about their religious affiliation in selected years. Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Percentage claiming no religious affiliation 1985 9.4% 1990 12.3% 1995 14.0% 2000 14.9% 2005 17.4% 2010 23.0% 2015 29.5%arrow_forwardA consumer interest group is tracking the percentage of household income spent on gasoline over the past 30 years. Which graphical display would be more useful, a histogram or a time-series graph. Why? a. A histogram because the change in data over time is the most relevant issue.b. A time-series graph because the change in data over time is the most relevant issue. c. A time-series graph because the range of values for the data is the most relevant issue.6. A histogram because the range of values for the data is the most relevant issue.arrow_forward
- Using the following time series data of U.S. new car sales ($ millions), respond to the following items. (The data is sourced from Find "Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the https://www.census.gov/retail/index.html#mrts. data for U.S. new car sales.). Year $ Sales (Millions) 2009 2010 $ 486,565 549,473 2011 608,792 2012 672,550 2013 735,374 2014 785,142 2015 842,120 2016 2017 2018 877,743 911,157 943,538arrow_forwardConsider the following data: Year Deaths 2000 17,050 Number of Deaths in the U.S. by Drug Overdose 2001 2002 2003 2004 2005 2006 2007 2008 17,510 14,311 13,352 17,771 14,516 11,153 18,656 16,643 Step 2 of 2: Find the three-period moving average for the year 2005. If necessary, round your answer to one decimal place.arrow_forwardRefer 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.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
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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