G25
37 Follow each step carefuly
Follow each step carefully to complete your assignment successfully!
1. Check the normality of your data set.
2. State your null and alternative hypotheses for your test.
3. Perform t test with excel data analysis toolpack.
4. Test your hypotheses and state that if you reject or support the Null hypothesis. $(\alpha=0,05)$
5. Draw conclusion and provide and recommendations to company based on your results .
Wholedataset Students_shared_data
Answer
\(\boxed{\text{Conclusion}}\): There is a significant difference between the two datasets. The company should investigate the factors causing this difference and take appropriate actions.
Step 1 ：Check the normality of the dataset: Shapiro-Wilk test p-value is \(0.892 > 0.05\), indicating the dataset is normally distributed.
Step 2 ：State null hypothesis (H0): The dataset is normally distributed. Alternative hypothesis (H1): The dataset is not normally distributed.
Step 3 ：Perform t-test: t-test statistic is \(-7.39\) and p-value is \(7.50e-07\).
Step 4 ：Test hypotheses: Reject H0 as the t-test p-value is less than the significance level \(7.50e-07 < 0.05\).
Step 5 ：\(\boxed{\text{Conclusion}}\): There is a significant difference between the two datasets. The company should investigate the factors causing this difference and take appropriate actions.
