Statistics

Using the Gestation Demographics dataset provided (attached), perform the following problems using Excel.

1. Create a simple distribution graph (histogram) where we will explore the age of women after giving birth to their first child. Remember that a histogram consists of parallel vertical bars that show the frequency distribution of a quantitative variable in the graph. The area of each bar is equal to the frequency of items found in each class.

2. Determine the mean of the age of the women in the Gestation Demographics dataset.

3. Test the hypothesis that the mean age (μ = μ0) for women is 37 years in the Gestation Demographics dataset.

Print your plots to PDF or take screenshots and include with your submission along with the excel sheet. Present your findings in a Word document, with a title page included.