I will provide you with data on an excel sheet that highlights…
Question Answered step-by-step I will provide you with data on an excel sheet that highlights… 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 worksheeta) Fill out the four summary tables.b) With the information that you gather from the summary tables, test the following (you can use excel when appropriate):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.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.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.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— Choose the correct symbols to communicate the null and alternative hypothesis. State which is the claim.Give the value of the test statisticReport the P-ValueClearly state your conclusion (Reject the Null or Fail to Reject the Null)Explain what your conclusion means in context of the data.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. a) Pickonedata set: Births, Deaths, Marriages ORb) Write a claim about the data set.c) For your claim—Clearly state a null and alternative hypothesisGive the value of the test statisticReport the P-ValueClearly state your conclusion (Reject the Null or Fail to Reject the Null)Explain what your conclusion means in context of the data. Course Project, Part IIPreliminary CalculationsRound Preliminary Values to the nearest whole number. Summary Table for: Live Births MEAN MEDIAN SAMPLE STANDARDDEVIATION MINIMUM MAXIMUM SAMPLE SIZE summary table for: Deaths MEAN MEDIAN SAMPLE STANDARDDEVIATION MINIMUM MAXIMUM SAMPLE SIZE summary table for Marriages MEAN MEDIAN SAMPLE STANDARDDEVIATION MINIMUM MAXIUM SAMPLE SIZE Sample table for Divorces MEAN MEDIAN SAMPLE STANDARD DEVIATION MINIMUM MAXIUM SAMPLE SIZE DATAProvisional Number of Live Births, Deaths, Marriages and Divorces.Each State, D.C. and Puerto RicoMay 2022Live Births Deaths Marriages DivorcesAlabama 6,399 8,108 1,909 3,476Alaska 6,189 5,101 160 1,068Arizona 5,146 5,434 2,089 3,864Arkansas 7,209 6,078 1,960 3,514California 22,283 18,870 11,095 23,282Colorado 6,008 7,027 3,462 6,140Connecticut 6,008 6,812 1,798 6,221Delaware 1,788 3,165 294 1,910District of Columbia 1,665 1,798 172 1,680Florida 7,655 8,323 10,460 11,248Georgia 5,243 6,344 2,137 6,989Hawaii 3,534 3,544 1,235 3,161Idaho 1,747 2,136 140 1,505Illinois 5,998 7,738 2,399 5,963Indiana 6,093 7,058 1,748 5,573Iowa 5,310 7,646 1,259 5,998Kansas 3,484 4,777 523 4,332Kentucky 7,442 5,090 2,442 5,159Louisiana 5,117 4,577 2,010 4,788Maine 2,651 3,078 142 3,032Maryland 5,572 6,820 1,873 5,868Massachusetts 6,025 7,060 2,454 5,837Michigan 5,353 7,409 2,612 5,878Minnesota 5,703 6,595 786 6,569Mississippi 3,145 3,411 666 3,252Missouri 5,252 5,665 1,682 5,638Montana 1,694 2,305 142 1,351Nebraska 5,371 6,519 479 5,996Nevada 7,104 7,929 10,301 5,801New Hampshire 1,973 2,224 121 1,272New Jersey 6,040 6,208 1,938 4,232New Mexico 2,534 2,914 311 1,460New York 16,807 16,818 3,054 12,422North Carolina 6,220 6,716 1,776 6,764North Dakota 1,440 1,884 120 1,442Ohio 9,555 9,848 4,967 6,098Oklahoma 3,509 4,684 1,283 3,499Oregon 3,417 3,844 1,507 3,706Pennsylvania 14,180 14,620 5,077 10,583Rhode Island 1,830 2,222 551 1,897South Carolina 6,019 6,265 3,638 5,684South Dakota 2,489 2,455 122 1,882Tennessee 7,028 8,105 2,755 8,478Texas 17,141 19,105 8,938 19,104Utah 3,336 3,212 1,146 3,174Vermont 2,560 3,076 664 1,931Virginia 7,918 9,051 2,660 9,157Washington 4,491 6,497 2,116 5,933West Virginia 3,466 4,661 3,173 4,380Wisconsin 4,339 6,346 2,702 4,716Wyoming 1,588 2,309 227 1,859Puerto Rico 3,023 5,769 3,035 1,876 Hypothesis TestingWith 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-ValueZ = _____________ P-Value = ______________Step 4: Clearly state your conclusionCircle 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-ValueZ = ___________________ P-Value = _____________________Step 4: Clearly state your conclusionCircle 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-ValueZ = ____________________ P-Value = ______________________Step 4: Clearly state your conclusionCircle 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-ValueZ = ___________________ P-Value= __________________Step 4: Clearly state your conclusionCircle 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 TestDetermine 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-ValueZ = _______________________ P-Value = ____________________Step 4: Clearly state your conclusionCircle 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 Math Statistics and Probability MATH 399N Share QuestionEmailCopy link Comments (0)
