Concept explainers
The owners of a chain of ice cream stores have the business objective of improving the forecast of daily sales so that staffing shortages can be minimized during the summer season. As a starting point, the owners decide to develop a simple linear regression model to predict daily sales based on atmospheric temperature. They select a sample of 21 consecutive days and store the results in IceCream.
a. Assuming a linear relationship, use the least-squares method to compute the regression coefficients
b. Predict the sales for a day in which the temperature is
c. Plot the residuals versus the time period.
d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals?
e. Based on the results of (c) and (d), is there reason to question the validity of the model?
f. What conclusions can you reach concerning the relationship between sales and atmospheric temperature?
Want to see the full answer?
Check out a sample textbook solutionChapter 13 Solutions
EP BASIC BUS.STATS-ACCESS (18 WEEKS)
- Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardCellular Phone Subscribers The table shows the numbers of cellular phone subscribers y in millions in the United States from 2008 through 2013. Source: CTIA- The Wireless Association Year200820092010201120122013Number,y270286296316326336 (a) Find the least squares regression line for the data. Let x represent the year, with x=8 corresponding to 2008. (b) Use the linear regression capabilities of a graphing utility to find a linear model for the data. How does this model compare with the model obtained in part a? (c) Use the linear model to create a table of estimated values for y. Compare the estimated values with the actual data.arrow_forwardLaetisaric acid is a compound that holds promise for control of fungus diseases in crop plants. Below is the least-squares regression equation to predict fungus growth (mm) from laetisaric acid concentration (µG/ml): ŷ =31.8 -0.712x Which of the following statements is correct? A. Above-average values of laetisaric acid concentration tend to accompany above-average values of fungus growth. B. From the given regression equation, we know the correlation is negative and we can say what the exact value of that correlation is. C. When fungus growth increases by 1 mm, the laetisaric acid concentration decreases by 0.712 µG/ml. D. None of the above.arrow_forward
- David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Click on the datafile logo to reference the data. (NEED ANSWERS FOR C, D, and E) c. Use the least squares method to develop the estimated regression equation (to 5 decimals). d. For every additional $1000 in home value, estimate how much additional will be spent on landscaping (to 2 decimals). e. Use the equation estimated in part (c) to predict the landscaping expenditures for a home valued at $575,000 (to the nearest whole number).arrow_forwardWe have data on Lung Capacity of persons and we wish to build a multiple linear regression model that predicts Lung Capacity based on the predictors Age and Smoking Status. Age is a numeric variable whereas Smoke is a categorical variable (0 if non-smoker, 1 if smoker). Here is the partial result from STATISTICA. b* Std.Err. of b* Std.Err. N=725 of b Intercept Age Smoke 0.835543 -0.075120 1.085725 0.555396 0.182989 0.014378 0.021631 0.021631 -0.648588 0.186761 Which of the following statements is absolutely false? A. The expected lung capacity of a smoker is expected to be 0.648588 lower than that of a non-smoker. B. The predictor variables Age and Smoker both contribute significantly to the model. C. For every one year that a person gets older, the lung capacity is expected to increase by 0.555396 units, holding smoker status constant. D. For every one unit increase in smoker status, lung capacity is expected to decrease by 0.648588 units, holding age constant.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_forward
- Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Month Maintenance Cost Machine Hours Jan. $ 4,200 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $ 43,200 4,800 Average $ 3,600 $ 400 Average cost per hour $ 9.00 a (intercept) $ 684.65 b (coefficient) 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105…arrow_forwardArmer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Month Maintenance Cost Machine Hours Jan. $ 4,200 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $ 43,200 4,800 Average $ 3,600 $ 400 Average cost per hour $ 9.00 a (intercept) $ 684.65 b (coefficient) 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105…arrow_forwardSuppose a new point was added to your data: a wine that is 20% alcohol that contains 0calories. How will that affect the value of r and the slope of the regression line? (Nocalculation needed)arrow_forward
- The production of wine is a multi-billion-dollar worldwide industry. In an attempt to develop a model of wine quality as judged by wine experts, data was collected from red wine variants from a particular type of foreign wine. A multiple linear regression model was developed from a sample of 55 wines. The model was used to predict wine quality, measured on a scale from 0 (very bad) to 10 (excellent) based on the alcohol content (%) and the amount of chlorides. a. Construct a 95% confidence interval estimate of the population slope between wine quality and the percentage of alcohol. (Round to four decimal places as needed.)arrow_forwardThe production of wine is a multi-billion-dollar worldwide industry. In an attempt to develop a model of wine quality as judged by wine experts, data was collected from red wine variants from a particular type of foreign wine. A multiple linear regression model was developed from a sample of 55 wines. The model was used to predict wine quality, measured on a scale from 0 (very bad) to 10 (excellent) based on the alcohol content (%) and the amount of chlorides. Find the test statistic for X1. (Type an integer or decimal rounded to two decimal places as needed.)arrow_forwardMark Price, the new productions manager for Speakers and Company, needs to find out which variable most affects the demand for their line of stereo speakers. He is uncertain whether the unit price of the product or the effects of increased marketing are the main drivers in sales and wants to use regression analysis to figure out which factor drives more demand for its particular market. Pertinent information was collected by an extensive marketing project that lasted over the past 12 years and was reduced to the data that follow: YEAR 123456789 10 11 12 UNIT SALES (THOUSANDS) 396 696 896 1,285 1,155 1,186 896 1,118 985 1,334 926 820 PRICE $/UNIT 282 219 206 210 219 209 218 206 220 206 226 236 ADVERTISING ($000) 600 829 1,118 1,413 1,214 1,285 907 1,118 708 907 708 682 a. Perform a regression analysis based on these data using Excel. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)arrow_forward
- College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningElementary Linear Algebra (MindTap Course List)AlgebraISBN:9781305658004Author:Ron LarsonPublisher:Cengage Learning
- Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage LearningAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill