Question
How well does a cars age predict its resale value?Below is sample date for a particular make and model of vehicle, comparing its age (in
How well does a cars age predict its resale value?Below is sample date for a particular make and model of vehicle, comparing its age (in years) to its resale value.Based on the data , answer the questions below:
Age (years) Price ($)
9 10200
6 7000
3 10200
3 17200
10 7800
7 8000
3 12200
5 15800
2 18600
5 17800
4 10200
6 7400
4 15800
9 4200
6 7400
5 11400
7 8000
11 4400
8 3200
2 19600
1) What is the value of the correlation coefficient?(CAREFUL:EXCEL'S REGRESSION FUNCTION WILL NOT LET YOU KNOW WHETHER OR NOT THIS VALUE IS NEGATIVE)(ANSWER TO 2 DECIMAL PLACES)
2) What is the value of the coefficient of determination?(ANSWER TO 2 DECIMAL PLACES)
3) State the estimated regression equation.(ANSWER ONLY THE VALUE AFTER THE EQUAL SIGN WITH VARIABLES TO 0 DECIMAL PLACES.FOR EXAMPLE IF THE EQUATION IS: y = 12,345.67x + 98,765.43...YOUR ANSWER IS: 12,346x + 98,765)
4) Predict the resale value of a vehicle that is 7 years old.(ANSWER TO 0 DECIMAL PLACES...INCLUDE UNITS WITH ANSWER)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started