Trevor’s Used Car Lot has numerous cars with affordable prices. Mr. Trevor asked an advertising firm
Question: Trevor’s Used Car Lot has numerous cars with affordable prices. Mr. Trevor asked an advertising firm to develop a “catchy” ad to help him sell more cars. A statistician employed by the ad firm decided to take a random sample of the prices of the cars with each corresponding age. She thought it would be a good way to get started on the commercial. Below is her sampling.
| Car # | Price of Car | Age of Car (in yrs.) |
| 1 | $14, 750 | 2 |
| 2 | $ 6, 770 | 6 |
| 3 | $12, 115 | 3 |
| 4 | $17,825 | 2 |
| 5 | $ 8,500 | 5 |
| 6 | $ 7,000 | 4 |
| 7 | $10,250 | 2 |
| 8 | $13,450 | 2 |
| 9 | $ 9,895 | 3 |
| 10 | $ 8,000 | 4 |
| 11 | $10,125 | 1 |
| 12 | $16,500 | 1 |
| 13 | $ 5,500 | 4 |
| 14 | $ 6,850 | 3 |
| 15 | $ 15,000 | 2 |
The correlation coefficient is 
-0.70015
After seeing Trevor’s catchy ad, Davy Jones wants to buy a car from him. Use the data from the Trevor Car Lot and process it by the Regression program in Excel.
(a) Paste your printout here, or attach it to this assignment.
(b) Write the regression equation. Use it to find the predicted price of a three-year-old car that Mr. Jones wants to buy.
Deliverables: Word Document
-
Solution: Refer to your Excel regression report. Look for the ANOVA report. Identify this F ratio. What does t #16377
-
[Solution] Shaver Manufacturing, Inc., offers dental insurance to its employees. A recent study by the human re #20273
-
[Solved] The heights in feet of people who work in an office are as follows. Use the range rule of thumb to f #6982
-
[Solution] This problem will introduce the learner into a technique called Analysis of Variance. For #27900
-
Math and Statistics Calculator
-
Math and Statistics Solutions
