Need Help With This Assignment?

Let Our Team of Professional Writers Write a PLAGIARISM-FREE Paper for You!

SUBMIT YOUR ASSIGNMENT

Nursing

Descriptive Statistics

Descriptive Statistics

How many participants are in the sample? 30 Participants

Descriptive Statistics for Age

Sort by age

  1. What is the age range? 18years-61years

Enable the “Data Analysis ToolPak” in Excel. Use the Data Analysis Feature to find the mean and standard deviation for age.

  1. What is the mean age? 39.93years
  2. What is the standard deviation for age? 11.90
  3. Copy and Paste the Descriptive Statistics Output for age here:
Age
Mean 39.93333333
Standard Error 2.172944045
Median 41
Mode 42
Standard Deviation 11.9017047
Sample Variance 141.6505747
Kurtosis -0.790709921
Skewness -0.090911788
Range 43
Minimum 18
Maximum 61
Sum 1198
Count 30

Descriptive Statistics for Annual Income

Use the Data Analysis Feature to find the mean and standard deviation for the Annual Income.

  1. What is the mean income? $34,766.67
  2. What is the standard deviation for income? 22,875.50
  3. Copy and Paste the Descriptive Statistics Output for age here:
Annual_Income*
Mean 34766.66667
Standard Error 4176.47581
Median 28000
Mode 28000
Standard Deviation 22875.50012
Sample Variance 523288505.7
Kurtosis -0.60984206
Skewness 0.644837619
Range 80000
Minimum 5000
Maximum 85000
Sum 1043000
Count 30

Frequencies for Smoking Variable

Use the Pivot Table Feature to create frequency tables for the smoker variable.

  1. What percent of the sample identify as smokers? 40%
  2. Copy and Paste the Pivot Table here:
Smoker Yes
Count of Sex Column Labels
Row Labels Female Male Grand Total
103 1 1
105 1 1
106 1 1
108 1 1
109 1 1
113 1 1
118 1 1
119 1 1
121 1 1
126 1 1
127 1 1
130 1 1
Grand Total 7 5 12

Frequencies for Sex Variable

Use the Pivot Table Feature to create frequency tables for sex.

  1. What percent of the sample identified as male? 50%
  2. What percent of the model identified as female? 50%
  3. Copy and Paste the Pivot Table here:
Count of Sex Column Labels
Row Labels Female Male Grand Total
101 1 1
102 1 1
103 1 1
104 1 1
105 1 1
106 1 1
107 1 1
108 1 1
109 1 1
110 1 1
111 1 1
112 1 1
113 1 1
114 1 1
115 1 1
116 1 1
117 1 1
118 1 1
119 1 1
120 1 1
121 1 1
122 1 1
123 1 1
124 1 1
125 1 1
126 1 1
127 1 1
128 1 1
129 1 1
130 1 1
Grand Total 15 15 30

Descriptive Statistics Summary

Create a summary of the descriptive statistics conducted on the sample that answers the following in 250-500 words:

Summarize the survey. How many questions were there? How were the data collected?

The survey contained eight questions that aimed at obtaining crucial information about the general health behaviors of the local community. This information would aid decision-making and inform intervention measures in health promotion efforts. The survey entailed collecting primary data from the participants based on convenience sampling of the people visiting the local shopping grocery store. After answering the survey questions administered through interviewing, participants were tipped $5. Therefore, the quantitative data for the survey was conducted through sampling to obtain the primary data for analysis and inferences.

Discuss the sampling strategy used. Did this strategy result in a representative sample?

The sampling technique employed was a non-probability sampling. This is because the probability of a member participating in the study could not be calculated, but every member who visited the shopping grocery store was fit for the survey (Lavrakas, 2014). The sampling method used was convenience sampling, with the first convenient 30 people who visited the grocery, forming the sample size. However, the sample may not be a perfect representative of the population since it contained only people buying from a grocery. The model may not provide generalizable information about the general health behaviors of the local community since other people do not purchase from grocery stores but prefer supermarkets and other sources. Therefore, the researcher could have used several other purchasing points or destinations.

Describe the sample. Based on the calculated descriptive statistics and frequencies, what do we know about the piece?

From the descriptive statistics, the sample contained equal male and female participants with an average age of 39 years and periods ranging from 18 to 61 years with a standard deviation of 11.90. The majority of people were non-smokers (60%). The community had an average annual income of $34,766 (USD). The sample had an equal number of people who had less than a high school education, graduated from high school, and graduated from college. Fewer people (13) were unemployed than the employed (15). However, the sample was small.

Discuss two additional variables that could have been included in the survey to gain a better understanding of the population.

BMI: This is obtained by dividing the person’s weight (Kilograms) by their height in meters squared. This variable provides a better understanding of the population’s health since a high BMI indicates unhealthiness. Normal BMI should be between 19 and 24 (CDC, 2021).

Exercise/Physical Activity: This could be another variable that could offer additional insight into the health status of the community. The number of days people exercised per week could be another crucial variable.

References

CDC. (2021). Body Mass Index (BMI). Retrieved from https://www.cdc.gov/healthyweight/assessing/bmi/index.html

Lavrakas, P. J. (2014). Encyclopedia of survey research methods (Vols. 1-0). Thousand Oaks, CA: Sage Publications, Inc. doi: 10.4135/9781412963947

ORDER A PLAGIARISM-FREE PAPER HERE

We’ll write everything from scratch

Question 

Surveys are often used to gather public health information or data. The first step in analyzing the survey data is to conduct descriptive statistics. Descriptive statistics help provide basic information about the sample group, such as the average age and income. This information can then be analyzed to effectively measure and describe a population’s health status, behavior, and associated risk factors about these variables.

Descriptive Statistics

Descriptive Statistics

The purpose of this assignment is to use Excel to apply descriptive statistics in order to describe the sample who completed a health behavior survey. Use the “Health Behavior Data Set” and the “Descriptive Statistics in Excel Worksheet” to complete this assignment. Refer to the instructional videos in the topic resources as a guide.

For this assignment:

Use the “Data Analysis ToolPak” add-in and Pivot Tables to complete this assignment. Refer to the “Data Analysis ToolPak” resource in the topic resources. Click on the link and select either Windows or Mac for instructions. The Microsoft Excel add-in will enable you to conduct descriptive statistics in Excel.

Read the “Health Behavior Case History and Survey” document to familiarize yourself with the survey and its purpose.

Open the “Health Behavior Data Set” in the Excel. Analyze the survey data and answer the questions in the “Descriptive Statistics in Excel Worksheet.” Submit the “Descriptive Statistics in Excel Worksheet” to the dropbox.

APA style is not required, but solid academic writing is expected.