Hello dear, please help me to solve the problem as follows:

Requirement: Need to follow the rubric and use excel to solve this problem:

Rubric for problem number 2:

a) Provide the multiple regression equation (6 points)

Interpret the coefficient of the variable Miles (3 points) and the coefficient of the variable age (3

points). For the interpretation, use a sentence such as: if the number of miles increases by one

we expect the yearly maintenance expense to increase by b1(replace the value of the

coefficient) dollars when the age of the truck is held constant.

Explain whether the difference in the magnitudes of the coefficients tell us something about the

relative importance of the variables in predicting the maintenance expense. (2 points).

b) Locate the standard error of the estimate on the regression report and provide an

interpretation. Look at page 439 for examples of how to interpret this estimate. (4 points)

c) Locate the R-square on the regression report and provide an interpretation. Look at page 441 for examples of how to interpret this measure. (4 points)

The data of problem number 2 is:

Truck	Maintenance Expense	Miles Driven	Age of Truck
1	$908.56	10,500	10
2	$751.12	9,700	7
3	$793.55	9,200	8
4	$619.61	8,300	9
5	$380.11	6,500	5
6	$368.72	4,500	2
7	$235.32	3,500	2
8	$174.93	2,200	3
9	$256.30	1,800	2
10	$799.58	9800	7
11	$436.04	6600	5
12	$304.25	3600	1
13	$226.81	2500	3
14	$179.68	3100	3
15	$726.65	8400	10
16	$810.53	9700	9
17	$142.53	1800	4
18	$915.53	10000	11
19	$813.45	9800	8
20	$803.78	9900	7
21	$227.32	1100	1
22	$231.46	2600	1
23	$839.21	10300	6