Basic Business Statistics, Student Value Edition (13th Edition)
13th Edition
ISBN: 9780321946393
Author: Mark L. Berenson, David M. Levine, Kathryn A. Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 49PS
a.
To determine
Construct a time series plot.
b.
To determine
Explain the changes appearing in annual sales over time.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
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
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.
Chapter 2 Solutions
Basic Business Statistics, Student Value Edition (13th Edition)
Ch. 2 - A categorical variable has three categories, with...Ch. 2 - The following data represent the responses to two...Ch. 2 - The following table, stored in smartphone sales,...Ch. 2 - The Edmunds.com NHTSA Complaints Activity Report...Ch. 2 - The 2013 Mortimer Spinks and Computer Weekly...Ch. 2 - The following table represents world oil...Ch. 2 - Visier’s Survey of Employers explores how North...Ch. 2 - A survey of 1,085 adults asked “Do you enjoy...Ch. 2 - Prob. 9PSCh. 2 - Do special recommendations increase ad...
Ch. 2 - Construct an ordered array, given the following...Ch. 2 - Construct an ordered array, given the following...Ch. 2 - Prob. 13PSCh. 2 - Prob. 14PSCh. 2 - Prob. 15PSCh. 2 - The file Utility contains the following data about...Ch. 2 - How much time do commuters living in or near...Ch. 2 - How do the average credit scores of people living...Ch. 2 - One operation of a mill is to cut pieces of steel...Ch. 2 - Prob. 20PSCh. 2 - Prob. 21PSCh. 2 - Prob. 22PSCh. 2 - The file Drink Contains the following data for the...Ch. 2 - Prob. 24PSCh. 2 - Prob. 25PSCh. 2 - Prob. 26PSCh. 2 - Prob. 27PSCh. 2 - Prob. 28PSCh. 2 - Prob. 29PSCh. 2 - Prob. 30PSCh. 2 - Prob. 31PSCh. 2 - Do special recommendations increase ad...Ch. 2 - Construct a stern-and-leaf display, given the...Ch. 2 - Construct an ordered array, given the following...Ch. 2 - The following is a stern-and0-leaf display...Ch. 2 - Prob. 36PSCh. 2 - The file MobileSpeed contains the overall download...Ch. 2 - The file Utility contains the following data about...Ch. 2 - Prob. 39PSCh. 2 - Prob. 40PSCh. 2 - How much time do Americans living in or near...Ch. 2 - How do the average credit scores of people living...Ch. 2 - One operation of a mill is to cut pieces of steel...Ch. 2 - Prob. 44PSCh. 2 - Prob. 45PSCh. 2 - Prob. 46PSCh. 2 - The data stored in Drink represents the amount of...Ch. 2 - The following is a set of data from a sample of...Ch. 2 - Prob. 49PSCh. 2 - Movie companies need to predict the gross receipts...Ch. 2 - Data were collected on the typical cost of dining...Ch. 2 - Prob. 52PSCh. 2 - Prob. 53PSCh. 2 - How have stocks performed in the past? The...Ch. 2 - Prob. 55PSCh. 2 - Prob. 56PSCh. 2 - The file Audits contains the number of audits of...Ch. 2 - Prob. 58PSCh. 2 - Prob. 59PSCh. 2 - Prob. 60PSCh. 2 - Using the sample of retirement funds stored in...Ch. 2 - Prob. 65PSCh. 2 - Prob. 66PSCh. 2 - Examine the following visualization, adapted from...Ch. 2 - Prob. 69PSCh. 2 - Prob. 70PSCh. 2 - How do histograms and polygons differ in...Ch. 2 - Why would you construct a summary table?Ch. 2 - What are the advantages and disadvantage of using...Ch. 2 - Compare and contrast the bar chart for categorical...Ch. 2 - What is the difference between a time-series plot...Ch. 2 - Why is it said that the main feature of a Pareto...Ch. 2 - What are the three different ways to break down...Ch. 2 - How can a multidimensional table differ from a...Ch. 2 - What type of insights can you gain from a...Ch. 2 - The following summary, table, presents the...Ch. 2 - The following table represents the market share...Ch. 2 - Prob. 82PSCh. 2 - The owner of a restaurant that services...Ch. 2 - Prob. 84PSCh. 2 - The following data represents the pounds per...Ch. 2 - Prob. 86PSCh. 2 - One of the major measures of the quality of...Ch. 2 - Prob. 88PSCh. 2 - Prob. 89PSCh. 2 - Prob. 90PSCh. 2 - Prob. 91PSCh. 2 - Prob. 92PSCh. 2 - What was the average price of a room at two-star,...Ch. 2 - The file Protein contains calorie and cholesterol...Ch. 2 - The file Natural Gas contains the U.S. monthly...Ch. 2 - Prob. 96PSCh. 2 - Prob. 97PSCh. 2 - A/B testing allows business to test a new design...
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
- After 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_forwardFor the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?arrow_forwardThe elevation of a lake surface (feet above sea level) varies according to the annual flow of a river that feeds it. A geological survey provided the following data from equally spaced intervals of time over a 15 year period. Time Period Elevation 1 4817 2 4819 3 4824 4 4822 5 4826 6 4831 7 4836 8 4837 9 4839 10 4837 11 4832 12 4827 13 4823 14 4818 15 4817 Make a time-series graph displaying the data.arrow_forward
- consider the following time series data.t 1 2 3 4 5 6 7yt10 9 7 8 6 4 4a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for this time series.c. What is the forecast for t = 8?arrow_forward#4) Commuter ridership in Athens, Greece, during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the data are given in the following table. Year Number of Tourists (millions) Ridership (hundreds of thousands) 1 6 11 2 11 16 3 8 16 4 10 14 5 19 28 6 18 26 7 16 21 8 20 25 9 24 45 10 18 28 11 11 18 12 19 35 a) Create a time series plot for the ridership. b) Using linear regression to see if using the year is a good predictor for the ridership. What is the regression equation? How accurate is the model? c) Using linear regression to see if using the number of tourists is a good predictor for the ridership. What is the regression equation? How accurate is the model? d) Which linear regression equation is better? What is the expected ridership if 10 million tourists visit the city next year? e) Excel Filearrow_forwardThe folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Admissions Year Admissions 1945 79.0 1985 20.30 1955 39.9 1995 23.3 1965 19.8 2005 26.5 1975 19.9 2015 25.4arrow_forward
- corporate triple-a bond interest rates for 12 consecutive months follow.9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6a. construct a time series plot. What type of pattern exists in the data?b. develop three-month and four-month moving averages for this time series. does thethree-month or four-month moving average provide more accurate forecasts basedon MSe? explain.arrow_forwardUsing 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.arrow_forwardThe 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?arrow_forward
- Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?arrow_forwardCoca-Cola Revenues ($ millions), 2014 to 2019 Quarter 2014 2015 2016 2017 2018 2019 Quarter 1 10.58 9.94 10.28 9.12 7.63 8.02 Quarter 2 12.57 11.63 11.54 9.70 9.42 10.00 Quarter 3 11.98 11.77 10.63 9.08 8.78 9.51 Quarter4 10.87 10.13 9.41 7.51 5.36 9.07 What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.) Use the regression equation to make a prediction for each quarter in 2020. (Enter your answers in millions rounded to 3 decimal places.)arrow_forwardA statistical program is recommended. The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1,690 1,800 1,860 2 950 910 1,110 3 2,625 2,910 2,940 4 2,510 2,370 2,615 (a) Construct a time series plot. What type of pattern exists in the data? There appears be a downward linear trend but no seasonal pattern in the data.There appears to be a seasonal pattern in the data and perhaps a moderate upward linear trend. There appears be an upward linear trend but no seasonal pattern in the data.There appears to be a seasonal pattern in the data and perhaps a moderate downward linear trend. (b) Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to the nearest integer.) Qrt1 = 1 if quarter 1, 0 otherwise; Qrt2 = 1 if quarter 2, 0 otherwise; Qrt3 = 1 if quarter 3, 0 otherwise t =…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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