Explore BrainMass
Share

The Tampa bay (Florida) Area Chamber of Commerce

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

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

© BrainMass Inc. brainmass.com October 24, 2018, 7:14 pm ad1c9bdddf
https://brainmass.com/economics/finance/the-tampa-bay-florida-area-chamber-of-commerce-61602

Solution Summary

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

$2.19
See Also This Related BrainMass Solution

Nurses' Salary Determination

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.

Questions: Is it reasonable to conclude that the mean weekly salary of nurses is higher? What is the p value?

Please show all work and answers in Excel format.

View Full Posting Details