DescriptionRES/710 v5
Course Project Worksheet – Mean, Median,
and Mode
Complete Parts A and B below.
Part A
Using the three variables you chose in Week 1, complete the following for each of your variables:
1. Using Excel, calculate the mean, median, and mode for each variable.
2. Create APA formatted tables to represent the mean, median, and mode of each variable. Copy
and paste each table below.
3. Explain/summarize the output for each variable.
Note: You might have to recode your variables prior to completing this assignment. See Calculating
Mean, Median, and Mode in Excel for the step-by-step process.
Independent Variable 1
Independent Variable 1 Name: [Enter independent variable 1 here.]
Descriptive Statistics Table:
[Paste your table here.]
Summary and Description:
[Enter your summary and description here.]
Independent Variable 2
Independent Variable 2 Name: [Enter independent variable 2 here.]
Descriptive Statistics Table:
[Paste your table here.]
Summary and Description:
[Enter your summary and description here.]
Dependent Variable
Dependent Variable Name: [Enter dependent variable here.]
Descriptive Statistics Table:
[Paste your table here.]
Summary and Description:
[Enter your summary and description here.]
Copyright 2021 by University of Phoenix. All rights reserved.
Course Project – Mean, Median, and Mode
RES/710 v5
Page 2 of 2
Part B
Respond to the following questions.
1. What are some considerations for choosing a measure of central tendency?
[Enter your response here.]
2. What impact do variable types have on testing when considering central tendency?
[Enter your responses here.]
3. Which measure of central tendency was most appropriate for each of your variables? Why?
[Enter your response here.]
References
[List references according to APA guidelines.]
Copyright 2021 by University of Phoenix. All rights reserved.
RES/710 v5
Course Project Worksheet – Variables and Levels of
Measurement
Complete the following tables.
General Research Information
Student Name: [Nyya McCants]
Topic: [Effect of various age and ethnicity on the unemployment status]
Revised Research Question: (Use the discussion posts and feedback from your instructor, classmates, or other considerations.)
[What is the impact of age and ethnicity on the unemployment status from 2014 to 2022?]
Hypothesis: (Use the discussion posts and feedback from your instructor, classmates, or other considerations.)
[Age and ethnicity have significant impact to the unemployment status from 2014 to 2022]
Null Hypothesis: (Use the discussion posts and feedback from your instructor, classmates, or other considerations.)
[Age and ethnicity does not have significant impact to the unemployment status from 2014 to 2022]
Independent Variables
Independent Variables
(IVs)
[Age]
Justification for IV
[An Independent variable is a variable that
does not depend on others and could stand
on its own (Spiegelhalter, 2019). In this case
study, age could influence the unemployment
status of a person]
Level of
Measurement
Justification for Level of Measurement
[Ratio Level]
[This variable is ratio because it can be
categorized, ranked, and inferred equal
intervals between neighbouring data points,
and there is a true zero point]
Copyright 2021 by University of Phoenix. All rights reserved.
Course Project Worksheet: Variables and Levels of Measurement
RES/710 v5
Page 2 of 2
Independent Variables
(IVs)
[Ethnicity]
Justification for IV
[Ethnicity variable can also stand on its own,
therefore, it is an independent variable. It is
not affected by other variables but it has an
impact on the dependent variable]
Level of
Measurement
Justification for Level of Measurement
[Nominal Level]
[This variable has a nominal level because it
can be categorized and labelled mutually
exclusive groups, but there is no order
between the categories]
Level of
Measurement
Justification for Level of Measurement
[Nominal Level]
[This variable has a nominal level because it
can be categorized and labelled mutually
exclusive groups, but there is no order
between the categories]
The data used in this worksheet is from GSS Data Explorer.
Dependent Variable
Dependent Variable
(DV)
[Unemployment Status]
Justification for DV
[The dependent variable is the variable where
its value is determined and depends on the
independent variable (Spiegelhalter, 2019). In
this case, the unemployment status depends
on the person’s age and ethnicity]
References
[Spiegelhalter, D. (2019, September 1). The Art of Statistics: How to Learn from Data.
Anderson, D. R., Sweeney, D. J., & Williams, T. A. (2001, June 1). Statistics for Business and Economics. https://doi.org/10.1604/9780324066715]
Copyright 2021 by University of Phoenix. All rights reserved.
RES/710 v5
Course Project Worksheet – Frequency Tables
and Histograms
Complete Parts 1 and 2 below.
Part 1: Frequency Tables
Using your dataset chosen in Week 1, use Excel to complete frequency data runs for each of your
variables. Then, describe each frequency table directly referencing the data in the table.
Paste your frequency tables in the appropriate sections below. Be sure to follow proper APA guidelines
for each table and describe the results. Each frequency table should be described in about a paragraph
and should directly reference the table.
Frequency Table for Independent Variable 1
Independent Variable 1 Name: [Age]
Frequency Table:
Table 1
Frequency Table of Age as Independent Variable
Age
Frequency
18
28
19
60
20
69
21
74
22
85
23
84
24
81
25
121
26
105
27
102
28
92
29
110
30
117
31
118
32
122
33
123
34
129
35
108
36
109
37
113
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 2 of 7
Table 2
Frequency Table of Age as Independent Variable (Continuation)
Age
Frequency
38
124
39
120
40
114
Total
2308
Summary and Description:
Table 1 and Table 2 explained the frequency distribution of the respondent age, where the age itself
ranges from 18-40 years old. Based on the frequency distribution could be known that the highest
frequency is at 34 years old with a count of 129 individuals, The age group 25-33 years old relatively have
high frequencies from 102 to 129 individuals, and there is a growth from 18-24 years old that start from 28
and peaking at 85 individuals, and beyond 34 years old the frequencies gradually decrease until age of
40 years old with the count of 114 individuals.
Frequency Table for Independent Variable 2
Independent Variable 2 Name: [Ethnicity]
Frequency Table:
Table 3
Frequency Table of Ethnicity as Independent Variable
Ethnicity
Frequency
Africa
188
American indian
138
American only
45
Arabic
10
Argentina
1
Austria
4
Bangladesh
1
Belize
1
Bolivia
1
Brazil
2
Canada (french)
16
Canada (other)
11
China
25
Colombia
5
Congo
1
Costa Rica
1
Cuba
21
Czechoslovakia
23
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 3 of 7
Table 4
Frequency Table of Ethnicity as Independent Variable (Continuation)
Ethnicity
Frequency
Denmark
11
Ecuador
1
Egypt
5
El Salvador
6
England and wales
137
Ethiopia
2
Finland
9
France
29
Germany
260
Greece
15
Guatemala
11
Haiti
2
Honduras
4
Hungary
4
India
35
Indonesia
1
Iraq
1
Ireland
203
Italy
133
Jamaica
2
Japan
8
Kenya
3
Lithuania
7
Mexico
271
Netherlands (dutch/holland)
26
Nigeria
14
Norway
31
Other
10
Other Africa
40
Other asian
27
Other Caribbean
5
Other Central America
3
Other european
37
Other Middle East
1
Other North America
29
Other South America
1
Other spanish
79
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 4 of 7
Table 5
Frequency Table of Ethnicity as Independent Variable (Continuation)
Ethnicity
Frequency
Pakistan
4
Panama
1
Dominican Republic
3
Papua New Guinea
5
Peru
2
Philippines
28
Poland
53
Portugal
7
Puerto rico
37
Romania
3
Russia (ussr)
19
S. Korea
1
Samoa
1
Scotland
58
South Africa
15
Spain
39
Sweden
28
Switzerland
3
Syria
1
Thailand
2
Uganda
1
Venezuela
3
Vietnam
5
West indies (non-spanish)
24
West indies (not specified)
2
Yugoslavia
6
Total
2308
Summary and Description:
Table 3-5 shows the frequency distribution that happens on the ethnicity variable. Can be seen that the
most ethnic group represented are Germany with 260 count and Mexico with 271 count. Ireland and
Africa are also well represented where they have frequencies of 203 and 188 respectively. Besides that,
there is a diverse ethnicity which has smaller frequencies like Argentina, Canada, Congo, etc. and some
categories that encompass broad regions such as Other Central America, Other Caribbean, and Other
Africa.
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 5 of 7
Frequency Table for Dependent Variable
Dependent Variable Name: [Unemployment Status]
Frequency Table:
Table 6
Frequency Table of Unemployment Status as Dependent Variable
Unemployment Status
NO
YES
Total
Frequency
1162
1146
2308
Summary and Description:
Table 6 explaining about the unemployment status distribution where NO represents the individual that
has a job and YES represents the unemployed individual. Could be found that both of the category
relatively balance where NO has an 1162 count and YES have an 1146 count. But, overall there is more
individual that has a job which can be known by the greater number of NO unemployment status.
Part 2: Histograms and Graphs
Using the same data you selected in Week 1, develop a histogram and assess the distribution of each
variable. Consider why the distribution of the data is important.
Paste your histograms in the appropriate sections below. Be sure to follow proper APA guidelines for
each histogram and describe the results. Each histogram should be described in about a paragraph and
should directly reference the histogram.
Histogram for Independent Variable 1
Independent Variable 1 Name: [Age]
Histogram:
Figure 1
Histogram of Age
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 6 of 7
Summary and Description:
Figure 1 is the histogram of the age variable which describes the distribution that happens between the
class of the age. Can be found that overall the frequency of the age class is balanced. The age class of
30-35 years old is the one that has the highest frequency followed by the 24-29 years old age class. That
corresponds to the data from Table 1 that states if the high-frequency data is distributed over 25-33 years
old. It is also shown that the data is skewed right. Skewed right means that the median value is greater
than the average value of the data and most of the data falls on the left side of the histogram
(Spiegelhalter, 2019). In this case, most of the data is on the age class of 24-29 and 30-35 years old
which is also categorized as productive ages to have a work.
Histogram for Independent Variable 2
Independent Variable 2 Name: [Ethnicity]
Histogram:
Figure 2
Histogram of Ethnicity
Summary and Description:
Figure 2 explained the distribution of ethnicity in the form of a histogram. It is shown that Mexico and
Germany is the country with the highest frequency count. This corresponding Table 3-5 also explained
that Mexico and Germany count frequency is higher than the ethnicity of the other. This histogram is also
right-skewed since most of the data fall on the left side of the histogram.
Histogram for Dependent Variable
Dependent Variable Name: [Unemployment Status]
Histogram:
Copyright 2021 by University of Phoenix. All rights reserved.
Corse Project Worksheet – Frequency Tables and Histograms
RES/710 v5
Page 7 of 7
Figure 3
Histogram of Unemployment Status
Summary and Description:
Figure 3 is defining the distribution of unemployment status in the form of a histogram. Could be found
that there is a higher number of individuals that have job than individuals that is unemployed. This is
shown by the greater number of NO unemployment status frequency than YES unemployment status
frequency. But, by analyzing the histogram both unemployment status frequency is balanced.
References
[Spiegelhalter, D. (2019, September 1). The Art of Statistics: How to Learn from Data.
Anderson, D. R., Sweeney, D. J., & Williams, T. A. (2001, June 1). Statistics for Business and Economics.
https://doi.org/10.1604/9780324066715]
Copyright 2021 by University of Phoenix. All rights reserved.

Purchase answer to see full
attachment

  
error: Content is protected !!