Share
Explore BrainMass

The Tampa bay (Florida) Area Chamber of Commerce

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
802 825
820 829 - Critical value of test
829
830 - Answer to the test you calculated
842
832 - p value*

* HINT:

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

Solution Summary

The Tampa bay (Florida) Area Chamber of Commerce scenario is assessed.

$2.19