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 | 2.144786688 |
|
| GROUP 1 | GROUP 2 | |
| 1.3 | 6.5 | |
| 2.5 | 8.7 | |
| 2.3 | 9.8 | |
| 8.1 | 10.2 | |
| 5 | 7.9 | |
| 7 | 6.5 | |
| 7.5 | 8.7 | |
| 5.2 | 7.9 | |
| 4.4 | 8.7 | |
| 7.6 | 9.1 | |
| 9 | 8.4 | |
| 7.6 | 6.4 | |
| 4.5 | 7.2 | |
| 1.1 | 5.8 | |
| 5.6 | 6.9 | |
| 6.2 | 5.9 | |
| 7 | 7.6 | |
| 6.9 | 7.8 | |
| 5.6 | 7.3 | |
| 5.2 | 4.6 | |
| 9 | 8.4 | |
| 7.6 | 6.4 | |
| 4.5 | 7.2 | |
| 1.1 | 5.8 | |
| 5.6 | 6.9 | |
| 6.2 | 5.9 | |
| 7 | 7.6 | |
| 6.9 | 7.8 | |
| 5.6 | 7.3 | |
| 5.2 | 4.6 | |
