2. Excel. 2002.9 http://statdtedm.6to23.com yuchua@163.com Excel 19 Excel Excel 97Excel 2000Excel 2002 14 27 20 Excel 2.1 2-1 1
Excel X XY X Y Y Z 2.2 Excel 1 Excel 7 2-2 2-2 7 0 2 2-3 7 2
X Y 7 2-3 3 X 6 4 100 x % 1 x % + x % + L+ x %) = 100 ( 1 2 n 6 2-4 i 2-4 6 2-5 5 3
5XY XY XY XY 5 2-5 XY 6 3 2-6 2-6 3 7 2-7 2-7 4 8 XY XY 2 Y X Y 9 4 - - - - - 4
- 2-8 - - - K 2-8 10 Excel 20 2.3 Excel 2-1 2000 2-1 2-1 2000 (%) 99.72 99.20 99.24 99.12 93.50 98.20 98.70 98.20 99.50 93.90 98.70 98.20 2-9 2000 Excel 5
A5:E7 6
2-14 7
2-15 2.4 2-16 2-16 8
2-17 2 2-17 Y X B4:E4 3 2-18 9
2-14 X 2-18 2-19 4 2-14 0 0 Y 010020100 2-19 2-18 5 2-20 10
2-20 2-21 2-21 2-22 11
40 2-22 6 8 2-23 2-23 7 8 2-16 2-21 4 2-22 2-24 2-24 8 12
2-24 2-25 2-25 2.5 2.5.1 bar chart 0 2-1 2-2 50.28 41.23 30.10 12.65 5.87 2.01 13
2-26 C2:D5 X A3:A5 2-26 2.5.2 2-27 error-bar 2-3 2-27 14
A3:B7 2 90 + C4:C7 2-27 2-28 2-28 2.5.3 percentage chart 100 x % i 15
1 x % + x % + L+ x %) = 100 ( 1 2 n 2-4 52.3 27.8 19.9 30.2 18.1 51.7 2-29 B3:D5 X A4:A5 2-29 2.5.4 (pie chart) 2.4 2-4 B3:D4 16
1 2-30 2-30 2-31 2.5.5 line chart semi-logarithmic linear chart 2-32 19912001 / 17
2-5 19912001 2-32 A2:C13 XY 2-30 2-33 2-32 1933 2-32 2-33 18
2.5.6 radar graph 2-6 6 2-34 2-34 A1:D7 6 6 6 3 50 50 3 2-34 1 6 2 3 2 3 1 2 3 19
2.5.7 2-7 015 18 2-35 3 2-35 X A2:A19 Y B2:B19 C2:C19 20
2-35 015 2-8 9 5 2 2 2-36 2-36 2-36 B2 X C2:C6 Y D2:D6 E2:E6 B7 X C7:C8 Y D7:D8 E7:E8 B9 X C9:C10 Y D9:D10 E9:E10 5 4 2 1 21
2-36 2 2.5.8 boxplot box-whisker plot P50 P 75 P 25 P99.5 P 0. 5 P 99 P 1 P 97. 5 P 2. 5 2-9 10mg 20mg 100 forced expiratory volume, FEV P100 P 75 P 50 P 25 P 0 75 25 2-37 2-37 - - - P25 P 100 P 0 P 50 P 75 P25 P 75 A1:D5 - - - 22
A6 B6:D6 + 6 6 6 2-37 19 23