Monday, November 12, 2012

Excel 2 - T-test Male and Female

This assignment was to generate descriptive statistics for male and female scores.  There is a difference between the male and female scores, but the null hypothesis no difference.  Please view chart below.

t-Test: Two-Sample Assuming Equal Variances
MaleFemale
Mean216.8445876224.6254524
Variance51.3896014840.67736669
Observations5348
Pooled Variance46.30399506
Hypothesized Mean Difference0
df99
t Stat-5.73873942
P(T<=t) one-tail5.22017E-08
t Critical one-tail1.660391156
P(T<=t) two-tail1.04403E-07
t Critical two-tail1.984216952















  

No comments:

Post a Comment