Question
I will provide you with data on an excel sheet that highlights births, deaths,marriagesand divorces along withCourse Project Part IIWorksheet Template (attached) Fill out the
- I will provide you with data on an excel sheet that highlights births, deaths,marriagesand divorces along withCourse Project Part IIWorksheet Template (attached)
- Fill out the worksheet
- a)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 thenull and alternative hypothesis. State which is the claim.
- Give the value of the test statistic
- Report the P-Value
- Clearly 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, MarriagesOR
- b) Write a claim about the data set.
- c) For your claim
- Clearly state a null and alternative hypothesis
- Give the value of the test statistic
- Report the P-Value
- Clearly 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 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 Marriages
MEAN | |
MEDIAN | |
SAMPLE STANDARD DEVIATION | |
MINIMUM | |
MAXIUM | |
SAMPLE SIZE |
Sample table for Divorces
MEAN | |
MEDIAN | |
SAMPLE STANDARD DEVIATION | |
MINIMUM | |
MAXIUM | |
SAMPLE SIZE |
DATA
Provisional Number of Live Births, Deaths, Marriages and Divorces.Each State, D.C. and Puerto Rico May 2022 Live Births Deaths Marriages Divorces Alabama 6,399 8,108 1,909 3,476 Alaska 6,189 5,101 160 1,068 Arizona 5,146 5,434 2,089 3,864 Arkansas 7,209 6,078 1,960 3,514 California 22,283 18,870 11,095 23,282 Colorado 6,008 7,027 3,462 6,140 Connecticut 6,008 6,812 1,798 6,221 Delaware 1,788 3,165 294 1,910 District of Columbia 1,665 1,798 172 1,680 Florida 7,655 8,323 10,460 11,248 Georgia 5,243 6,344 2,137 6,989 Hawaii 3,534 3,544 1,235 3,161 Idaho 1,747 2,136 140 1,505 Illinois 5,998 7,738 2,399 5,963 Indiana 6,093 7,058 1,748 5,573 Iowa 5,310 7,646 1,259 5,998 Kansas 3,484 4,777 523 4,332 Kentucky 7,442 5,090 2,442 5,159 Louisiana 5,117 4,577 2,010 4,788 Maine 2,651 3,078 142 3,032 Maryland 5,572 6,820 1,873 5,868 Massachusetts 6,025 7,060 2,454 5,837 Michigan 5,353 7,409 2,612 5,878 Minnesota 5,703 6,595 786 6,569 Mississippi 3,145 3,411 666 3,252 Missouri 5,252 5,665 1,682 5,638 Montana 1,694 2,305 142 1,351 Nebraska 5,371 6,519 479 5,996 Nevada 7,104 7,929 10,301 5,801 New Hampshire 1,973 2,224 121 1,272 New Jersey 6,040 6,208 1,938 4,232 New Mexico 2,534 2,914 311 1,460 New York 16,807 16,818 3,054 12,422 North Carolina 6,220 6,716 1,776 6,764 North Dakota 1,440 1,884 120 1,442 Ohio 9,555 9,848 4,967 6,098 Oklahoma 3,509 4,684 1,283 3,499 Oregon 3,417 3,844 1,507 3,706 Pennsylvania 14,180 14,620 5,077 10,583 Rhode Island 1,830 2,222 551 1,897 South Carolina 6,019 6,265 3,638 5,684 South Dakota 2,489 2,455 122 1,882 Tennessee 7,028 8,105 2,755 8,478 Texas 17,141 19,105 8,938 19,104 Utah 3,336 3,212 1,146 3,174 Vermont 2,560 3,076 664 1,931 Virginia 7,918 9,051 2,660 9,157 Washington 4,491 6,497 2,116 5,933 West Virginia 3,466 4,661 3,173 4,380 Wisconsin 4,339 6,346 2,702 4,716 Wyoming 1,588 2,309 227 1,859 Puerto Rico 3,023 5,769 3,035 1,876
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started