Question

Use the car data. Run a simple regression analysis to how Drive_Ratio affects MPG.

MPG	Drive_Ratio
16.9	2.73
15.5	2.26
19.2	2.56
18.5	2.45
30	3.7
27.5	3.05
27.2	3.54
30.9	3.37
20.3	3.9
17	3.5
21.6	3.77
16.2	3.58
20.6	2.73
20.8	3.08
18.6	2.71
18.1	2.73
17	2.41
17.6	2.26
16.5	2.26
18.2	2.45
26.5	3.08
21.9	3.08
34.1	3.73
35.1	2.97
27.4	3.08
31.5	3.78
29.5	3.05
28.4	2.53
28.8	2.69
26.8	2.84
33.5	2.69
34.2	3.37
31.8	3.7
37.3	3.1
30.5	3.7
22	3.7
21.5	3.64
31.9	3.78

a. Find the regression coefficient (slope) for Drive_Ratio.

b. Find the p-value. (Please input a decimal value; Please input 0 or 0.0001 if it is smaller than 0.0001 )

Answer 1

Ran the regression analysis from the data analysis toolpack as shown in Yellow in the datatab on the right top corner and then select regression and fill data as shown above in the box

If it is not active for you check Microsoft help on how to enable the same

Results of the regression analysis below

a) Find the regression coefficient (slope) for Drive_Ratio. Ans=> 5.277044 (As shown above)

b)P value in the 1st table shown = 0.0091584

which says that the regression eqn is significant

Hope the above answer has helped you in understanding the problem. Please upvote the ans if it has really helped you. Good Luck!!