Part 2
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