Question

An engineer wishes to determine if the stopping distance for midsize automobiles is different from that of compact automobiles at 75 mph. The data is shown below.

Automobile	Midsize	Compact
1	188	200
2	190	211
3	195	206
4	192	297
5	186	198
6	194	204
7	188	218
8	187	212
9	214	196
10	203	193

a) State the null and alternate hypotheses.
b) Use a Wilcoxon rank sum test to determine if there is a difference in the stopping distances between Midsize and compact cars. Copy and paste the results of the test into your Word document.
c) Include a carefully-worded conclusion in both statistical terms and in the context of the problem.

Please state each formula and explain each step in excel.

Answer 1

a.