1
1 1 1 2 3 4 5 5 7 11 11 14 22 23 26 28 30 37 44 48 48 48 48 49 51 51 52 52 52 58 59 2
2 100 sample population (2) qualitative data quantitative data A 50 B 60 B A 10 1.2 ratio scale 3
15 18 3 1.2 0 interval scale 273 50 90 40 90 50 1.8 0 A B nominal scalea B O AB category 1.2. 3.4. ordinal scale 1-1 1-1 170 160 170 160 1-1 (3) 4
(4) 5p<0.05 1p<0.010.1p<0.001 1 02 5%(p<0.05)1%(p<0.01)0.%(p<0.001) 5
(5) 6
Excel Excel 2000 for Windows 7
7 7 8
Excel 9
9 10 OK 10
11
12
OK (3) 2 13
Excel 13 A2:A11 C2:C8 14
E2 OK 14 12 15
2-1 2 = 2-1 / 30 70 100 60 40 100 90 110 200 Excel 15 3 16
16 1/3 Excel 17
1/3 18
2/3 3/318 19
20
12 3 21
19 19 21 21 Excel 22
2 2 2 Excel 2 CHITEST CHITEST CHITESTU 2 2 1 2CHITEST 2 p 2 2 Excel SPSSStatistical Product for Social Science 22 1 2 23
B5:C5 B8:C8 100 50 B11 2 2 4 =(B5-B8)^2/B8+(C5-C8)^2/C8 4 2 B12 2 =CHITEST(B5:C5,B8:C8)0.0455 4.555 (4) 24
25
C1:C16E1 OK 26
mean 27
modemedian rangevariance(standard deviationsd) SD SD SD 0 1 SD15+50 50 15 2-2 () class10 10 histogram) Excel 2-2 cm CM) 155160 161165 166170 171175 176180 15 35 14 8 3 28
60697079 10 E2:E5 28 29
t 2 F 30
1 B2:B11 2 C2:C11 OK 30 31
F PF<=f f F P 0.05 2 P 0.05 2 Excel F F F 99 5% F P 0.05 t t 32
t Excel t Excel 3 t 2 2 3 t 2 F 2 33
1 B2:B11 2 C2:C11 0 F1 OK31 31 tt P 0.05 two-tailed test 1 p=0.013218 5%df 2 1 m1>m2 m1<m2m 2 one-tailed testm1m2 2 degree of freedom 34
2 F 2 34 34 35 35
35 t=2.496517df=18p=0.02247 5 36
F 2 36 36 37 37
2 t 0 38
t t=2.490517df=16p=0.0023841 5% t t t a bb cc a 110.05 3 =0.142625 14% 10 0.40 40% 39
2 3 Excel 3 1 Excel SPSS 1 1 1 3 40
A1:C11 OK 40 F P F=20.04510139df=2,19p=2.08E05 2.08E05 2.0810 52.081/100000.0000208 0.1 41
41 1 1 5 5 42 42
42 F M A B F M P0.204806 A B P=0.000194 0.1 P=0.000194 42 AB 43
44
2 A B 0.05 OK44 45
A B PA 0.037576 5B 0.004594 1 Excel 46
110 + 2-3 Excel Excel 2-3 0.000.20 0.200.40 0.400.70 0.701.00 47
B1:C16 47 0.922742 23 Excel SPSS 48
49
1996 Excel 49 1/4 50
50 50 1 X Y 1 Y 2 3 Y 51
Y 52
4 5 4/4 Word 53
51 Word Excel Word 1 2 3 4 5Y Word 1 53 54 OK 54 OK 55 56 56 57 57 8 Word 58 58 54
Word 55
56
57
58
59
1996ExcelSASSPSS 60
1967 1997Excel 1990 1998 1996 61