One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The editor is particularly interested in the relationship between highway mileage and curb weight of the vehicles.

a. Develop a scatter plot for these data. Discuss what the plot implies about the relationship between two variables. Assume that you wish to predict highway mileage by using vehicle curb weight.

b. Compute the correlation coefficient for the two variables and test to determine whether there is a linear relationship between the curb weight and the highway mileages of automobiles.

c. (1) Compute the linear regression equation based on the sample data (2) Cadillac's 1999 Sedan DeVille weight approximately 4,012 pounds. Provide an estimate of the average highway mileage you would expect to obtain from this model

[See automobile information attached in solution.]

Solution Preview

One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The editor is particularly interested in the relationship between highway mileage and curb weight of the vehicles.

a. Develop a scatter plot for these data. Discuss what the plot implies about the relationship between two variables. Assume that you wish to predict highway mileage by using ...

SimpleLinearRegression and Multiple Regression.
I'd like to ask whether you think multiple regression (the use of more IV's) is always better than simpleregression? Why or why not?
What problems may exist with multiple regression that are not an issue for simplelinearregression?

Develop simplelinearregression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually. Do the assumptions of linearregression hold for your models? How do these models compare to the multiple regression models?

Please see the attached file for complete questions.
1. The following results were obtained as part of a simplelinearregressionanalysis.
We wish to test Ho: β = 0. The computed value of the test statistics is ________
2. The following results were obtained as part of a simplelinearregressionanalysis.
For

This problem has to be done in Excel.
Prepare a forecast, using simplelinearregression, for each quarter of the next year from the following past 2 years' quarterly sales information.
Quarter Sales
1----- 160
2----- 195
3----- 150
4----- 140
5----- 215
6----- 240
7----- 205
8----- 190

1. Describe what a line is that satisfies the least-squares property-what is it and what is the function? (Please share your own way of understanding it).
2. This week we looked at regressionanalysis. What is the difference between a simpleregressionanalysis and multiple regression? Please give examples.

Application of simplelinearregressionanalysis to the estimation of a demand equation has yielded the following
Q = 24 - 2P
If the current product price is P=$6 and the quantity sold per time period is Q = 10, then the erro (e) for the current time period is equal to (actual quantity sold - estimated quantity sold)?
1

For the y and x values listed in file XR15066, obtain the simplelinearregression equation, then analyze the residuals by (a) constructing a histogram, (b) using a normal probability plot, (c) plotting the residuals versus the x values and (d) plotting the residuals versus the order in which they were observed. Do any of the as

1)Given the regression equation: Y = 1.3479 + 0.3978 X, what is the fitted value (orY ? ) if X = -3?
2) Calculate bo, b1 for the information provide below
X Y
-2 9
0 5
-0.5 7
1 100

The attached file contains observations of the American minimum wage during each of the years from 1950 through 2004. Has the minimum wage been growing at roughly a constant rate over this period? Use simplelinearregressionanalysis to address this question. Explain your results.

SimpleLinearRegression -- Sales
"A recent study was conducted to determine the relation between advertising expenditures and sales of widgets for the first year of production.
"
You would like to determine the effect of your ad expenditures in predicting sales.
the following data was colle