STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 42SE
The following table reports the percentage of stocks in a portfolio for nine quarters from 2010 to 2012.
| Quarter | Stock % |
| 1st—2010 | 29.8 |
| 2nd—2010 | 31.0 |
| 3rd—2010 | 29.9 |
| 4th—2010 | 30.1 |
| 1st—2011 | 32.2 |
| 2nd—2011 | 31.5 |
| 3rd—2011 | 32.0 |
| 4th—2011 | 31.9 |
| 1st—2012 | 30.0 |
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use exponential smoothing to forecast this time series. Consider smoothing constants of α = .2, .3, and .4. What value of the smoothing constant provides the most accurate forecasts?
- c. What is the forecast of the percentage of stocks in a typical portfolio for the second quarter of 2009?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
The folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns.
Year Admissions Year Admissions
1945 79.0 1985 20.30
1955 39.9 1995 23.3
1965 19.8 2005 26.5
1975 19.9 2015 25.4
#4) Commuter ridership in Athens, Greece, during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the data are given in the following table.
Year
Number of Tourists (millions)
Ridership (hundreds of thousands)
1
6
11
2
11
16
3
8
16
4
10
14
5
19
28
6
18
26
7
16
21
8
20
25
9
24
45
10
18
28
11
11
18
12
19
35
a) Create a time series plot for the ridership.
b) Using linear regression to see if using the year is a good predictor for the ridership. What is the regression equation? How accurate is the model?
c) Using linear regression to see if using the number of tourists is a good predictor for the ridership. What is the regression equation? How accurate is the model?
d) Which linear regression equation is better? What is the expected ridership if 10 million tourists visit the city next year?
e) Excel File
Chapter 17 Solutions
STATISTICS F/BUSINESS+ECONOMICS-TEXT
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 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...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 - The data contained in the DATAfile named CrudeCost...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 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 table below contains the average price paid for a new home in a certain area from 2000 to 2010. a. Construct a time-series plot of new home prices. b. What pattern, if any, is present in the data? Year Average_Price_($_thousands)2000 351.12001 330.52002 310.52003 296.72004 229.72005 182.32006 154.52007 156.32008 154.72009 154.52010 154.5arrow_forwardAfter its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardConsider 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_forward
- consider the following time series data.t 1 2 3 4 5 6 7yt10 9 7 8 6 4 4a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for this time series.c. What is the forecast for t = 8?arrow_forwardUsing the time series data in the table, respond to the following items. Period Sales 1 $ 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 3 decimal places.) Period Sales Predicted Sales Absolute Error 1 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-2. What is the MAD? (Round your answer to 3 decimal places.) d-3. What is the trend equation based on the regression analysis? (Round your answers to 3 decimal places.) Sales = __________ + _______________ time…arrow_forwardUsing excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?arrow_forward
- For the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?arrow_forwardConsider the following time seriesweek 1 2 3 4 5 6 value 18 13 16 11 17 14 a) Construct a time series plot? What type of pattern exists in the datab) Develop the three week moving average forecasts for this time series, then compute the measures of forecasts accurecyarrow_forwardConsider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 80 82 84 83 83 84 85 84 82 83 84 83 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a three month moving average forecast. Compute MSE and a forecast for month 13. c) Develop an exponential smoothing forecast with a = 0.35. Compute MSE and a forecast for month 13.arrow_forward
- ten weeks of data on the commodity Futures index are 7.35, 7.40, 7.55, 7.56, 7.60, 7.52,7.52, 7.70, 7.62, and 7.55.a. construct a time series plot. What type of pattern exists in the data?arrow_forwardWhich of the following time series forecasting methods would not be used to forecast seasonal data?arrow_forwardConsider the following time series data: 1 2 3 4 5 6 7 26 15 22 14 21 25 17 PART 1.Compute MSE using the most recent value as the forecast for the next period and then calculate the forecast for month 8. PART 2.Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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