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. Vehicle Estimated Cost $ 5,555 $17,888 $ 9,963 $ 6,793 $10.774 $16,310 $ 2.475 s 2 $ 2,808 *,073 $ 8,978 $11,213 $ 9,463 $15,055 $20,705 Age Honda Insight Toyota Prius Toyota Prius Toyota Echo Honda Civic Hybrid Honda Civic Hybrid Chevrolet Cruz 8 3 Mazda3 Toyota Corolla Acura 10 Acura Integra Scion xB Scion xA 3 Mazda3 2 Mini Cooper 2 a. Create a scatter plot of the data. 1. On the graph below, use the point tool to plot the point corresponding to the first Age and its Estimated Cost (Age 1). 2. Repeat the process for the remainder of the sample (Age 2, Age 3, .. ). 3. To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y. Emily Smith Age 1 25000- Age 2 20000 - Age 3 15000 - Age 4 10000 - Age 5 5000 - Age 6 0 - 2 3 4 10 Age 7 Age b-1. Calculate the correlation coefficient. (Negative value should be indicated by a minus sign. Round your answer to 3 decimal places.) Coefficient of correlation b-2. What does it indicate about the relationship between cost and age? There is a v relationship between cost and age. strong inverse week inverse c-1. Complete a regression analysis of the relationship. (Negative value should be indicated by a minus sign. Round your answer to 4 decimal places.) Slope c-2. Report and interpret the coefficient of determination. (Round your answer to 2 decimal places.) Coefficient of determination % d. Compute the regression equation that predicts cost. (Round your answers to 4 decimal places.) Estimated Cost

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 provide step-by-step answers for the questions below a., b-1., b-2., c-1., c-2., d., e., f. with Excel formulas/Excel Data Analysis, math formulas, and also Minitab instructions if possible. Please provide also answers rounded to decimal places like asked in the questions.

 

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.

 

$ 6,793
Mazda3
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.
Vehicle
Honda Insight
Toyota Prius
Toyota Prius
Estimated Cost
Age
$ 5,555
8
$17,888
$ 9,963
Toyota Echo
Honda Civic Hybrid
Honda Civic Hybrid
$10,774
$16,310
s 2
$ 2,475
Chevrolet Cruz
* 2,808
S 7,073
$ 8,978
10
Toyota Corolla
Acura Integra
Scion xB
$11,213
$ 9,463
$15,055
$20,705
Scion xA
3
Mazda3
2
Mini Cooper
2
a. Create a scatter plot of the data.
1. On the graph below, use the point tool to plot the point corresponding to the first Age and its Estimated Cost (Age 1).
2. Repeat the process for the remainder of the sample (Age 2, Age 3, ... ).
3. To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y.
Emily Smith
Age 1
25000 -
Age 2
20000 -
Age 3
15000 -
Age 4
10000 -
Age 5
5000 -
Age 6
1
2
3
5
6
7
8
9
10
Age 7
Age
b-1. Calculate the correlation coefficient. (Negative value should be indicated by a minus sign. Round your answer to 3 decimal
places.)
Coefficient of correlation
b-2. What does it indicate about the relationship between cost and age?
There is a
relationship between cost and age.
strong inverse
week inverse
c-1. Complete a regression analysis of the relationship. (Negative value should be indicated by a minus sign. Round your
answer to 4 decimal places.)
Slope
c-2. Report and interpret the coefficient of determination. (Round your answer to 2 decimal places.)
Coefficient of determination
%
d. Compute the regression equation that predicts cost. (Round your answers to 4 decimal places.)
ý =
e. Is the slope of the regression line significantly different from zero?
O Yes
O No
f. Estimate the cost of a 5-year-old car. (Round your answer to the nearest whole dollar amount.)
Predicted cost
Estimated Cost
Transcribed Image Text:$ 6,793 Mazda3 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. Vehicle Honda Insight Toyota Prius Toyota Prius Estimated Cost Age $ 5,555 8 $17,888 $ 9,963 Toyota Echo Honda Civic Hybrid Honda Civic Hybrid $10,774 $16,310 s 2 $ 2,475 Chevrolet Cruz * 2,808 S 7,073 $ 8,978 10 Toyota Corolla Acura Integra Scion xB $11,213 $ 9,463 $15,055 $20,705 Scion xA 3 Mazda3 2 Mini Cooper 2 a. Create a scatter plot of the data. 1. On the graph below, use the point tool to plot the point corresponding to the first Age and its Estimated Cost (Age 1). 2. Repeat the process for the remainder of the sample (Age 2, Age 3, ... ). 3. To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y. Emily Smith Age 1 25000 - Age 2 20000 - Age 3 15000 - Age 4 10000 - Age 5 5000 - Age 6 1 2 3 5 6 7 8 9 10 Age 7 Age b-1. Calculate the correlation coefficient. (Negative value should be indicated by a minus sign. Round your answer to 3 decimal places.) Coefficient of correlation b-2. What does it indicate about the relationship between cost and age? There is a relationship between cost and age. strong inverse week inverse c-1. Complete a regression analysis of the relationship. (Negative value should be indicated by a minus sign. Round your answer to 4 decimal places.) Slope c-2. Report and interpret the coefficient of determination. (Round your answer to 2 decimal places.) Coefficient of determination % d. Compute the regression equation that predicts cost. (Round your answers to 4 decimal places.) ý = e. Is the slope of the regression line significantly different from zero? O Yes O No f. Estimate the cost of a 5-year-old car. (Round your answer to the nearest whole dollar amount.) Predicted cost Estimated Cost
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Fundamental Counting Principle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
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