-Test (Customer Satisfaction) 83.82026173 77.00078604 79.89368992 86.204466 84.33778995 70.1136106 79.75044209 74.24321396 sample size standard deviation Standard error Average Hypothesized mean T-Test DF p-value (Lower end) 74.48390574 p-value (upper end) 77.05299251 p-value (two tailed) 75.72021786 82.27136753 78.80518863 75.60837508 77.21931616 76.66837164 82.47039537 73.97420868 76.56533851 70.7295213 62.23505092 78.26809298 79.32218099 71.2891749 86.34877312
Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points.
1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75.
(Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you should use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting null. If alternative is directional (e.g., μ < 75), you should use the lower-tailed p-value. For alternative hypothesis μ > 75, you should use the upper-tailed p-value.)
H0 =
H1=
Conclusion: The p value from one sample t-test is _______. Since the two-tailed p-value is _______
2. Two-Sample T-Test: Compare the average sales revenue of two different regions to determine if there is a significant difference.
(Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting null)
H0 =
H1=
Conclusion:
3. Paired T-Test: A company implemented a training program to improve employee performance. To evaluate the effectiveness of the program, the company recorded the test scores of 25 employees before and after the training. Determine if the training program is effective in terms of scores of participants before and after the training.
(Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional, use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting the null)
H0 =
H1=
Conclusion:
4. One-Way ANOVA: Analyze the customer satisfaction scores across four different product categories to determine if there is a significant difference in means.
(Hints: The null can be about maintaining status-quo or no difference among groups)
H0 =
H1=
Step by step
Solved in 2 steps with 8 images
