# Question: Consider the situation in which a gas company wishes to

Consider the situation in which a gas company wishes to predict weekly natural gas consumption for its city. In the exercises of Chapter we used the single predictor variable x, average hourly temperature, to predict y, weekly natural gas consumption. We now consider predicting y on the basis of average hourly temperature and a second predictor variable—the chill index. The chill index for a given average hourly temperature expresses the combined effects of all other major weather-related factors that influence natural gas consumption, such as wind velocity, sunlight, cloud cover, and the passage of weather fronts. The chill index is expressed as a whole number between 0 and 30. A weekly chill index near 0 indicates that, given the average hourly temperature during the week, all other major weather- related factors will only slightly increase weekly natural gas consumption. A weekly chill index near 30 indicates that, given the average hourly temperature during the week, other weather-related factors will greatly increase weekly natural gas consumption. The natural gas company has collected data concerning weekly natural gas consumption (y, in MMcF), average hourly temperature (x1, in degrees Fahrenheit), and the chill index (x2) for the last eight weeks. The data are given in Table, and scatter plots of y versus x1 and y versus x2 are given below the data. Moreover, Figure on the next page gives Excel and MINITAB outputs of a regression analysis of these data using the model

y = β0 + β1x1 + β2x2 + ε

a. Using the Excel or MINITAB output (depending on the package used in your class), find (on the output) b1 and b2, the least squares point estimates of b1 and b2, and report their values. Then interpret b1 and b2.

b. Calculate a point estimate of the mean natural gas consumption for all weeks that have an average hourly temperature of 40 and a chill index of 10, and a point prediction of the amount of natural gas consumed in a single week that has an average hourly temperature of 40 and a chill index of 10. Find this point estimate (prediction), which is given at the bottom of the MINITAB output, and verify that it equals (within rounding) your calculated value.

y = β0 + β1x1 + β2x2 + ε

a. Using the Excel or MINITAB output (depending on the package used in your class), find (on the output) b1 and b2, the least squares point estimates of b1 and b2, and report their values. Then interpret b1 and b2.

b. Calculate a point estimate of the mean natural gas consumption for all weeks that have an average hourly temperature of 40 and a chill index of 10, and a point prediction of the amount of natural gas consumed in a single week that has an average hourly temperature of 40 and a chill index of 10. Find this point estimate (prediction), which is given at the bottom of the MINITAB output, and verify that it equals (within rounding) your calculated value.

**View Solution:**## Answer to relevant Questions

The number of Bismark X- 12 electronic calculators sold at Smith’s Department Stores over the past 24 months have been: 197, 211, 203, 247, 239, 269, 308, 262, 258, 256, 261, 288, 296, 276, 305, 308, 356, 393, 363, 386, ...Table gives the selling price (Price, expressed in thousands of dollars), the square footage (SqrFt), the number of bathrooms (Bathrms), and the niceness rating (Niceness, expressed as an integer from 1 to 7) of 80 homes ...Recall that Table presents data concerning the need for labor in 16 U.S. Navy hospitals. This table gives values of the dependent variable Hours (monthly labor hours) and of the independent variables Xray (monthly X-ray ...Mendenhall and Sincich (1993) present data that can be used to investigate allegations of gender discrimination in the hiring practices of a particular firm. These data are given in the page margin. In this table, y is a ...Table 14.6 presents data concerning the need for labor in 16 U.S. Navy hospitals. Here, y = monthly labor hours required; x1 = monthly X-ray exposures; x2 = monthly occupied bed days (a hospital has one occupied bed day if ...Post your question