5. Excel Excel Excel 17 30 Excel 70.0 14.7 68.0 19.5 Excel Excel A1 =MAX(B2:B31) =MIN(B2:B31) B2:B31 A1 C31 Excel 10
80 90 80 90 90 100 100 Excel COUNTIF FREQUENCY COUNTIF C2 C31 80 =COUNTIF(C2:C31, 80) 80 COUNTIF(C2:C31, =80) Excel COUNTIF(C2:C31, >= &80) =80 80 90 =COUNTIF(C2:C31, >= &80) - COUNTIF(C2:C31, >= &90) E 100 0 10 0 0 10 90 90 100 100 100 100 100 F2 =COUNTIF(C$2:C$31, >= &E2) Excel >= &E2 100 =COUNTIF(C$2:C$31,100) 100 F3 =COUNTIF(C$2:C$31, >= &E3) - COUNTIF(C$2:C$31, >= &E2)
F12 C G G14 G14 F14 G15 G14 =SUMPRODUCT(E2:E12,F2:F12) H H14 30 29 H16 C32,C33 10mm 10mm mm A B C C N P N P! N(P)
0 x x+ x f(x) x f(x) f(x) x f x dx x=x x x f(x) x!"!!"!"!!"!!!" N0!! =!!!!!"!! =!!!!!!"!"!!!!!!!!"!"!! 18 N Excel 1!!!! S 1!! (wi) wi 1!!! 1/2.3 2 =0.435 S 3.64 w1 0.12 PHi*wi 236.3mV (PHi PHave) 2 wi 4.4mV 236.0mV 4.6mV 100 90 5 90 5 wi 90 5/30=1/6 100 1/30
19 " " 60 64.5 60 69 64.5 8 [ - ] 29 29 30
-- COUNTIF FREQUENCY COUNTIF = COUNTIF(, ) =COUNTIF(C2:C31,60) C2 C31 60 50 60 50 60 50 =COUNTIF(C2:C31,>=50) Excel >= 50 >=50 >= 50 >= 50 >= + 50 >= &50 E2 E12 F2 =COUNTIF(C2:C31, >= &E2) 100 F2 F3 F3 =COUNTIF(C3:C32, >= &E3) 6 90 6 F12 F2 =COUNTIF($C$2:$C$31, >= &E2) C $ C $ F12 30 50 50 60 50 60 F3
=COUNTIF($C$2:$C$31, >= &E3) - COUNTIF($C$2:$C$31, >= &E2) F12 F2 F12 Frequency Distribution FREQUENCY Excel Control+U +Z+Return Mac
F2 =FREQUENCY(C2:C31,E2) (1) F =FREQUENCY(C3:C32,E3) 28 C3 C31 C32 90 29 100 28 $ (1) (2) 100 90 H2 (2) E2 E2:E12 H3 =FREQUENCY(C$2:C$31,E3:E13) E13 (3) (3) 100 3 90 G2 H3 80 90 FREQUENCY 80 90 10 80 90 70 80 H2 =FREQUENCY(C$2:C$31,E2:E3) FREQUENCY 70 80 69.9 79.9 70 80 FREQUENCY COUNTIF
Excel Excel Excel de Asobo