Question

Use excels data analysis tool to preform a regression on the following set on numbers. Post your results.

MPG	Horsepower	Weight
43.1	48	1985
19.9	110	3365
19.2	105	3535
17.7	165	3445
18.1	139	3205
20.3	103	2830
21.5	115	3245
16.9	155	4360
15.5	142	4054
18.5	150	3940
27.2	71	3190
41.5	76	2144
46.6	65	2110
23.7	100	2420
27.2	84	2490
39.1	58	1755
28.0	88	2605
24.0	92	2865
20.2	139	3570
20.5	95	3155
28.0	90	2678
34.7	63	2215
36.1	66	1800
35.7	80	1915
20.2	85	2965
23.9	90	3420
29.9	65	2380
30.4	67	3250
36.0	74	1980
22.6	110	2800
36.4	67	2950
27.5	95	2560
33.7	75	2210
44.6	67	1850
32.9	100	2615
38.0	67	1965
24.2	120	2930
38.1	60	1968
39.4	70	2070
25.4	116	2900
31.3	75	2542
34.1	68	1985
34.0	88	2395
31.0	82	2720
27.4	80	2670
22.3	88	2890
28.0	79	2625
17.6	85	3465
34.4	65	3465
20.6	105	3380

Answer 1

Go to excel data analysis --> choose Regression statistics

Choose y weight as dependent variable and X as both MPG and horsepower as independent variable.

output:

Significance F is considered as p value.

P value = 4.22E-13 ( less than 0.05)

If the p-value is less than 0.05, we reject the null hypothesis that there's no difference between the means and conclude that a significant difference does exist.