Healthcare Critical Thinking Gestation Demographics Dataset Excel Task
Using the Gestation Demographics dataset attached at the bottom of the Framingham dataset provided, perform the following problems using Excel.
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.
Determine the mean of the age of the women in the Gestation Demographics dataset.
- We will be testing the hypothesis that assumes the mean age (? = ?0) for women is 32 years in the Gestation Demographics SEU dataset.
- H0 The mean age of women giving birth is 32 years old. (Null Hypothesis)
- H1 The mean age of women giving birth is not 32 years old. (Alternative Hypothesis)
Ensure to submit the following requirements :
Present your findings in a Word document, by copying and pasting the histogram into the document.
After your analysis state whether you accept or reject the null hypothesis and your reasoning why.