Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. I will provide you with data on an excel sheet that highlights births, deaths,marriagesand divorces along withCourse Project Part IIWorksheet Template (attached)
  2. Fill out the worksheet
  3. a)Fill out the four summary tables.
  4. b)With the information that you gather from the summary tables, test the following (you can use excel when appropriate):
  5. 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.
  6. 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.
  7. 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.
  8. 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 thenull 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) Pickonedata set: Births, Deaths, MarriagesOR
  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. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complex Analysis

Authors: Dennis G Zill, Patrick D Shanahan

3rd Edition

1449694624, 9781449694623

More Books

Students also viewed these Mathematics questions

Question

Define self-discipline. (p. 210)

Answered: 1 week ago