STAT TECH IN BUSINESS & ECON LL\AC
18th Edition
ISBN: 9781264720545
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 21E
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 solution
Students 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…
The following data report total, monthly U.S. book-store sales in millions of dollars from January 2016 to March 2019. (Go to https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for the total U.S. bookstore sales.)YearMonth 2016 2017 2018 2019January $1,468 $1,386 $1,271 $1,144February 727 691 709 666March 719 707 734 685April 709 729 710May 778 781 787June 713 704 727July 687 669 701August 1,524 1,374 1,364September 1,064 997 986October 715 689 741November 742 703 768December 1,256 1,157 1,259
g. Predict book sales for the next 9 months. (Round your answers to 4 decimal places.)Year Month Forecast…
The following data report total, monthly U.S. book-store sales in millions of dollars from January 2016 to March 2019. (Go to https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for the total U.S. bookstore sales.)YearMonth 2016 2017 2018 2019January $1,468 $1,386 $1,271 $1,144February 727 691 709 666March 719 707 734 685April 709 729 710May 778 781 787June 713 704 727July 687 669 701August 1,524 1,374 1,364September 1,064 997 986October 715 689 741November 742 703 768December 1,256 1,157 1,259 c. Which forecasting model is appropriate based on the data for the total U.S. bookstore sales?Appropriate model____________d. Evaluate a seasonally adjusted trend…
Chapter 18 Solutions
STAT TECH IN BUSINESS & ECON LL\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_forwardUsing 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…arrow_forwardUsing 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_forward
- Use a graphing calculator to make a scatter plot of the amounts Leah willaccumulate for years 1 through 5.arrow_forwardComplete the following: Draw a scatter plot of the data below. b. Draw a trend line. Write its equation Estimate the number of Youtube subscribers in 2030. 5. a. C. Year 2005 2010 2015 2020 Subscribers in Millions 17.7 39.9 54.9 63.0arrow_forwardThe price per share of stock for a sample of 25 companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following. Click on the datafile logo to reference the data. DATA file a. Let di denote the percentage change in price per share for company i where 7.46 Confidence interval Interpret this result. The stock market experiences a decline Company Bank of New York Mellon Kraft Foods E.I. du Pont de Nemours and Company Consolidated Edison ) (to 3 decimals) Johnson & Johnson Union Pacific Comcast Applied Materials. Pfizer General Electric AT&T Cisco Systems Home Depot ✔ JP Morgan Chase Procter & Gamble Verizon Devon Energy Lilly Microsoft Coca Cola Qualcomm Exxon Mobil Corporation PG&E Corporation Oracle Corporation Chevron end of 1st quarter…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
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