The accompanying data file shows the price, the age, and the mileage for 20 used sedans. Price Age Mileage 13590 6 61485 13775 6 54344 22991 1 8246 15303 4 24856 16388 3 22100 16600 3 23702 16987 4 47401 18489 2 16888 18859 3 35380 19857 3 29634 11877 9 55792 14989 3 46183 15900 3 37009 16500 4 45521 9440 9 86902 12988 5 77241 15777 6 59647 10490 9 93241 8938 10 48221 11988 8 42408

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

The accompanying data file shows the price, the age, and the mileage for 20 used sedans.

Price Age Mileage
13590 6 61485
13775 6 54344
22991 1 8246
15303 4 24856
16388 3 22100
16600 3 23702
16987 4 47401
18489 2 16888
18859 3 35380
19857 3 29634
11877 9 55792
14989 3 46183
15900 3 37009
16500 4 45521
9440 9 86902
12988 5 77241
15777 6 59647
10490 9 93241
8938 10 48221
11988 8 42408

 

1. Estimate the sample regression equation that enables us to predict the price of a sedan on the basis of its age and mileage.

Note: Negative values should be indicated by a minus sign. Round your answers to 2 decimal places. [If you are using R to obtain the output, then first enter the following command at the prompt: options(scipen=10). This will ensure that the output is not in scientific notation.]

2.  Interpret the slope coefficient of Age.

A. The slope coefficient of Age is −0.03, which suggests that for every additional year of age, the predicted price of car decreases by $0.03.
B. The slope coefficient of Age is −1021.82, which suggests that for every additional year of age, the predicted price of car decreases by $1021.82.
C. The slope coefficient of Age is −1021.82, which suggests that for every additional year of age, the predicted price of car decreases by $1021.82, holding number of miles constant.
D. The slope coefficient of Age is −0.03, which suggests that for every additional year of age, the predicted price of car decreases by $0.03, holding number of miles constant.
 

3. Predict the price of a five-year-old sedan with 65,000 miles.

Note: Do not round intermediate calculations. Round final answer to 2 decimal places.

 

 
Expert Solution
Step 1

1

Excel Procedure:

  • Enter the data of Price, Ae and Mileage in Excel
  • Data>Data Analysis> ‘Regression’
  • Select Price under ‘Input Y Range’
  • Select Age and Mileage under ‘Input X Range’
  • Click on ‘OK’.

Output:

Statistics homework question answer, step 1, image 1

From the output, the regression equation is,

Price=21618.76-1021.82Age-0.03Mileage.

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
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