You may use Microsoft Excel or any other technology to complete the question as
ID: 3041508 • Letter: Y
Question
You may use Microsoft Excel or any other technology to complete the question as long as the explanation is clear and a screen shot is included Please complete the following problems: 1. Consider a sample of survey respondent ages with data values of 53, 55, 70, 58, 64, 57, 53, 69, 57, 68, 18, 24, 31, 53, 38, 101, 65, 72, 78, 84, 26, 12, 1, and 53. a. Compute the mean, median, mode, max, min, and standard deviation of the age. b. Would you consider any of these observations outliers? Why? Justify your response c.lf you were to attempt to cluster this data into meaningful categories, how would you do so? What would your categories be? Why? 2. Why are descriptive statistics important? Are some vulnerable to outliers or manipulation? Which? How? Albert Einstein is quoted as having once said "there are lies, damn lies, and statistics." Based on what you have learned, how can data be played with to tell a story with an agenda? How would you critically assess information to interpret for yourself?Explanation / Answer
Answer:
a).
Excel addon Megastat used.
Descriptive statistics
count
24
mean
52.50
sample standard deviation
23.98
sample variance
575.22
minimum
1
maximum
101
range
100
1st quartile
36.25
median
56.00
3rd quartile
68.25
interquartile range
32.00
mode
53.00
b).
Q1 – 1.5×IQR = 36.25-1.5*32 =-11.75
Q3 + 1.5×IQR =68.25+1.5*32 = 116.25
All observations are between -11.75 and 116.25.
There are no outliers.
c).
Range = 100
If we want to make 7 categories, the categories are
1-15, 16-30, 31-45,46-60, 61-75,76-90, 91-105
lower
upper
width
frequency
percent
1
-
15
15
2
8.3
16
-
30
15
3
12.5
31
-
45
15
2
8.3
46
-
60
15
8
33.3
61
-
75
15
6
25.0
76
-
90
15
2
8.3
91
-
105
15
1
4.2
24
100.0
Descriptive statistics
count
24
mean
52.50
sample standard deviation
23.98
sample variance
575.22
minimum
1
maximum
101
range
100
1st quartile
36.25
median
56.00
3rd quartile
68.25
interquartile range
32.00
mode
53.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.