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