1. Statistics
2. Hypothesis Testing
3. 263141

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Five Step Hypothesis

Null should be: There is a difference between male and female salaries at all levels

ALternate should be: There is no difference between male and female salaries at all levels.

The conclusion of the parametric should be "Do Not Reject Ho"

contingency table Observed
Education male female total
High School 28 33 61
2 year college 8 7 15
4 years or higher 17 6 23 #NAME?
total 53 46 99

contingency table Expected
Null should be:  There is a difference between male and female salaries at all levels male female total
32.65656566 28.34343434 61
ALternate should be: There is no difference between male and female salaries at all levels. 8.03030303 6.96969697 15
12.31313131 10.68686869 23
The conclusion of the parametric should be "Do Not Reject Ho"   53 46 99

contingency table Chi-sq computations F-Test Two-Sample for Variances
Education male female
High School 0.663989102 0.765030922 Variable 1 Variable 2
2 year college 0.000114351 0.000131752 Mean 0.816037512 0.940217133
4 years or higher 1.784009082 2.055488725 Variance 0.812909142 1.079140727
total 5.268763934 chi sq Observations 3 3
df 2 2
F 0.753292987
P(F<=f) one-tail 0.42964467
F Critical one-tail 0.052631579
df 4
Alpha 0.05
Critical value 9.487729037
conclusion Do Not Reject Ho

=IF(Chi_Sq>Crit_Val, "Reject Ho", "Do Not Reject Ho")