Emily Smith decides to buy a fuel-efficient used car. Here are several vehicles she is considering, with the estimated cost to purchase and the age of the vehicle. Age (Years) 10 Vehicle Honda Insight Toyota Prius Toyota Prius Toyota Echo Honda Civic Hybrid Chevrolet Prizm Mazda Protégé Toyota Corolla Acura Integra Scion xB Scion xA Mazda 3 Mini Cooper Estimated Cost ($) |2130 12236 |12136 |14876 18966 |12494 13870 12188 18230 |4589 |7715 |6371 15293 16 18 |4 11 19 15 16 11 19 11 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Develop a trendline and state the following. equation should be rounded to 2 decimal places. Negative values should have a minus sign in front of them) (Coefficients should be round to 3 decimal places and the regression Correlation Coefficient: Coefficient of Determination: Regression equation: ŷ = [ b. Interpret the meaning of the slope. c. Estimate the cost of a car that is 6 years old. (Round to 2 decimal places.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Please assist and answer questions a, b, c, d, e, f, g, h

Thank you. 

Emily Smith decides to buy a fuel-efficient used car. Here are several vehicles she is considering, with the estimated cost to purchase
and the age of the vehicle.
Y
Vehicle
Honda Insight
Toyota Prius
Toyota Prius
Toyota Echo
Honda Civic Hybrid
Chevrolet Prizm
Mazda Protégé
Toyota Corolla
Acura Integra
Scion xB
Scion xA
Mazda 3
Mini Cooper
Estimated Cost ($)
2130
12236
|12136
14876
18966
12494
13870
12188
|18230
4589
Age (Years)
10
4
1
6
1
11
7715
6371
15293
11
19
Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to
your computer and be able to use it in Excel.
a. Develop a trendline and state the following.
equation should be rounded to 2 decimal places. Negative values should have a minus sign in front of them)
Correlation Coefficient
Coefficient of Determination:
(Coefficients should be round to 3 decimal places and the regression
Regression equation: ŷ =
b. Interpret the meaning of the slope.
c. Estimate the cost of a car that is 6 years old.
(Round to 2 decimal places.)
Transcribed Image Text:Emily Smith decides to buy a fuel-efficient used car. Here are several vehicles she is considering, with the estimated cost to purchase and the age of the vehicle. Y Vehicle Honda Insight Toyota Prius Toyota Prius Toyota Echo Honda Civic Hybrid Chevrolet Prizm Mazda Protégé Toyota Corolla Acura Integra Scion xB Scion xA Mazda 3 Mini Cooper Estimated Cost ($) 2130 12236 |12136 14876 18966 12494 13870 12188 |18230 4589 Age (Years) 10 4 1 6 1 11 7715 6371 15293 11 19 Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Develop a trendline and state the following. equation should be rounded to 2 decimal places. Negative values should have a minus sign in front of them) Correlation Coefficient Coefficient of Determination: (Coefficients should be round to 3 decimal places and the regression Regression equation: ŷ = b. Interpret the meaning of the slope. c. Estimate the cost of a car that is 6 years old. (Round to 2 decimal places.)
Conduct the hypothesis test to determine whether the regression slope coefficient is equal to 0. Test using a significance level of 0.05.
d. What are the null and alternate hypotheses?
Ho: (Click to select) v
H1: (Click to select) v
|(Click to select) v
|(Click to select) v
e. Compute the value of the test statistic?
sign in front of them)
(Round your answer to 2 decimal places. Negative values should have a minus
f. Determine the p-value
(Round your final answer to 4 decimal places.)
g. What is your decision regarding the null hypothesis?
O Fail to reject the null.
O Reject the null.
h. Interpret the result.
Transcribed Image Text:Conduct the hypothesis test to determine whether the regression slope coefficient is equal to 0. Test using a significance level of 0.05. d. What are the null and alternate hypotheses? Ho: (Click to select) v H1: (Click to select) v |(Click to select) v |(Click to select) v e. Compute the value of the test statistic? sign in front of them) (Round your answer to 2 decimal places. Negative values should have a minus f. Determine the p-value (Round your final answer to 4 decimal places.) g. What is your decision regarding the null hypothesis? O Fail to reject the null. O Reject the null. h. Interpret the result.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman