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 solutionStudents have asked these similar questions
Find the MSE in part (b) please.
The following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…
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
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
- Please answer asap I really need helparrow_forwardWhat do the Forecast for each year add up to?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
- The creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. Click on the datafile logo to reference the data. The datafile logo. Month Downloads Month Downloads (previous year) (thousands) (current year) (thousands) February 33.0 January 31.0 March 34.0 February 32.0 April 34.0 March 33.0 May 31.0 April 34.0 June 32.0 May 33.0 July 33.0 June 32.0 August 35.0 July 35.0 September 36.0 August 33.0 October 37.0 September 33.0 November 34.0 October 31.0 December 35.0 a. Compute the mean, median, and mode for number of downloads in the previous year. Mean (to 3 decimals) thousand Median (to 2 decimal) thousand Mode (to 2 decimal) thousand b. Compute the mean, median, and mode for number of downloads in the current year. Mean (to 3 decimals) thousand Median (to 2…arrow_forwardPlease help with the corrected answers in details: The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 What type of pattern exists in the data? The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern.The data appear to follow a seasonal pattern. (b) Use ? = 0.2 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (c) Use a smoothing constant of ? = 0.4 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135…arrow_forwardPlease solve all the questions belowarrow_forward
- using 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_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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningBig 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