Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
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 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…
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
Statistics for Business & Economics, Revised (MindTap Course List)
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
- 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_forwardvt 14. Calculate trend values by the method of Least Square from the data given below and estimate the sales for 2007. Year 2000 2001 2002 2003 2004 Sales of GA. (Rs. lakhs) 70 74 80 86 90 上arrow_forward
- Don't hand writing solution.arrow_forwardIn Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forward1. 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_forward
- Import 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_forwardMo. Please give only typed answer.arrow_forward
- Calculate 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_forwardPlease solve. Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 7 В 2 1 2 5 3 4 6 7 4 6 8 9 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a horizontal pattern and no seasonal pattern in the data. The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. O The time series plot shows a linear trend and no seasonal pattern in the data. (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) - 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal places.) quarter 1 forecast quarter 2…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
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