assignment 2

profilecrisalza09
2.lecture2.examples.xlsx
Home>Social Science homework help>assignment 2

median1

An example with an odd number of observations:
game hours rank order
5 1 Min
6 2 Mean 12.48
6 3 Median 9
7 4 Mode 9
7 5 Range 38
7 6 IQR 3
8 7 Q1 Semi-IQR 1.5
8 8
8 9
9 10
9 11
9 12
9 13 Median
10 14
10 15
10 16
11 17
11 18
11 19 Q3
12 20
12 21
13 22
33 23
38 24
43 25 Max

median2

An example with an even number of observations:
flfp rank order
2 1 Min Mode 38
3 2 Median 38.5
31 3 Mean 38.375
31 4 Range=55-2=53
34 5 IQR = 44-37.5=6.5
34 6 SIQR=6.5/2=3.25
37 7
37 8 Q1 = (37+38)/2 = 37.5
38 9
38 10
38 11
38 12
38 13
38 14
38 15
38 16 Median = (38+39)/2 = 38.5
39 17
39 18
39 19
40 20
41 21
42 22
44 23
44 24 Q3 = (44+44)/2 = 44
44 25
44 26
45 27
49 28
49 29
50 30
51 31
55 32 Max

SD calculation

If Population If sample Coffee Deviation Squared Deviation
Mean 5 5 0 0-5= -5 (-5)^2= 25
Deviations Col G Col G 2 2-5= -3 (-3)^2= 9
Sq. Deviations Col I Col I 3 3-5= -2 (-2)^2= 4
Sum of Squares 90 90 3 3-5= -2 (-2)^2= 4
Variance 4.50 4.74 3 3-5= -2 (-2)^2= 4
St. Deviation 2.12 2.18 4 4-5= -1 (-1)^2= 1
4 4-5= -1 (-1)^2= 1
4 4-5= -1 (-1)^2= 1
4 4-5= -1 (-1)^2= 1
5 5-5= 0 0^2= 0
5 5-5= 0 0^2= 0
6 6-5= 1 1^2= 1
6 6-5= 1 1^2= 1
7 7-5= 2 2^2= 4
7 7-5= 2 2^2= 4
7 7-5= 2 2^2= 4
7 7-5= 2 2^2= 4
7 7-5= 2 2^2= 4
8 8-5= 3 3^2= 9
8 8-5= 3 3^2= 9