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

Describe and critique a current article that relates to Nursing Assignment Help

Describe and critique a current article that relates to hospital financing and competitive practices in healthcare. (Article should be from a scholarly, peer-reviewed journal published within the last 3-5 years). Submit 1,000-1,500-word paper with a KU title page and reference page in a scholarly format. You are a medical professor

GCU Patient Preferences in Care Discussion Reply Nursing Assignment Help

please respond to the following discussion as a peer making a comment. Hello everyone, Integrating patient preferences and values with clinician expertise is essential when making evidence-based decisions. This approach leads to patient-centered care, improves treatment adherence, and enhances health outcomes. Patients’ unique values, beliefs, priorities, and circumstances can significantly

UM Administrator in Training Rotation Experience Report Nursing Assignment Help

Complete and Submit the Three Sections of the Report for the Assignment: AIT Experience: LTC Settings and Services Report Template (ATTACHED) APA: Include APA 7th Edition Formatted Reference Page. ALL RESPONSES IN PARAGRAPH FORM. Complete Section 1 of the Report Select the Long Term Care (LTC) Settings and Services: ALREADY

NYU Autoimmune Disease of Myelin Abstract Nursing Assignment Help

`The disease is called MS You should read Wikipedia “Immune System”, “Antibody”,  “Antigen”, “T  cell”, “B cell”, “Macrophage”, “Dendritic cell”  for writing your abstract. It would also be good to read the Wikipedia article on MS.  The purpose of writing an abstract is to condense the material you have read

Within the Professions of Psychology Paper Nursing Assignment Help

PSY 540 Final Project Guidelines and Rubric Overview Within the professions of psychology, it can be typical for you to work on proposals for programs, studies, or new initiatives. For example, you may work for a university that regularly partners with foundations and corporations to identify grant opportunities for projects

Professional Ethics Instructions Baccalaureate education Nursing Assignment Help

Professional Ethics Instructions Baccalaureate education includes the development of professional values and value-based behavior (AACN, 2008). Ethics define professional ethics and their importance in the healthcare environment. The American Nurses Association has approved 13 standardized languages that support nursing care.  The benefits of standardized language include: better communication among nurses

Select one of the following populations: Aging Nursing Assignment Help

Select one of the following populations: Aging Population Homelessness Migrant Workers LGBTQIA+ Other Identified Vulnerable Populations from Your Reading Then complete the following steps for your discussion post: Identify which vulnerable population you have chosen to use for this post and describe what this vulnerable population looks like in your

WGU Population Health Data Analysis Paper Nursing Assignment Help

In this course, you learned that Informatics for Transforming Nursing Care integrates nursing science with multiple information and analytical sciences to identify, define, manage, and communicate data, information, knowledge, and wisdom in nursing practice. This provides knowledge and skills to apply informatics concepts, communications, and data critical to facilitating interprofessional

Professional EthicsInstructions Baccalaureate education Nursing Assignment Help

Professional EthicsInstructions Baccalaureate education includes the development of professional values and value-based behavior (AACN, 2008). Ethics define professional ethics and their importance in the healthcare environment. The American Nurses Association has approved 13 standardized languages that support nursing care.  The benefits of standardized language include: better communication among nurses and

HSA 599 SU Public Health Emergencies Discussion Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. Discuss a life-threatening event or a natural disaster in your community, such as a severe weather event, terrorist attack, or other type of public health emergency. Examine an overall strategy that

Develop a literature map or a visual representation of the Nursing Assignment Help

Develop a literature map or a visual representation of the Public Health Informatics literature.  Also include a powerpoint presentation explaining the literature map with the slides Constructing a literature map helps you: develop an understanding of the key issues and research findings in the literature organize ideas see how different research studies