Question: 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

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)

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!