Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.6, Problem 38E
Three years of monthly lawn-maintenance expenses ($) for a six-unit apartment house in southern Florida follow.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Identify the monthly seasonal indexes for the three years of lawn-maintenance expenses for the apartment house in southern Florida as given here. Use a 12-month moving average calculation.
- c. Deseasonalize the time series.
- d. Compute the linear trend equation for the deseasonalized data.
- e. Compute the deseasonalized trend forecasts and then adjust the trend forecasts using the seasonal indexes to provide a forecast for monthly expenses in Year 4.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook 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 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.
Find the seasonal variations by the method of 'ratio to trend' for the followin
data of sales of a company :
II
III
IV
I
Year/Qtrs.
2011
80
72
68
60
68
104
100
88
2012
80
116
108
96
2013
108
152
136
124
2014
160
184
172
164
2015
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. 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 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...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 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
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 - 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 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- 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_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardNo 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%arrow_forward
- 1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988 1989 Production: 15 14 18 20 17 24 27 Fit the linear trend. Compute the trend values for each year. Estimate the production for yeаr 1991.arrow_forwardImport Illinois.xls as a table. Using logical indexing to select the years with more than 2800 cases of Diabetes. Then plot all of the data on the same axis. F1 fx Homicide B C E Year Accidents Cancer Diabetes Heart Disease Homicide| Suicide 1999 4125 25024 3004 33387 1023 1020 3 2000 4041 25365 2995 31844 991 1003 4. 2001 4077 24778 3092 30990 1087 1139 2002 4222 24737 3011 30821 1016 1145 2003 3942 24464 3044 29816 966 1011 7. 2004 4133 24289 3069 28284 871 1028 8. 2005 4182 24250 3034 28226 866 1086 9. 2006 4451 24084 2795 27007 865 1010 10 2007 4367 24115 2851 25813 863 1108 11 2008 4218 24300 2846 26078 872 1198 12 2009 3961 24185 2741 24931 881 1177 13 2010 3997 24070 2507 24959 783 1178 14 2011 4166 24007 2693 24987 812 1226 15 2012 4488 24562 2706 24667 832 1292 16 2013 4511 24491 2798 17 24839 792 1321 2014 4644 24501 2712 18 25024 792 1398 2015 4850 24713 2817 25652 19 863 1363 20 21arrow_forwardSolve with the help of grapharrow_forward
- Mo. Please give only typed answer.arrow_forwardI need help with parts a, b, c, d,and e. Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A. Choose the correct time series plot. What type of pattern exists in the data? Horizontal or trend B. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE ??? Forecast for week 7 ??? C. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE ??? Forecast for week 7 ??? D. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Three-week moving average OR exponantial smoothing? E. Use trial and error to find a value of the…arrow_forwardCalculate the indices of seasonal variation by ratio to trend method from the following data. Quarters II III Year IV 110 1970 112 125 132 129 147 1971 119 115 1972 | 120 1973 128 142 151 150 162 118 125arrow_forward
- The 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_forwardPlease answer asap I really need helparrow_forward1) Raj collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel in lowa. Year quarter Occupancy 2014 1 2 3 4 2015 1 2 3 st 4 2016 1 2 3 4 2017 1 2 3 4 2018 1 2 3 4 16 21 9 18 15 20 10 18 17 24 13 22 17 25 11 21 18 26 14 25 1. Plot the data and describe any trend and seasonal effects you observe in the data. 1. Compute and interpret the seasonal indices. 1. Forecast the occupancy for four quarters of 2019.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
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:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
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