# PUB 550 GCU Health Behaviors Descriptive Statistics in Excel and SPSS Project The purpose of this assignment is to compare basic functions in Excel and SPS

PUB 550 GCU Health Behaviors Descriptive Statistics in Excel and SPSS Project The purpose of this assignment is to compare basic functions in Excel and SPSS to calculate descriptive statistics and use this information to describe the sample.

For this assignment, students will utilize Excel with the Data Analysis ToolPak and SPSS Statistics and the “Example Dataset” to complete the assignment. Refer to the Topic Materials for assistance with enabling the Data Analysis ToolPak on a Mac or PC.

Don't use plagiarized sources. Get Your Custom Essay on
PUB 550 GCU Health Behaviors Descriptive Statistics in Excel and SPSS Project The purpose of this assignment is to compare basic functions in Excel and SPS
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!

Part 1:

Complete the following steps in both Excel and IBM SPSS Statistics.

Calculate mean, median, and mode for the variables “Annual Income” and “Age.” Show the appropriate summary tables for these measures from both Excel and SPSS. Include the other descriptive statistics that are a part of the summary output in Excel and SPSS.
Create histograms to show the distribution for “Annual Income” and “Age.” Copy and paste the histograms from Excel and export the histogram from SPSS into the Word document for this assignment.
Create frequency tables that include counts and percentages for smoking status, employment status, exercise level, and education level. Show the tables in the Word document for this assignment.

Part 2:

Based upon the Part 1 activities, write a 250-500 word interpretation that addresses the following.

Discuss the sampling strategy used in this study and if it resulted in a representative sample.
Discuss what you are able to ascertain about the sample from the descriptive statistics.
Explain what other variables the research team could have included to gain a better understanding of the population.

General Requirements

Submit one Word document for the Part 1 assignment content and a second Word document for Part 2 of the assignment. A local community organization was interested in learning about general health behaviors in the area and the
relationships between health behaviors and environmental and social determinants. They decided to conduct a
brief survey based on a convenient sample of people visiting the local shopping mall. They offered a \$5 incentive
for completing the survey. The Topic 1 Example dataset includes 30 observations from this survey. Use this data to
complete the relevant assignments in this course.
Education Level
1
2
3
Less than High School
Annual Income = US Dollars
ehaviors in the area and the
ts. They decided to conduct a
all. They offered a \$5 incentive
from this survey. Use this data to
ID
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
Sex
Female
Male
Female
Male
Female
Female
Female
Male
Female
Male
Female
Male
Female
Male
Male
Male
Female
Male
Male
Female
Female
Female
Male
Male
Female
Male
Female
Female
Male
Male
Smoker
No
No
Yes
No
Yes
Yes
No
Yes
Yes
No
No
No
Yes
No
No
No
No
Yes
Yes
No
Yes
No
No
No
No
Yes
Yes
No
No
Yes
Education_Level***
2
2
3
1
1
2
3
1
2
2
3
1
1
3
2
1
2
3
2
1
2
3
2
1
1
3
3
1
3
3
Minutes_Exercise
90
50
65
20
50
25
110
50
40
80
120
80
60
150
75
80
110
80
100
0
50
200
60
65
40
65
70
45
75
50
Age
45
58
31
54
30
18
39
37
44
24
42
50
20
35
61
59
36
35
29
32
26
42
52
49
21
48
40
53
46
42
Employed
Yes
No
Yes
No
Yes
No
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Yes
No
Yes
Yes
No
No
No
Yes
No
No
No
Yes
Yes
No
Yes
Yes
Annual_Income*Neighborhood
51000
B
23000
C
35000
B
10000
C
28000
B
5000
C
46000
A
36000
B
51000
C
12000
A
78000
A
34000
D
15000
B
28000
B
28000
A
24000
B
55000
D
62000
B
32000
D
7000
C
17000
B
64000
D
5000
A
14000
D
20000
C
72000
A
85000
A
15000
B
64000
C
27000
B

attachment

Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.