HCM 506 SEU Applied Biostatistics Test Analysis

Attached Files:

Framingham Heart Study Dataset-Student 2021.xlsx (685.055 KB)

Critical Thinking Assignment (105 points)

  • This week we are learning about ordinal/categorical, continuous, and dichotomous variables. Using the Gestation Demographics SEU dataset that is located in the tabs at the bottom of the Framingham dataset provided, perform the following problems using R Studio or 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. See the example in Introductory Statistics with R on pages 71-7 or pages 123-124 in EXCEL statistics A quick guide. 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 SEU 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) 

Expert Solution Preview

Introduction:

The assignment requires the use of the Gestation Demographics SEU dataset, located in the tabs at the bottom of the provided Framingham dataset to explore ordinal/categorical, continuous, and dichotomous variables. The following questions require students to use R Studio or Excel to create distribution graphs and determine the mean of the age of women in the dataset. Additionally, students will need to test the hypothesis that the mean age for women giving birth is 32 years.

Answer 1:
To create a simple distribution graph (histogram) in Excel to explore the age of women after giving birth to their first child, follow the steps below:
1. Open the Gestation Demographics SEU dataset in Excel.
2. Select the column that contains the age of women after giving birth to their first child.
3. Click on the “Insert” tab in the ribbon.
4. Click on the “Histogram” chart type.
5. Excel will automatically create a histogram chart that shows the frequency distribution of the age of women.

Answer 2:
To determine the mean of the age of women in the Gestation Demographics SEU dataset, follow these steps in Excel:
1. Open the dataset in Excel.
2. Select the column that contains the age of women after giving birth to their first child.
3. Click on the “Formulas” tab in the ribbon.
4. Click on the “More Functions” dropdown.
5. Select “Statistical” and choose “AVERAGE”.
6. Excel will automatically calculate and display the mean age of the women.

Answer 3:
To test the hypothesis that the mean age for women giving birth is 32 years using the Gestation Demographics SEU dataset, follow these steps in Excel:
1. Open the dataset in Excel.
2. Select the column that contains the age of women after giving birth to their first child.
3. Click on the “Data” tab in the ribbon.
4. Click on “Data Analysis” in the “Analysis” section.
5. If the “Data Analysis” tool is not available, click on “Add-Ins” and check “Analysis ToolPak”. Click “OK”.
6. Select “t-Test: Two-Sample Assuming Equal Variances” from the list and click “OK”.
7. In the “Variable 1 Range” and “Variable 2 Range” fields, enter the cells containing the age of women after giving birth to their first child.
8. In the “Hypothesized Mean Difference” field, enter 0.
9. Click “OK” to run the analysis.
10. Check the “t-Statistic” and “P(T

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions