EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 17.4, Problem 20E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Calculate the
c.
To determine
Calculate the forecast value for 8.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.
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?
No Religious Affiliation Trends. The following table gives the percentage of first-year college students who answered “None” when asked about their religious affiliation in selected years. Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns.
Year
Percentage claiming no religious affiliation
1985
9.4%
1990
12.3%
1995
14.0%
2000
14.9%
2005
17.4%
2010
23.0%
2015
29.5%
Chapter 17 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - With a smoothing constant of = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
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
- The 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_forwardThe U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_forwardThe 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…arrow_forward
- In 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_forwardThe data table below shows the series of Output per hour of labor for a certain country. a) Make a time series plot. b) Describe the Trend component. (Remember: Direction, Form, and Strength) c) Is there evidence of a Seasonal component? Year Output Year 1999 2000 2001 2002 2003 2004 Output 74.6 56.0 64.7 73.2 84.4 103.6 a) Choose the correct plot below. OA. 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 49.0 84.4 66.9 50.6 80.5 58.3 84.6 76.0 75.5 65.6 130- Output WH H bo H ▬▬▬▬ 40++ 1985 Year Year 2010 Q b) Describe the direction of the trend. The direction is Describe the form of the trend. The shape of the data is Describe the strength of the relationship. The relationship appears to be c) Is there evidence of a Seasonal component? 2005 2006 2007 2008 75.5 85.8 121.2 116.9 O B. 130- Output t PORO boot Ho J 40+ 1985 O A. Yes, because the mean of the data is definitely changing with time. O B. No, because the mean value is approximately constant with time. O C. Yes, because there…arrow_forwardThe accompanying data represent health care expenditures per capita (per person) as a percentage of the U.S. gross domestic product (GDP) from 2007 to 2013. Gross domestic product is the total value of all goods and services created during the course of the year Complete parts (a) through (c) below. Click the icon to view the data table. (a) Construct a time-series plot that a politician would create to support the position that health care expenditures are increasing and must be slowed. Choose the correct graph below OD. O C. OB OA A Q A Q Q 25,000+ 11,000 Q Q 3 2 G HIER 11200 2H 7,000++ C 2013 of + 2013 2007 2007 Year Year Year (b) Construct a time-series plot that the health care industry would create to refute the opinion of the politician. Choose the correct graph below. OB. O C. O A. A Q A Q 11,000 Q (C) 7,000+ 201 20 7.000+++++++* 2007 2007 2013 2013 Year Year (c) Explain how different measures may be used to support two completely different positions. Choose the correct answer…arrow_forward
- Consider the following time series data.Quarter Year 1 Year 2 Year 31 4 6 72 2 3 63 3 5 64 5 7 8a. Construct a time series plot. What type of pattern exists in the data?b. Show the four-quarter and centered moving average values for this time series.c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.arrow_forwardFind the MSE in part (b) please.arrow_forwardhudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.arrow_forward
- Please answer asap I really need helparrow_forwardConsider the following time series. Quarter Year 1 Year 2 Year 3 1 70 67 61 2 50 42 52 3 59 61 54 4 79 82 73 (a) Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data.The time series plot shows a horizontal pattern with no seasonal pattern present. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.The time series plot shows a trend pattern with no seasonal pattern present. (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. ŷ = (c) Compute the quarterly forecasts for the next year. quarter 1 forecast quarter 2 forecast quarter 3 forecast quarter 4 forecastarrow_forwardConsider the time series data in the table below (a-c all count as one problem) a. Construct a time series plot. What type of pattern exists in the data?b. Develop a three-week moving average for this time series. Compute MSEand a forecast for week 8. c. Use α = 0.2 to compute the exponential smoothing value for the time series.Compute MSE and a forecast for week 8.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
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
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
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
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
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