# Hypothesis Testing: t-test for a population mean

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

Â© BrainMass Inc. brainmass.com October 6, 2022, 9:49 am ad1c9bdddfhttps://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.