Introduction to Statistics and Data Analysis
5th Edition
ISBN: 9781305115347
Author: Roxy Peck; Chris Olsen; Jay L. Devore
Publisher: Brooks Cole
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 60CR
a.
To determine
Construct a time series plot.
b.
To determine
Comment on the trend of percentage changes over time.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
the data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?
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?
In retail, a store manager uses time series models to understand shopping trends.
Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image.
Here is the data for Fiscal Year and Sales:
Fiscal Year
Sales
2010
$260,123.00
2011
$256,853.00
2012
$274,366.00
2013
$290,525.00
2014
$322,318.00
2015
$380,921.00
2016
$541,925.00
2017
$909,050.00
2018
$1,817,521.00
2019
$3,206,564.00
2020
$4,921,005.00
2021
$5,686,338.00
Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components?
The model can be additive or multiplicative. When do you use each?
Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe?
What predictions might you make about the store’s annual sales over the next few years?
Chapter 3 Solutions
Introduction to Statistics and Data Analysis
Ch. 3.1 - Each person in a nationally representative sample...Ch. 3.1 - The graphical display on the next page is similar...Ch. 3.1 - Prob. 3ECh. 3.1 - The National Confectioners Association asked 1006...Ch. 3.1 - College student attitudes about e-books were...Ch. 3.1 - Prob. 6ECh. 3.1 - Prob. 7ECh. 3.1 - Prob. 8ECh. 3.1 - Prob. 9ECh. 3.1 - The survey on student attitude toward e-books...
Ch. 3.1 - Prob. 11ECh. 3.1 - Prob. 12ECh. 3.1 - An article about college loans (New Rules Would...Ch. 3.1 - Prob. 14ECh. 3.2 - Prob. 15ECh. 3.2 - Prob. 16ECh. 3.2 - Prob. 17ECh. 3.2 - The article Economy Low, Generosity High (USA...Ch. 3.2 - Prob. 19ECh. 3.2 - A report from Texas Transportation Institute...Ch. 3.2 - The percentage of teens not in school or working...Ch. 3.3 - Prob. 22ECh. 3.3 - The accompanying data on annual maximum wind speed...Ch. 3.3 - The accompanying relative frequency table is based...Ch. 3.3 - Prob. 25ECh. 3.3 - Medicares new medical plans offer a wide range of...Ch. 3.3 - The following two relative frequency distributions...Ch. 3.3 - Prob. 28ECh. 3.3 - The report Trends in College Pricing 2012...Ch. 3.3 - An exam is given to students in an introductory...Ch. 3.3 - The accompanying frequency distribution summarizes...Ch. 3.3 - Example 3.19 used annual rainfall data for...Ch. 3.3 - Prob. 33ECh. 3.3 - Prob. 34ECh. 3.3 - Prob. 35ECh. 3.3 - Prob. 36ECh. 3.3 - Using the five class intervals 100 to 120, 120 to...Ch. 3.4 - Prob. 38ECh. 3.4 - Consumer Reports Health (consumerreports.org) gave...Ch. 3.4 - Prob. 40ECh. 3.4 - Prob. 41ECh. 3.4 - Prob. 42ECh. 3.4 - Prob. 43ECh. 3.4 - Prob. 44ECh. 3.4 - The accompanying time series plot of movie box...Ch. 3.5 - The accompanying comparative bar chart is similar...Ch. 3.5 - Prob. 47ECh. 3.5 - The figure at the top right of the next page is...Ch. 3.5 - The two graphical displays below are similar to...Ch. 3.5 - The following graphical display is similar to one...Ch. 3.5 - Explain why the following graphical display...Ch. 3 - Prob. 52CRCh. 3 - Prob. 53CRCh. 3 - Prob. 54CRCh. 3 - The Connecticut Agricultural Experiment Station...Ch. 3 - The stem-and-leaf display of Exercise 3.55 uses...Ch. 3 - Prob. 57CRCh. 3 - Prob. 58CRCh. 3 - Does the size of a transplanted organ matter? A...Ch. 3 - Prob. 60CRCh. 3 - Prob. 61CRCh. 3 - Prob. 62CRCh. 3 - The article Tobacco and Alcohol Use in G-Rated...Ch. 3 - Prob. 64CRCh. 3 - Prob. 65CRCh. 3 - Prob. 66CRCh. 3 - Prob. 67CRCh. 3 - Prob. 68CRCh. 3 - Prob. 69CRCh. 3 - Many nutritional experts have expressed concern...Ch. 3 - Americium 241 (241Am) is a radioactive material...Ch. 3 - Does eating broccoli reduce the risk of prostate...Ch. 3 - An article that appeared in USA TODAY (August 11,...Ch. 3 - Sometimes samples are composed entirely of...Ch. 3 - Prob. 4CRECh. 3 - More than half of Californias doctors say they are...Ch. 3 - Based on observing more than 400 drivers in the...Ch. 3 - An article from the Associated Press (May 14,...Ch. 3 - Prob. 8CRECh. 3 - Prob. 9CRECh. 3 - Prob. 10CRECh. 3 - The article Determination of Most Representative...Ch. 3 - The paper Lessons from Pacemaker Implantations...Ch. 3 - How does the speed of a runner vary over the...Ch. 3 - Prob. 14CRECh. 3 - One factor in the development of tennis elbow, a...Ch. 3 - An article that appeared in USA TODAY (September...
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
- 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.)arrow_forwardAfter its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardFind the MSE in part (b) please.arrow_forward
- the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.arrow_forwardI need some help with the following problems on excel.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
- In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forwardPlease answer part B and Carrow_forwardHelp please. I am extremely confused and do not understand this! Can I get help with all parts please?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage LearningBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher: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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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