PLEASE HELP ME ENTER INTO EXCEL

You are given data on recently completed auctions of Mini Coopers.

Use this data to build a linear regression model to predict the estimated selling price of Mini Coopers

using age and mileage as predictor variables.

Complete the following tasks:

1

Use the Data Analysis, Regression tool of Excel to generate summary output.

2

Develop a regression based forecast of selling prices of Mini Coopers.

3

On a line graph show the actual and regression forecasted selling prices of cars - the title of the graph

should display your name.

4

Interpret the value of R square.

5

Are the results statistically significant at the .05 level? Explain.

6

Interpret the values of X coefficients for each of the predictor variables in your model.

7

What other variables would you recommend to build a more accurate regression model for this problem?

8

On a separate sheet (rename it LEAST_SQR_Minis) find the values of b0, b1 and b2 parameters using the method of least squares.

Price	Age	Mileage
$18,999.00	2	15,195
$28,999.00	4	11,371
$40,700.00	1	700
$7,200.00	3	771,464
$8,499.00	8	53,282
$12,750.00	5	62,400
$10,501.00	2	13,200
$11,655.55	6	49,683
$11,997.00	5	92,000
$19,985.00	1	25,502
$17,500.00	4	13,200
$16,991.00	3	28,969
$16,305.02	1	13,804
$14,050.00	4	57,998
$13,995.00	5	46,863
$7,000.00	8	102,000
$8,300.00	7	77,938
$18,218.00	1	7,200
$24,000.00	2	29,500
$19,900.00	4	43
$22,895.00	1	13,800
$20,200.00	2	14,000
$6,300.00	7	62,000
$17,000.00	2	13,000
$10,000.00	7	66,272
$8,876.98	7	64,000
$20,500.00	1	5,189
$15,000.00	6	48,678
$13,855.00	5	22,307
$14,850.00	4	28,000
$23,100.00	3	26,401
$19,900.00	4	13,379
$7,250.00	5	107,419
$11,109.99	4	32,998
$21,323.47	1	8,500
$5,000.00	5	49,549
$13,995.00	5	44,289
$14,000.00	2	18,799
$10,600.00	6	69,314
$22,900.00	4	26,883
$17,343.00	3	20,291
$20,500.00	1	5,207
$15,000.00	5	4,958
$13,899.00	5	22,409
$13,850.00	4	28,000
$24,100.00	3	26,304
$19,900.00	4	13,379
$7,150.00	5	108,429