Data 275 Introduction to Data AnalyticsExam 2

Instructions:Use theCar_sales.savdataset for this exam. Answer all questions. Make sure your answers are inblackcolored font.

1.A colleague of yours has told you that the length of an automobile is approximately2.6 timesits width. Perform a one sample t-test using the data onlength to widthto test the validity of your colleague's statement by responding to the following questions.

a.State the null and alternate hypotheses of the test:

H₀:

H₁:

b.What is the mean for thelength to width ratio?

c.Carry out the t-test and report the results below?

d.What is your conclusion t-test results?

2.Perform a multiple regression to predict the4-year resale valueof a car. Include all the other numeric variable as independent variables except thelength to width ratio.

a.How much variation in4-year resale valueis explained by the variation in the independent variables in your model?

b.Which variables (including the constant term) are statistically significantat the 10% level of significance testing?

c.Which variables (including the constant term) are statistically significantat the 5% level of significance testing?

d.Exclude the variables that are not statistically significant at either the 10% or the 5% levels of significance testing and re-estimate the model. How much variation in4-year resale valueis explained by the variation in the independent variables in your model?

e.Which variables are statistically significant at5% level of significance testing?

f.Based on your response in part (e) and above, write an equation that you would use to predict4-year resale value.

g.Compute and report the means of the right hand side (RHS) variables in your equation above.

h.Predict4-year resale valueusing the mean values of the RHS variables.

3.Save your syntax file and submit it on blackboard.