Analyze the data from Part 1 using Microsoft® Excel® software
Analyze the data from Part 1 using Microsoft® Excel® software.
Write a 700- to 875-word paper that includes the following information:
· Describe what method you are using to compare groups.
· Copy and paste the output into a Microsoft® Word document, and also answer the following questions:
o What is the significance level of the comparison?
o What was the alpha level you identified in Week 3?
o What was the means and variance for each variable?
o What was the test statistic?
o What was the critical value for both the one- and two-tailed test?
o Was your test one-tailed or two-tailed?
o Were you able to reject the null hypothesis? In other words, did you prove there was a difference?
· Talk about what these results mean in everyday language and in context to your chosen scenario.
· Make a recommendation based on the findings.
Format your paper according to APA guidelines.
Example of Output You Would Use to Answer These Questions
| t Test: Two-Sample Assuming Equal Variances | ||
| Variable 1 | Variable 2 | |
| Mean | 4.875 | 8 |
| Variance | 5.267857143 | 18.28571429 |
| Observations | 8 | 8 |
| Pooled variance | 11.77678571 | |
| Hypothesized mean difference | 0 | |
| df | 14 | |
| t stat | -1.821237697 | |
| P(T <= t) one-tail | 0.045002328 | |
| t Critical one-tail | 1.761310136 | |
| P(T <= t) two-tail | 0.090004655 | |
| t Critical two-tail | ||
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
