The Tampa bay (Florida) Area Chamber of Commerce
Not what you're looking for?
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
Purchase this Solution
Solution Summary
The Tampa bay (Florida) Area Chamber of Commerce scenario is assessed.
Purchase this Solution
Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.