1 1 Excel3 2008.8.19 2 3 10 1 () 4 40596079
2 OK 1 5 341 1 1 6 3-1 A134A135 B135 COUNTIF OK 3-1 7 3 B6B132 1 B135 COUNTIF) OK B6B132 8 2
3-1 3 3-1 3 1 2A133 A134 A135 3B133 SUBTOTAL 9 2 B5B131 OK 4SUBTOTAL 1average () 2:count () 3counta ( 4max () 5min () 6product () 7stdev () 8stdevp( 9sum ( 10var() 11varp() 10 3-1 3 3-1 51 11 1 6 7 B134 40 12 3
3-1 3-2 8 2 2 B13587 SUBTOTAL 1 =datedif(,, YMD 2E6 E7E132 13 14 3-2 1 2 15 3-2 E6E45 OK 1 16 4
3-3 10 10 F5 INT TRUNC 17 3-3 10 10 1FLOOR / FLOOROK 2FLOOR 10 3F6 F7F132 18 3-3 10 1 10 F136 F137F146 4080 3-3 10 4 $F$6$F$132 $E$137$E$141 $F$136 OK 2 19 20 5
3-3 10 3-4 1 BMI 1BMII6 H6/G6/1002 H6/G6G610000 kg/(m) 5 ROUND ROUND 1 1 ROUND ROUNDH6/G6/1002 1BMI1 21 22 3-5 BMI 3-5 BMI 3I6I7I132 4I1 BMI 23 IF(,,) TRUE () FALSE () IF(,,IF(,,IF(,,))) IFIF7 BMI18.518.525225 018.518.5 252253() IF(I6>0,IF(I6<18.5,1,IF(I6<25,2,3)),) 24 6
3-5 BMI IF(I6>0,IF(I6<18.5,1,IF(I6<25,2,3)),) 3-6 No.111151cm57kgBMI24.998903 24.99890325.0 No.111BMI25.0 25 26 3-6 5050 3-6 4 OR3 OK BMI 50 27 BMI1350 28 7
3-7 13-6 3-7 2IDBMI sheet1a25 29 30 3-7 2SUBTOTAL =SUBTOTAL(1,D26:D33) 3-7 3 BMI 1 SUBTOTAL =SUBTOTAL(7,D26:D33) 31 4 5)BMI 32 8
3-7 SUBTOTAL 2BMI 3 =AVERAGE(D26:D29) 3-7 50 Y/mmHg 4 =STDEV(D26:D29) 1 5 33 34 3-7 50 3-7 50 2 35 OK 36 9
3-7 50 3 4 37 38 3-8 = 0 0.05 39 40 10
3-8 3-8 2 4 5 3A5Z132 3A5Y132 41 42 3-8 ID 3-8 /ID OK 8/ ID 43 44 11
3-7 3-8 10 9 OK 45 46 3-8 3-9 1 2405060 70 20OK 47 48 12
13 49 3-9 3405960792 BMI 2 4 1 2 1 50 3-9 40596079 4 51 3-9 ( 95 2 a/b c/d OR)ad/bc 95+ OR exp1.96 SQRT1/a+1/b+1/c+1/d 951 52 3-9 (2 20.05 2 2 CHITEST(,
14 53 3-10 A5Z132 OK 3 54 3-10 4 5 6 55 3-10 8 7 56 3-10 10 9
15 57 3-10 12 58 3-10 59 3-10 60 3-10 TG) TG
3-10 TG) 3-11 61 62 3-11 OK 3-11 63 64 16
3-11 3-11 Y XHDL Y XHDL 65 66 3-11 HDL 3-11 XY 67 68 17
3-11 3-11 2 69 R-2 70 BMI 130mmHg150mg/dl 100mg/dl 71 3-11 R-2 XY 0.3 0.3 0.7 0.7 HDL 72 18