This Week You Will Submit The Second Part Of The Course Proj ✓ Solved
This Week You Will Submit The Second Part Of the Course Project You C
This week you will submit the second part of the course project. You completed Part I in Week 6 and will complete Part II this week. Hypothesis Testing is the use of statistics to determine the probability that a given claim is true. In Part II of this project, you will choose a data set, review claims and perform hypothesis testing and 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.
Deliverables
Choose a Data Set
Go to (Links to an external site.) In the search bar type: Births, Marriages, Divorces, and Deaths. Pick a DataSet and download the PDF document and make note of the volume, number, and date. For example, you could use the National Vital Statistics Reports. Pick the same month/year combination for each data set, such as September 2009.
Preliminary Calculations
Create a summary table for each of the following: 1. Live Births, 2. Deaths, 3. Marriages, and 4. Divorces. Highlight the mean, median, sample standard deviation, minimum and maximum values for each data set. You will have four tables, each showing the list of values for each state, the District of Columbia, and Puerto Rico (a total of 52 numbers for each data set).
Summary Table Example
For each data set, prepare a table similar to the following:
- Mean
- Median
- Standard Deviation
- Minimum
- Maximum
Hypothesis Testing
Using the summarized data, perform the following hypothesis tests (using Excel when appropriate):
- Test if there is sufficient evidence to conclude that the average number of births exceeds 5000 in the United States and territories at the 0.05 level of significance.
- Test if there is sufficient evidence to conclude that the average number of deaths equals 6000 in the United States and territories at the 0.10 level of significance.
- Test if there is sufficient evidence to conclude that the average number of marriages is greater than or equal to 2500 in the United States and territories at the 0.05 level of significance.
- Test if there is sufficient evidence to conclude that the average number of divorces is less than or equal to 4000 in the United States and territories at the 0.10 level of significance.
For each test, you should:
- Clearly state the null and alternative hypotheses.
- Provide the value of the test statistic.
- Report the p-value.
- State your conclusion (Reject or Fail to Reject the Null).
- Explain what this conclusion means in the context of the data.
Additional Hypothesis Test
Finally, propose and conduct your own hypothesis test related to the Birth, Death, Marriage, or Divorce data analyzed above, following the same five-step process.
Software Requirements
Use Microsoft Office Word and Excel to perform calculations, data analysis, and report writing.