Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data 275 Introduction to Data AnalyticsExam 2 Instructions:Use the Car_sales.sav dataset for this exam. Answer all questions. Make sure your answers are inblackcolored font. 1.A

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:

H0:

H1:

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry Enhanced With Graphing Utilities (Subscription)

Authors: Michael, Michael Sullivan III, Michael III Sullivan, Michael Sullivan 111, III Sullivan

6th Edition

0321849132, 9780321849137

More Books

Students also viewed these Mathematics questions