The data stored in McDonalds represent the gross revenues (in billions of current dollars) McDonald’s Corporation from 1975 through 2016:
a. Plot the data.
b. Compute the linear trend forecasting equation.
c. Compute the quadratic trend forecasting equation.
d. Compute the exponential trend forecasting equation.
e. Determine the best-fitting autoregressive model, using
f. Perform a residual analysis for each of the models in (b) through (e).
g. Compute the standard error of the estimate
h. On the basis of your results in (f) and (g), along with a consideration of the principle of parsimony, which model would you select for purpose of forecasting? Discuss.
i. Using the selected model in (h), forecast gross revenues for 2017.
Want to see the full answer?
Check out a sample textbook solutionChapter 16 Solutions
EBK BASIC BUSINESS STATISTICS
- Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?arrow_forwardConsider the following estimated trend models. Use them to make a forecast for t= 22. a. Linear Trend: ý = 12.42 + 1.13t (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) b. Quadratic Trend: û = 18.04 + 1.04t - 0.02t2 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) c. Exponential Trend: In(y) = 1.6 + 0.08t, se = 0.01 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.)arrow_forward9. NORTH-SOUTH AIRLINE CASE Northern Airline Data Engine Cost per Aircraft 43.49 Airframe Cost Average Age (Hours) 6,512 8,404 11,077 11,717 13,275 15,215 18,390 per Aircraft 51.80 Year 2001 2002 54.92 38.58 2003 69.70 51.48 2004 68.90 58.72 2005 63.72 45.47 2006 84.73 50.26 2007 78.74 79.60 Southeast Airline Data Engine Cost per Aircraft 18.86 Airframe Cost Average Age (Hours) 5,107 8,145 7,360 5,773 7,150 9,364 8,259 Year Per Aircraft 2001 13.29 2002 25.15 31.55 2003 32.18 40.43 2004 31.78 22.10 2005 25.34 19.69 2006 32.78 32.58 2007 35.56 38.07arrow_forward
- Part c: What percentage of an adult size brain does a child have at age 10? Part d: Determine whether the value from the model is larger or smaller than the value in the table.arrow_forwardThe percentage of mothers who smoke cigarettes during pregnancy has declined approximately linearly from13.1% in 1997 to 12.3% in 2004 Predict the percentage in 2015.arrow_forwardOzone (O3) is a major component of air pollution in many cities. Atmospheric ozone levels are influenced by many factors, including weather. In one study, the mean percent relative humidity (x) and the mean ozone levels (y) were measured for 120 days in a western city. Mean ozone levels were measured in ppb. The following output (from MINITAB) describes the fit of a linear model to these data. Assume that assumptions 1 through 4 on page 549 hold. The regression equation is Ozone = 88.8 - 0.752 Humidity Predictor Coef SE Coef тР Constant 88.761 7.288 12.18 0.000 Humidity -0.7524 0.13024 -5.78 0.000 S= 11.43R-Sq = 22.0°%R-Sq(adj) = 21.4% %3D Predicted Values for New Observations New Obs FitSE Fit 95.0% CI 95.0% PI 43.62 1.20(41.23 46.00) (20.86, 66.37) Values of Predictors for New Observations New Obs Humidity 60.0 What are the slope and intercept of the least-squares line? Is the linear model useful for predicting ozone levels from relative humidity? Explain. c. Predict the ozone level…arrow_forward
- Based on the scatterplot and residual plot, what type of model would be appropriate for summarizing the relationship between days and number of views? A popular television show recently released a video preview for the upcoming season on its website. As fans of the show discover the video, the number of views of the preview video has grown each day during the last 2 weeks. The number of days since the release of the video and the natural log of the number of video views is shown in the scatterplot. O An exponential model is appropriate because the residual plot does not show a clear pattern. O A linear model is appropriate because the scatterplot shows a strong, positive linear relationship. In(Views) vs. Days O A power model is appropriate because the scatterplot of days and natural log of views is strong and linear. 10 9.5 An exponential model is appropriate because the relationship between days and the natural log of views is linear, and the residual plot does not show a clear…arrow_forwardThe U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below. The current minimum wage is $5.15. If an employee earns the minimum wage, how many complaints can that employee expect to receive? Is the regression coefficient statistically significant? How can you tell?arrow_forwardThe following data of regular growth (linear regression) sales for XYZ company during last eleven years (2005 to 2015): Student Name Student ID cW16 Years Sales 2005 5500 2006 6500 2007 7800 2008 9000 2009 11500 2010 10600 2011 10000 2012 8600 2013 10200 2014 10500 2015 10900 2016 2017 2018 2019 2020 eee Required: 1. Create a new worksheet "Q3", and enter the previous data in it. 2. Use the (FORECAST) functions to predict the expected sales for the following five years (2016 to 2020) "predict expected sales based on actual sales). Actual Sales Expected Salesarrow_forward
- Although natural gas is currently inexpensive and nuclear power currently (and perhaps deservedly) does not have a good reputation, it is possible that more nuclear power plants will be constructed in the future. Table 4 presents data concerning the construction costs of light water reactor (LWR) nuclear power plants. The dependent variable, C, construction cost, is expressed in millions of dollars, adjusted to a 1976 base. Preliminary analysis of the data and economic theory indicate that variation in cost increases as cost increases. This suggests transforming cost by taking its natural logarithm. S Power plant capacity in MWe N Cumulative number of power plants built by the contractor Build a multiple regression model to predict ln(C) by taking S and N or their natural logarithms as the independent variables. Make sure to check for multicollinearity. Use residual analysis and R2 to check your model. State which variables are important in predicting the cost of constructing an…arrow_forwardTable #2.3.7 contains the value of the house and the amount of rental income in a year that the house brings in ("Capital and rental," 2013). Create a scatter plot and state if there is a relationship between the value of the house and the annual rental income. Table #2.3.7: Data of House Value versus Rental Value Rental Value Rental Value Rental Value Rental 81000 6656 77000 4576 75000 7280 67500 6864 95000 7904 94000 8736 90000 6240 85000 7072 121000 12064 115000 7904 110000 7072 104000 7904 135000 8320 130000 9776 126000 6240 125000 7904 145000 8320 140000 9568 140000 9152 135000 7488 165000 13312 165000 8528 155000 7488 148000 8320 178000 11856 174000 10400 170000 9568 170000 12688 200000 12272 200000 10608 194000 11232 190000 8320 214000 8528 208000 10400 200000 10400 200000 8320 240000 10192…arrow_forwardThe annual production of a commodity is given by as follows: Year 2005 2006 2007 2008 2009 2010 2011 Production 70 80 90 95 102 110 115 (in tonnes) (i) (ii) Fit a straight line Trend by the method of least squares. Convert the annual trend equation into a monthly Trend equationarrow_forward
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill