Question

A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by...

A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by miles per gallon, based on the weight of the car in pounds. The Excel data file AUTO.xls (contained in a folder under the CML Quizzes tab) contains data on this for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, a 95% confidence interval for the slope coefficient and the residual plot. State all numeric answers below correct to four decimal places using the Excel output results.
1. the intercept  
2. the slope coefficient , and
3. the coefficient of determination  
4. Using this model, predict the gasoline usage for a car weighing 3000 pounds. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel.
5. Does the prediction involve extrapolating the relationship? Type yes or no.
State the
6. lower bound  
7. upper bound  for the 95% confidence interval for the slope coefficient

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A consumer Organization want to develop a regression model to predict gasoline mileage (as measured by...
A consumer Organization want to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on horsepower of the car's engine and the weight of the car, in pounds. A sample of 50 percent recent car models was selected, with the results recorded. 1. State the multiple regression equation. 2. Interpret the meaning of the slopes, b and b2 in this problem. 3. Explain why the regression coefficient b0, has no practical meaning in the...
In an attempt to develop a model of wine quality as judged by wine​ experts, data...
In an attempt to develop a model of wine quality as judged by wine​ experts, data on alcohol content and wine quality was collected from variants of a particular wine. From a sample of 21​wines, a model was created using the percentages of alcohol to predict wine quality. From the results of that​ regression, b1 = 0.3607 and Sb1 = 0.1879 a. At the 0.05 level of​ significance, is there evidence of a linear relationship between the percentage of alcohol...
Data Set Preparation (Using A JMP Folder) Can email you if comment your email. 1. (10...
Data Set Preparation (Using A JMP Folder) Can email you if comment your email. 1. (10 pts.) Using the “Toyota Corolla” data set on Canvas (Home à “JMP” à “(Under: JMP Data Sets folder)”, you will be modeling the “Price” of a car as the dependent variable (Y). Please select one independent variable (X) you think may help explain Price, from the following three: “Age”, “Mileage”, or “Weight” of a car. In the space below, state your choice and explain...
A researcher wants to know if there is a relationship between the number of shopping centers...
A researcher wants to know if there is a relationship between the number of shopping centers in a state and the retail sales (in billions $) of that state. A random sample of 8 states is listed below. After determining, via a scatter-plot, that the data followed a linear pattern, the regression line was found. Using the given data and the given regression output answer the following questions. State Num Sales 1 630 15.5 2 370 7.5 3 616 13.9...
1.    In a multiple regression model, the following coefficients were obtained: b0 = -10      b1 =...
1.    In a multiple regression model, the following coefficients were obtained: b0 = -10      b1 = 4.5     b2 = -6.0 a.    Write the equation of the estimated multiple regression model. (3 pts) b     Suppose a sample of 25 observations produces this result, SSE = 480. What is the estimated standard error of the estimate? (5 pts) 2.    Consider the following estimated sample regression equation: Y = 12 + 6X1 -- 3 X2 Determine which of the following statements are true,...
Mabel, a real estate agent, is looking for a method of predicting the selling prices of...
Mabel, a real estate agent, is looking for a method of predicting the selling prices of houses in Burnaby. Since the City of Burnaby appraises houses for the purpose of assessing taxes, she investigates a small sample of recently sold houses to see if there is a linear relationship between the appraised value and the selling price. Her data is in this table: Appraised Value ($1,000’s) Selling Price ($1,000’s) 250 257 190 250 220 288 185 162 270 285 500...
13.50 The owner of a moving company typically has his most experienced manager predict the total...
13.50 The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business ob jective of developing a more accurate method of predicting labor hours. In a preliminary effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved and the number...
The horsepower (Y, in bhp) of a motor car engine was measured at a chosen set...
The horsepower (Y, in bhp) of a motor car engine was measured at a chosen set of values of running speed (X, in rpm). The data are given below (the first row is the running speed in rpm and the second row is the horsepower in bhp): rpm 1100 1400 1700 2300 2700 3200 3500 4000 4600 5200 5600 6100 Horsepower (bhp) 50.26 63.89 77.51 126.43 131.03 154.26 176.92 195.02 225.47 240.79 275.9 312.5 The mean and sum of squares...
Birth weight and gestational age. The Child Health and Development Studies considered pregnancies among women in...
Birth weight and gestational age. The Child Health and Development Studies considered pregnancies among women in the San Francisco East Bay area. Researchers took a random sample of 50 pregnancies and used statistical software to construct a linear regression model to predict a baby's birth weight in ounces using the gestation age (the number of days the mother was pregnant). A portion of the computer output and the scatter plot is shown below. Round all calculated results to four decimal...
1. For a pair of sample x- and y-values, what is the difference between the observed...
1. For a pair of sample x- and y-values, what is the difference between the observed value of y and the predicted value of y? a) An outlier b) The explanatory variable c) A residual d) The response variable 2. Which of the following statements is false: a) The correlation coefficient is unitless. b) A correlation coefficient of 0.62 suggests a stronger correlation than a correlation coefficient of -0.82. c) The correlation coefficient, r, is always between -1 and 1....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT