Explore BrainMass

Explore BrainMass

    Hypothesis Testing: t-test for a population mean

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 5:28 pm ad1c9bdddf
    https://brainmass.com/statistics/students-t-test/hypothesis-testing-t-test-for-a-population-mean-27323

    Attachments

    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.19

    ADVERTISEMENT