Explore BrainMass

# Hypothesis Testing: t-test for a population mean

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

Refer to the OECD data in the attached EXCEL file, which reports information on census, economic, and business data for 29 countries.

Conduct a hypothesis to determine if the mean number of people employed was less than 20,000. (Remember the data is reported in thousands, so the actual number employed is 20,000,000) Use the .05 significance level.

Estimate the p-value

https://brainmass.com/statistics/students-t-test/hypothesis-testing-t-test-for-a-population-mean-27323

#### Solution Preview

I have attached an Excel Sheet with the calculations for your problem. I have also attached a Word document explaining how to use the Excel sheet to solve your problem and how to use the same sheet for other similar problems, hypothesis tests and confidence intervals for samples small enough to use the t distribution.

Refer to the OECD data in Appendix E, which reports information on census, economic, and business data for 29 countries.
Conduct a hypothesis to determine if the mean number of people employed was less than 20,000. (Remember the data is reported in thousands, so the actual number employed is 20,000,000) Use the .05 significance level. Estimate the p-value

Solution

Please see the Excel Sheet, "solution_t_test_004.xls", that I have attached for this ...

#### Solution Summary

I have attached an Excel Sheet with the calculations for your problem. I have also attached a Word document explaining how to use the Excel sheet to solve your problem and how to use the same sheet for other similar problems, hypothesis tests and confidence intervals.

\$2.49