Scenario #2

Please go to the website https://www.census.gov/data/datasets/2017/demo/popproj/2017-popproj.html and download Table 1. Projected Population by Single Year of Age, Sex, Race, and Hispanic Origin for the United States: 2016 to 2060 in excel file. Among all the data inputs, look only for when all sex, origin, and race are "0." Then, look for data inputs in the column of POP_1 and POP_2.

A. Conduct 95% confidence interval for each POP_1 and POP_2 using mean and standard deviation calculated using excel.

B. With the data inputs on file, is there a sufficient evidence that the population mean in POP_1 is lower than the one in POP_2 (sex, origin, and race are all "0") with 4% level of significance? (Show all five steps)

C. How about POP_3 and POP_4? Is there a sufficient evidence that the population mean in POP3 is greater than the one in POP_4 (sex, origin, and race are all "0") with 5% level of significance? (Show all five steps)