3. I will provide you with data on an excel sheet that highlights births, deaths, marriages and divorces along with Course Project Part II Worksheet Template (attached).

1. Fill out the worksheet.

1. a) Fill out the four summary tables.
2. b) With the information that you gather from the summary tables, test the following (you can use excel when appropriate):
3. Determine if there is sufficient evidence to conclude the average amount of births is over 5000 in the United States and territories at the 0.05 level of significance.
4. Determine if there is sufficient evidence to conclude the average amount of deaths is equal to 6000 in the United States and territories at the 0.10 level of significance.
5. Determine if there is sufficient evidence to conclude the average amount of marriages is greater or equal to 2500 in the United States and territories at the .05 level of significance.
6. Determine if there is sufficient evidence to conclude the average amount of divorces is less than or equal to 4000 in the United States and territories at the 0.10 level of significance.

For each of the tests above, on the worksheet, be sure to

1. Choose the correct symbols to communicate the null and alternative hypothesis. State which is the claim.
2. Give the value of the test statistic
3. Report the P-Value
4. Clearly state your conclusion (Reject the Null or Fail to Reject the Null)
5. Explain what your conclusion means in context of the data.
6. c) Make your OWN Claim (You are completing ONE more Hypothesis Test). There is an area for this task on the worksheet.

Lastly, propose and conduct your own test of hypothesis.

1. a) Pick one data set: Births, Deaths, Marriages OR
2. b) Write a claim about the data set.
3. c) For your claim
4. Clearly state a null and alternative hypothesis
5. Give the value of the test statistic
6. Report the P-Value
7. Clearly state your conclusion (Reject the Null or Fail to Reject the Null)
8. Explain what your conclusion means in context of the data.

M P W B C D E F G H I J K L N 0 Q R S T U X A Provisional Number of Live Births, Deaths, Marriages and Divorces. Each State, D.C. and Puerto Rico July 2021 Live Births Deaths Marriages Divorces Alabama 5,230 7,807 2,148 2,348 Alaska 4,089 4328 320 292 10 Arizona 4,890 4,714 2,300 2,678 Arkansas 5,087 5,460 2,190 2,379 California 20,789 20,255 10,254 19,250 13 Colorado 5,878 6,556 3,459 4,621 14 Connecticut 5,878 6,308 2,054 4690 15 Delaware 1,043 2090 785 1011 District of 16 Columbia 547 509 330 814 Florida 7,764 8,055 9,016 8,980 18 Georgia 5,001 5,767 2,341 5,345 19 Hawaii 3,043 2527 1,579 2078 20 Idaho 997 899 654 665 21 Illinois 5,865 7,378 2,562 4,470 22 Indiana 5,976 6,591 2,012 4137 23 lowa 5,078 7,272 1,599 4499 24 Kansas 2,987 3,953 978 3,078 25 Kentucky 5,015 4,315 2,598 3,784 26 Louisiana 4,856 3,723 2,233 3,467 27 Maine 2,032 1989 585 1969 28 Maryland 5,378 6,316 2,118 4,389 29 Massachusett 5,898 6,594 2,608 4,362 30 Michigan 5,128 6,999 2,742 4,397 31 Minnesota 5,528 6,057 1,200 4987 32 Mississippi 2,598 2,374 1,098 2156 33 Missouri 5,012 4,981 2,147 4,192 34 Montana 936 1094 416 534 35 Nebraska 5,148 5,969 940 4,498 36 Nevada 7,134 7,600 9,472 4,331 New 37 Hampshire 1,254 1001 287 467 38 New Jersey 5,915 5,609 2,172 2,992 39 New Mexico 1 898 1 798 799 628 Sheet1 +