STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 22E
a.
To determine
To draw: The graph of the given time series.
b.
To determine
To explain: The pattern of the given time series.
c.
To determine
To explain: The reason for which forecasting with a seasonally adjusted trend model appropriate for the given time series data.
d.
To determine
To calculate: A seasonally adjusted trend forecasting model and the MAD.
e.
To determine
To calculate: The monthly indexes.
f.
To determine
To calculate: The forecasted sale for January, February, March, and April of 2019.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 toDecember 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find“Monthly Retail Trade Report,” then select “Time Series/Trend Charts.”)Year Month Sales ($ millions)2017 Jan $35,6302017 Feb 33,9722017 Mar 38,6222017 Apr 38,9732017 May 40,7392017 Jun 40,0092017 Jul 39,7972017 Aug 41,2172017 Sep 41,3462017 Oct 41,7172017 Nov 40,1862017 Dec 40,0462018 Jan 39,2232018 Feb 37,3772018 Mar 42,6482018 Apr 43,1092018 May 48,0492018 Jun 47,5462018 Jul…
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…
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.).
$ Sales
(Millions)
$ 486,565
Year
2009
549,473
608,790
672,550
735,374
785,142
842,120
877,743
911,157
943,538
2010
2011
2012
2013
2014
2015
2016
2017
2018
E Click here for the Excel Data File
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.)
Lagged
Residuals
Squared Difference
Squared Residuals
Year
Sales
Predicted
Residuals
2009
$
486,565
508,123.70
(21,558.70)
0.00
0.00
464,758,328.46
(10,455.50)
(2,943.26)
2010
549,473
559,928.50
2011
608,790
611,733.30
2012
672,550
663,538.00
9,011.96
2013
735,374
715,342.80
20,031.19
2014
785.142
767,147.60
17,994.41
2015
842.120
818,952.40…
Chapter 18 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
Knowledge Booster
Similar questions
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardIn 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data. Enter negative values as negative numbers. a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)arrow_forwardWhat do the Forecast for each year add up to?arrow_forward
- A box and whisker plots show what data?arrow_forwardHow does one do a trend analysis?arrow_forwardA new coronavirus recently triggered a global pandemic. It spreads from 5 cases in March to tens of thousands by May in the Philippines. Case contamination is comparable to what we call exponential spread. Create a table of values representing the covid19 confirmed cases in the Philippines during the first 15 days of March 2020. You can conduct your research online and then plot the results on a Cartesian plane. You can use paper and pencil or any graphing app that is appropriate. Questions to ponder: In order to slow down the growth, what can you do to the curve? In real-life, what must be done to flatten the curve? _________________arrow_forward
- Which type of data source provides real-time data? A. Historical data B. Survey data C. Transactional data D. Social media dataarrow_forwardPlease answer - About Forecastingarrow_forwardIN.gov reported a 70% decline in smoking rates amount middle school youth from 2000 to 2014. If 9.8 percent of Indiana’s middle school youth smoked in 2000, what percent were smoking in 2014arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL