If you order your assignment right now, you will be eligible for a great discount.

# Week 7 Course Project II- i have included the worksheet and data needed to compl

Week 7 Course Project II- i have included the worksheet and data needed to complete the asignment
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.
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 the null 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, Marriages OR
b) Write a claim about the data set.
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.