Summarizing Data Collected in a Defined Population Sample- BIO4

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 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 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.

We will be testing the hypothesis that assumes the mean age (μ = μ0) for women is 37 years in the Gestation Demographics SEU dataset.

H0 The mean age of women giving birth is 37 years old. (Null Hypothesis)

H1 The mean age of women giving birth is not 37 years old. (Alternative Hypothesis)

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. Always use a title page, an introduction, a discussion where you interpret the meaning of the histogram, and a conclusion should be included. Your submission should be 2 pages to discuss and display your findings.

Provide support for your statements with in-text citations from a minimum of four scholarly, peer-reviewed articles. One of these sources may be from the class readings, textbook, or lectures, but the others must be external.

Materials:

Sullivan, L. M. (2018). Essentials of biostatistics in public health (3rd ed.). Jones & Bartlett: Boston, MA. ISBN-13:

9781284108194

Salkind, N. J. (2016). EXCEL statistics: A quick guide (3rd ed.). Sage.

 

Your paper must have

·       Introduction

·       involved all the description requirements

·       In text citation for each paragraph.

·       the date of references must be (recommend that you use more contemporary sources (last 5 years) not from provided materials

·       conclusion

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now