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
Question
Chapter 17.4, Problem 21E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Calculate the linear trend equation for the data.
c.
To determine
Calculate the forecast value for 2012.
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?
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?
Using the data in Table 6–11, calculate a 3-month moving average forecast for month 12.
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
- The Bank of Canada is interested in studying the relationship between mortgage rates and medianhome prices. The data is provided belowYear interest rate (%) Median home price1988 10.30 $183,8001989 10.30 $183,2001990 10.10 $174,9001991 9.30 $173,5001992 8.40 $172,9001993 7.30 $173,2001994 8.40 $173,2001995 7.90 $169,7001996 7.60 $174,5001997 7.60 $177,9001998 6.90 $188,1001999 7.40 $203,2002000 8.10 $230,2002001 7.00 $258,2002002 6.50 $309,8002003 5.80 $329,8002004 5.80 $431,0002005 5.80 $515,0002006 6.40 $537,0002007 6.30 $496,0002008 6.00 $352,0002009 5.00 $232,0002010 4.70 $291,7002011 4.40 $262,9002012 3.60 $299,2002013 4.00 $321,2002014 4.10 $373,5002015 3.80 $358,1002016 3.60 $382,5002017 4.00 $402,900a) Estimate a simple linear regression model and find the value of the parameters for theestimation of mortgage rates and the median home price. All JASP input files and outputtables should be provided. Interpret the intercept and the slope coefficientsb) State the correlation…arrow_forwardYear Gross Federal Debt ($millions) 1945 260,123 1950 256,853 1955 274,366 1960 290,525 1965 322,318 1970 380,921 1975 541,925 1980 909,050 1985 1,817,521 1990 3,206,564 1995 4,921,005 2000 5,686,338 Construct a scatter plot with this data. Do you observe a trend? If so, what type of trend do you observe? Use Excel to fit a linear trend and an exponential trend to the data. Display the models and their respective r^2. Interpret both models. Which model seems to be more appropriate? Why?arrow_forwardUsing the accompanying table, determine the most appropriate forecasting technique for the accompanying data about the Dow Jones Industrial Average yearly closing value and implement the model. Year Close 1983 1258.64 1984 1211.57 1985 1546.67 1986 1895.95 1987 1938.83 1988 2168.57 1989 2753.2 1990 2633.66 1991 3168.83 1992 3301.11 1993 3754.09 1994 3834.44 1995 5117.12 1996 6448.27 1997 7908.25 1998 9181.43 1999 11497.12 2000 10786.85 2001 10021.5 2002 8341.63 2003 10453.92 2004 10783.01 2005 10717.5 2006 12463.15 2007 13264.82 2008 8776.39 2009 10428.05 2010 11557.5 2011 12217.6 2012 13104.1 Use the model forecast the closing value for 2015.Use α=0.7,β=0.3,and γ=0.4,as needed. F2015?arrow_forward
- If year one equals P800,000, year two equals P840,000, and year three equals P896,000, the percentage to be assigned for year three in a trend analysis, assuming that year 1 is the base year, is a. 105%. b. 89%. c. 100%. d. 112%.arrow_forwardA dataset that consists of information from the American Community Survey from years 2006, 2007, and 2008, is an example of which type of data? A) •Time series B) Pooled cross-sectional C) Panel D) Cross-sectionalarrow_forwardConsider the table. Sales on Toaster Ovens 2004 2005 2006 2007 2008 Super Deluxe $86,100 $140,500 $65,800 $56,100 $59,000 Deluxe 103,200 136,100 129,900 133,800 75,400 Standard 147,300 123,600 125,500 132,600 58,000 What percent of the total sales in 2004 were the deluxe model? (Round to the nearest tenth percent.)arrow_forward
- Given the following data, calculate the three-month moving average forecasts formonths 4, 5, 6, and 7arrow_forwardDon Williams received a memo requesting that he complete a trend analysis of the following numbers using 2021 as the base year. 2024 2023 2022 2021 Sales $ 340,000 $ 400,000 $ 420,000 $ 500,000 Gross profit 180,000 240,000 340,000 400,000 Net income 70,000 90,000 40,000 50,000 Could you help Don with the request? Note: Round your answers to the nearest whole percent.arrow_forwardA dataset that consists of information from the American Community Survey from years 2006, 2007, and 2008, is an example of which type of data? •Time series Pooled cross-sectional Panel Cross-sectionalarrow_forward
- Is the following nominal, ordinal, or interval data? Explain your answer. Stock pricesarrow_forward4. The CDC released the following table of life expectancies for Americans from 1900-2010.arrow_forwardA, Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the multiplicative indices for the seasons. Using the model forecast sales for the next year (all 4 seasons of year 4). Year Season Sales 1 Sp 140 1 Su 50 1 w 130 1 F 520 2 Sp 200 2 Su 110 2 w 190 2 f 550 3 Sp 260 3 Su 220 3 W 210 3 f 550 B, Discuss the Price Index most used in your country. How is it calculated?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
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