Hello, help needed in the next 3 hours!! Please use excel tests and explain each step or function used. The data is attached below, with wheelbase less than 111 highlighted in yellow and wheelbase greater than or equal to 111 highlighted in blue. Thank you!!
III. Sort by wheelbase by less than 111 and >= 111 Compare mean diameter needed for U turn, for the sorted data, using test of hypothesis for comparing the two means. Test whether the means are unequal. Use alpha = 0.01. Use appropriate test for comparing two means.
A. State the Null and Alternate Hypothesis
B. Explain why the test you used is appropriate for the problem.
C. Obtain the normal probability plot. Individual plot for each sample. Are the two populations normally distributed? Yes or No. State clearly.
D. Write your conclusion based on the result you obtain.
A 1 Make 2 BMW 3 BMW 4 BMW 5 BMW 6 BMW 7 Dodge 8 Dodge 6 Dodge 10 Dodge 11 Dodge 12 Kia 13 Kia 14 Kia 15 Kia 16 Kia 17 Nissan 18 Nissan 19 Nissan 20 Nissan 21 Nissan 22 Nissan
B Wheelbase UTurn 96 36 101 36 101 37 102 37 104 37 106 38 106 38 106 38 107 38 109 38 110 38 111 112 39 112 40 116 40 117 40 118 40 120 40 120 41 121 42 126 42