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