The Tampa bay (Florida) Area Chamber of Commerce wanted to know whether the mean weekly salary of nurses was larger than that of school teachers. To investigate, they collected the following information on the amounts earned last week by a sample of school teachers and nurses.
Pease show work with formulas in Excel Spread sheet
Questions: Is it reasonable to conclude that the mean weekly salary of nurses is higher? What is the p value?
Teachers Nurses - Null Hypothesis
845 841 -
826 890 - Alternate Hypothesis Alpha 0.01 Given
827 821 -
875 771 - Choice of test
784 850 -
809 859 - Degree of Freedom
820 829 - Critical value of test
830 - Answer to the test you calculated
832 - p value*
To compute the actual value you can use the '=TDIST' formula
=TDIST(x, df, tails) ----- see Excel Help
Show your work to compute the test in this area
The Tampa bay (Florida) Area Chamber of Commerce scenario is assessed.