Hypothesis Testing is the use of statistics to determine the probability that a given claim is true. In Part II of this project, your professor will provide you with a data set and you will review claims and perform hypothesis testing to make a decision. You will then complete a write-up that includes the calculations. The government logs the number of documented births, deaths, marriages and divorces however it is possible to have undocumented cases. In part II of this project, you are going to test claims about total births, deaths, marriages and divorces. Your professor will provide you with the Births, Marriage, Divorce and Death data. Email your professor at the beginning of Week 7 if you did not receive the data for Course Project Part II.Preliminary Calculations. Please complete the worksheet.Project Part II Worksheet (Links to an external site.)Complete the summary table for 1. Live Births, 2. Deaths, 3. Marriages, and 4. Divorces highlighting the mean, median, sample/population standard deviation, n = number of states that submitted data for each the data sets. Summary Table for _________Mean Median Standard Deviation n (Number of States who submitted Data) Hypothesis TestingWith 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, in your report, be sure to—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.4. Make your OWN Claim (You are completing ONE more Hypothesis Test)Lastly, propose and conduct your own test of hypothesis.a) Pick one data set: Births, Deaths, Marriages OR Divorces.b) 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.attached is the worksheet and data for part 2 in excel and then the part two is under the work u already done for me