practice organizing data through ordering and grouping variables.
Data often appear disordered and it is difficult to see any connections or relationships. Ordering the data by certain variables or grouping variables into specific categories, such as age or sex categories, can help bring clarity to the data. Knowing how to organize data is an important skill to initiate the analytical process.
students will use Excel and SPSS Statistics to order variables. Using the “Example Dataset,” complete the steps below using both Excel and SPSS Statistics. View the Excel and SPSS tutorials for assistance in completing this assignmen
t.
Submit one Word document and include a screen shot of the data after completing the first two steps of Part 1 in Excel and SPSS to compare your results. Use a second Word document to complete Part 2 of the assignment.
Part 1: Ordering and Grouping Data Using Excel and SPSS
For Part 1, accomplish the following:
Part 2: Data Interpretation
Study the results of the dataset grouping and ordering. Discuss the following in a word summary:
t. Course Code
PUB-550
Class Code
PUB-550-O500
Criteria
Content
Percentage
100.0%
Part 1 – Excel and SPSS Screenshots
20.0%
Part 2 – Measurement Levels
15.0%
Part 2 – Ordering the Data
15.0%
Part 2 – Process Used for Grouping Data
15.0%
Part 2 – Grouping Variables by Category
15.0%
Part 2 – Study Discussion
15.0%
Mechanics of Writing (includes spelling,
punctuation, grammar, language use)
5.0%
Total Weightage
100%
Assignment Title
Data Management
Unsatisfactory (0.00%)
Screenshots illustrating the use of Excel and SPSS to order
and group variables are not included.
Description of the measurement levels for each of the
variables in the dataset is not included.
Discussion of what was learned from ordering the data by age
and why this information is important is not included.
Description of the process used to group the data in Excel and
SPSS is not included.
Description of what was learned from grouping variables by
the category of exercise is not included.
Discussion of whether study is correlational, experimental, or
quasi-experimental; the rationale for the study type; and
identification of a study question appropriate for the dataset
is not included.
Surface errors are pervasive enough that they impede
communication of meaning. Inappropriate word choice or
sentence construction is used.
Total Points
40.0
Less than Satisfactory (74.00%)
Screenshots illustrating the use of Excel and SPSS to order
and group variables are incomplete or incorrect.
Description of the measurement levels for each of the
variables in the dataset is incomplete or incorrect.
Discussion of what was learned from ordering the data by age
and why this information is important is incomplete or
incorrect.
Description of the process used to group the data in Excel and
SPSS is incomplete or incorrect.
Description of what was learned from grouping variables by
the category of exercise is incomplete or incorrect.
Discussion of whether study is correlational, experimental, or
quasi-experimental; the rationale for the study type; and
identification of a study question appropriate for the dataset
is incomplete or incorrect.
Frequent and repetitive mechanical errors distract the
reader. Inconsistencies in language choice (register) or word
choice are present. Sentence structure is correct but not
varied.
Satisfactory (79.00%)
Screenshots illustrating the use of Excel and SPSS to order
and group variables are partially complete and correct.
Description of the measurement levels for each of the
variables in the dataset is included but lacks explanation and
relevant details.
Discussion of what was learned from ordering the data by age
and why this information is important is included but lacks
explanation and relevant details.
Description of the process used to group the data in Excel and
SPSS is included but lacks explanation and relevant details.
Description of what was learned from grouping variables by
the category of exercise is included but lacks explanation and
relevant details.
Discussion of whether study is correlational, experimental, or
quasi-experimental; the rationale for the study type; and
identification of a study question appropriate for the dataset
is included but lacks explanation and justification.
Some mechanical errors or typos are present, but they are
not overly distracting to the reader. Correct and varied
sentence structure and audience-appropriate language are
employed.
Good (87.00%)
Screenshots illustrating the use of Excel and SPSS to order
and group variables are mostly complete and correct.
Description of the measurement levels for each of the
variables in the dataset is complete and includes explanation
and relevant details.
Discussion of what was learned from ordering the data by age
and why this information is important is complete and
includes explanation and relevant details.
Description of the process used to group the data in Excel and
SPSS is complete and includes explanation and relevant
details.
Description of what was learned from grouping variables by
the category of exercise is complete and includes explanation
and relevant details.
Discussion of whether study is correlational, experimental, or
quasi-experimental; the rationale for the study type; and
identification of a study question appropriate for the dataset
is complete and includes explanation and justification.
Prose is largely free of mechanical errors, although a few may
be present. The writer uses a variety of effective sentence
structures and figures of speech.
Excellent (100.00%)
Screenshots illustrating the use of Excel and SPSS to order
and group variables are complete and correct.
Description of the measurement levels for each of the
variables in the dataset is extremely thorough with
substantial explanation and relevant details.
Discussion of what was learned from ordering the data by age
and why this information is important is extremely thorough
with substantial explanation and relevant details.
Description of the process used to group the data in Excel and
SPSS is extremely thorough with substantial explanation and
relevant details.
Description of what was learned from grouping variables by
the category of exercise is extremely thorough with
substantial explanation and relevant details.
Discussion of whether study is correlational, experimental, or
quasi-experimental; the rationale for the study type; and
identification of a study question appropriate for the dataset
is extremely thorough and includes substantial explanation
and justification.
Comments
Writer is clearly in command of standard, written, academic
English.
Points Earned
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
Graduated High School
Graduated College
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