Question: 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
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
