# Question: Examine the relationship between the average utility bills for homes

Examine the relationship between the average utility bills for homes of a particular size (Y) and the average monthly temperature (X). The data in the file P10_07.xlsx include the average monthly bill and temperature for each month of the past year.

a. Use the given data to estimate a simple linear regression equation. Interpret the least squares line.

b. How well does the estimated regression equation fit the given data? How might you do a better job of explaining the variation of the average utility bills for homes of a certain size?

a. Use the given data to estimate a simple linear regression equation. Interpret the least squares line.

b. How well does the estimated regression equation fit the given data? How might you do a better job of explaining the variation of the average utility bills for homes of a certain size?

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

The file P10_08.xlsx contains data on the top 200 professional golfers in 2009. a. Create a new variable, Earnings per Round, and the ratio of Earnings to Rounds. Then create five scatter plots and corresponding ...Estimate the relationship between monthly electrical power usage (Y) and home size (X) using the data in the file P10_13.xlsx. Interpret your results. How well does a simple linear regression equation explain the variation ...The manager of a commuter rail transportation system was recently asked by her governing board to determine which factors have a significant impact on the demand for rides in the large city served by the transportation ...Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semi fragile, and ...Continuing Problem 19, revise the previous multiple regression equation to include an interaction term between the return on average equity (X1) and annual dividend rate (X2).a. Estimate your revised equation using the data ...Post your question