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 19E
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 quarterly indexes.
f.
To determine
To calculate: The forecasted sale for next four time periods.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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,538
Please answer part B and C
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…
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
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardThe US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forward
- ncreased sales during the Christmas season is known as a. secular b. seasonal trend c. Cyclical trend d .irregular trendarrow_forwardusing the data from the images, compare and analyze the trends shown on the graphs and relate them to the question: does chronic cigarette smoking affect the birth weight and gestational period of a newborn baby? Also please mention something regarding parents who don't smoke and their baby's results. Birth weight Gestational period Birthweight Gestational period 2.65 33 1.92 33 2.9 39 2.05 35 2.92 34 2.37 37 3.03 39 2.51 39 3.11 37 2.66 35 3.15 40 2.74 39 3.2 41 2.75 40 3.23 38 2.78 37 3.27 40 3 38 3.35 41 3.14 41 3.42 38 3.18 38 3.63 38 3.19 41 3.65 42 3.32 40 3.77 40 3.32 39 3.93 38 3.41 39 3.94 42 3.53 40 4.07 44 3.55 41 4.1 41 3.59 40 4.32 40 3.64 40 4.55 44 3.86 39 (non smoking) 3.87 45 4.57 41arrow_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_forward
- 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_forwardTime Series Graphing Exercise Air Quality The following data show the number of days the air quality for Atlanta, Georgia, was below the accepted standards. Draw a time series graph for the data shown below. The times series graph maybe completed using excel or hand generated. If hand generated take a picture of the graph and attach the photo. Interpret the results. . . Exercise Data Year Days 2005 5 2006 14 2007 15 2008 4arrow_forwardPrepare a Frequency Distribution –frequency and cumulative frequency. Prepare a Histogram using the Pivot Tool or the Histogram Tool under the Data Analysis tab.. Using the output identify the information that you would present to your team. For example, the shape of the chart, concentration of payments times etc. If you were to give a 10% discount for payments less than or equal to 14 days what percent would receive the discount?arrow_forward
- Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3 periods to the chart. Be sure to include the R-squared value on the chart. Using =TREND(), complete the forecast table for months 19-21 1 $ 2,145,600 19 2 $ 2,175,200 20 3 $ 2,255,200 21 4 $ 2,505,600 5 $ 2,748,800 6 $ 2,358,000 7 $ 3,165,200 8 $ 3,253,600 9 $ 3,484,000 10 $ 3,731,200 11 $ 3,741,200 12 $ 3,558,800 13 $ 3,771,200 14 $ 3,787,600 15 $ 3,813,600 16 $ 3,822,800 17 $ 3,828,000 18 $ 3,897,200arrow_forwardIn 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?arrow_forwardGiven below are the numbers of indoor movie theaters, listed in order by row for each year. Use the given data to construct a time-series graph. What is the trend? How does this trend compare to the trend for drive-in movie theaters? Click the icon to view the indoor movie theater data. Construct a time-series graph with the year on the horizontal axis and the number of theaters on the vertical axis. O A. O B. 36000- 32000- Z 280001 24000 20000- 0 4 8 1216 Q 36000 32000- 28000 24000 20000 0 4 8 1216 O What is the trend? How does this trend compare to the trend for drive-in movie theaters? O A. There appears to be an downward trend, similar to drive-in movie theaters, which also have a downward trend. O B. There appears to be an upward trend, unlike drive-in movie theaters, which have a downward trend. O C. There appears to be an upward then downward trend, unlike drive-in movie theaters, which only have a downward trend. C O C. 36000 32000- 28000- 24000 20000- 0 4 8 1216 Q Indoor Movie…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt