Fluent Essays

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).   Fill out the worksheet. Course Project, Part II Preliminary Calculations Round Preliminary Values to the nearest whole number. Summary Table for: Live Births Mean Median Sample Standard Deviation Minimum Maximum Sample Size Summary Table for: Deaths Mean Median Sample Standard Deviation Minimum Maximum Sample Size Summary Table for: Divorces Mean Median Sample Standard Deviation Minimum Maximum Sample Size Summary Table for: Marriages Mean Median Sample Standard Deviation Minimum Maximum Sample Size Hypothesis Testing With the information that you gather from the Summary Tables above, test the following (you can use excel when appropriate): Hypothesis Test #1: 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. Step 1: Clearly state a null and alternative hypothesis, identify the claim, and the type of test. Ho: μ ≥ ≤ = Ha: μ < > ≠ Circle One: Left Tailed Test Right Tailed Test Two-Tailed Test Step 2: Determine the Rejection Region Pick ONE multiple choice answer below and fill in the critical value. Round Critical Value to two decimal places. a) Reject Ho if Z ___________ b) Reject Ho if Z ___________ c) Reject Ho if Z is less than ___________ or greater than ___________ . Step 3: Give the value of the test statistic and the P-Value Z = _____________ P-Value = ______________ Step 4: Clearly state your conclusion Circle One: Reject the Null Hypothesis….. OR…… Fail to Reject the Null Hypothesis Step 5: Explain what your conclusion means in context of the data. There _______ (IS/IS NOT) sufficient statistical evidence to ________ (SUPPORT/REJECT) the claim that the average amount of births is _________ (GREATER THAN/LESS THAN/EQUAL TO) 5000 in the United States and territories at the 0.05 level of significance. Hypothesis Test #2: 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. Step 1: Clearly state a null and alternative hypothesis, identify the claim, and the type of test. Ho: μ ≥ ≤ = Ha: μ < > ≠ Circle One: Left Tailed Test Right Tailed Test Two-Tailed Test Step 2: Determine the Rejection Region Pick ONE multiple choice answer below and fill in the critical value. Round Critical Value to two decimal places. a) Reject Ho if Z ___________ b) Reject Ho if Z ___________ c) Reject Ho if Z is less than ___________ or greater than ___________ . Step 3: Give the value of the test statistic and the P-Value Z = ___________________ P-Value = _____________________ Step 4: Clearly state your conclusion Circle One: Reject the Null Hypothesis….. OR…… Fail to Reject the Null Hypothesis Step 5: Explain what your conclusion means in context of the data. There _______ (IS/IS NOT) sufficient statistical evidence to ________ (SUPPORT/REJECT) the claim that the average amount of deaths is _________(GREATER THAN/LESS THAN/EQUAL TO) 6000 in the United States and territories at the 0.10 level of significance. Hypothesis Test #3: 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. Step 1: Clearly state a null and alternative hypothesis, identify the claim, and the type of test. Ho: μ ≥ ≤ = Ha: μ < > ≠ Circle One: Left Tailed Test Right Tailed Test Two-Tailed Test Step 2: Determine the Rejection Region Pick ONE multiple choice answer below and fill in the critical value. Round Critical Value to two decimal places. a) Reject Ho if Z ___________ b) Reject Ho if Z ___________ c) Reject Ho if Z is less than ___________ or greater than ___________ . Step 3: Give the value of the test statistic and the P-Value Z = ____________________ P-Value = ______________________ Step 4: Clearly state your conclusion Circle One: Reject the Null Hypothesis….. OR…… Fail to Reject the Null Hypothesis Step 5: Explain what your conclusion means in context of the data. There _______ (IS/IS NOT) sufficient statistical evidence to ________ (SUPPORT/REJECT) the claim that the average amount of marriages is _________ (GREATER THAN/LESS THAN/EQUAL TO) 2500 in the United States and territories at the .05 level of significance. Hypothesis Test #4: 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. Step 1: Clearly state a null and alternative hypothesis, identify the claim, and the type of test. Ho: μ ≥ ≤ = Ha: μ < > ≠ Circle One: Left Tailed Test Right Tailed Test Two-Tailed Test Step 2: Determine the Rejection Region Pick ONE multiple choice answer below and fill in the critical value. Round Critical Value to two decimal places. a) Reject Ho if Z ___________ b) Reject Ho if Z ___________ c) Reject Ho if Z is less than ___________ or greater than ___________ . Step 3: Give the value of the test statistic and the P-Value Z = ___________________ P-Value= __________________ Step 4: Clearly state your conclusion Circle One: Reject the Null Hypothesis….. OR…… Fail to Reject the Null Hypothesis Step 5: Explain what your conclusion means in context of the data. There _______ (IS/IS NOT) sufficient statistical evidence to ________ (SUPPORT/REJECT) the claim that the average amount of divorces is _________ (GREATER THAN/LESS THAN/EQUAL TO) 4000 in the United States and territories at the 0.10 level of significance. Hypothesis Test #5: Make-Up Your Own Test Determine if there is sufficient evidence to conclude the average amount of ________________ is _______________________ in the United States and territories at the ________ level of significance. Step 1: Clearly state a null and alternative hypothesis, identify the claim, and the type of test. Ho: μ ≥ ≤ = Ha: μ < > ≠ Circle One: Left Tailed Test Right Tailed Test Two-Tailed Test Step 2: Determine the Rejection Region Pick ONE multiple choice answer below and fill in the critical value. Round Critical Value to two decimal places. a) Reject Ho if Z ___________ b) Reject Ho if Z ___________ c) Reject Ho if Z is less than ___________ or greater than ___________ . Step 3: Give the value of the test statistic and the P-Value Z = _______________________ P-Value = ____________________ Step 4: Clearly state your conclusion Circle One: Reject the Null Hypothesis….. OR…… Fail to Reject the Null Hypothesis Step 5: Explain what your conclusion means in context of the data. There _______ (IS/IS NOT) sufficient statistical evidence to ________ (SUPPORT/REJECT) the claim that the average amount of ________________ is _____________________ (GREATER THAN/LESS THAN/EQUAL TO) ____________ in the United States and territories at the ________ level of significance. Sheet1 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 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 Colorado 5,878 6,556 3,459 4,621 Connecticut 5,878 6,308 2,054 4690 Delaware 1,043 2090 785 1011 District of Columbia 547 509 330 814 Florida 7,764 8,055 9,016 8,980 Georgia 5,001 5,767 2,341 5,345 Hawaii 3,043 2527 1,579 2078 Idaho 997 899 654 665 Illinois 5,865 7,378 2,562 4,470 Indiana 5,976 6,591 2,012 4137 Iowa 5,078 7,272 1,599 4499 Kansas 2,987 3,953 978 3,078 Kentucky 5,015 4,315 2,598 3,784 Louisiana 4,856 3,723 2,233 3,467 Maine 2,032 1989 585 1969 Maryland 5,378 6,316 2,118 4,389 Massachusetts 5,898 6,594 2,608 4,362 Michigan 5,128 6,999 2,742 4,397 Minnesota 5,528 6,057 1,200 4987 Mississippi 2,598 2,374 1,098 2156 Missouri 5,012 4,981 2,147 4,192 Montana 936 1094 416 534 Nebraska 5,148 5,969 940 4,498 Nevada 7,134 7,600 9,472 4,331 New Hampshire 1,254 1001 287 467 New Jersey 5,915 5,609 2,172 2,992 New Mexico 1,898 1,798 799 628 New York 16,190 17,882 3,114 9,982 North Carolina 6,120 6,196 2,035 5,153 North Dakota 643 607 298 611 Ohio 9,941 9,819 4,729 4,585 Oklahoma 3,015 3,846 1,619 2,368 Oregon 2,910 2,873 1,808 2,543 Pennsylvania 13,789 15,339 4,823 8,412 Rhode Island 1,092 999 1001 1000 South Carolina 5,891 5,674 3,607 4,232 South Dakota 1,845 1267 174 987 Tennessee 7,045 7,804 2,863 6,616 Texas 16,198 20,527 9,238 15,684 Utah 2,817 2,143 1,504 2090 Vermont 1,928 1987 1,096 1,029 Virginia 8,067 8,897 2,782 7,195 Washington 4,139 5,944 2,323 4,444 West Virginia 2,967 3,819 3,215 3,119 Wisconsin 3,967 5,769 2,818 3,406 Wyoming 813 1098 727 968 Puerto Rico 2,457 5,102 3,098 982