Statistics - Five Step Hypothesis
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")
Attachments
Solution Summary
A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.