1....................... 1 2............................... 2 2.1 -countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3....................... 8 4 [].................... 10 5................................ 10 5.1 (10 ) 5.2 (13 ) 5.3 (14 ) 5.4 (15 ) 5.5 (16 ) 6........................ 16 6.1 (16 ) 6.2 (17 ) 6.3 (18 ) 7.................................... 19 7.1 F (19 ) 7.2 t (19 ) 7.3 z (22 ) 8................................ 23 8.1 : (23 ) 8.2 : (23 ) 9........................ 25 9.1 (25 ) 9.2 (26 ) 9.3 (26 ) 1 (Microsoft) (excel) (Sun Microsystems) = (open-office calc) 1 2 3 3 1 3 1 2 3 1/27
1 2 3 2 2.1 -countif Excel 22 http://software.ssri.co.jp/statweb2/ 1. 111 3 2. 4 4 3 3.E4:E10E4:E10 OK 2/27
5 6 4.E4:E10E4:E10 OK 5. 1-19 6. Excel COUNTIF COUNTIF 100 =COUNTIF(,100) 20 =COUNTIF(, >= 20 ) 20 40 =COUNTIF(, >= 20 ) COUNTIF(, >= 40 ) 7 8 7. E3:F10 9 8.10 9. 3/27
9 10 11 ( ) 12 10. 13 14 4/27
11. 0 (S) 16 15 12. 13. H3:H10 14. 2 OK 15. OK 16. 17 18 5/27
19 20 21 22 23 k = 1 + log 2 n n 100 k 5.6 k = 6 6/27
2.2 (tally mark) tally mark A :: 2 B ;;::: 13 C ;:::: 9 D ;;;;:: 22 E ::: 3 F : 1 50 2.3 frequency frequency 1. (max) (min) 2. D13 D17 3. ( E13 E17 4. =frequency 5. FREQUENCY(, ) A2 A10 D13 D17 6. OK CTRL+SHITFT OK / (1) <200 1 0.11 (2) 200-299 2 0.22 (3) 300-399 4 0.44 (4) 400-500 2 0.22 9 1.00 =sum(a2:a9) 2 countif AND 2 7/27
Ctrl, Shift active, nonactive shift+ ctrl+ arrow key 1 25 24 3 EXCEL Excel NORMDIST NORMINV NORMDIST NORMSDIST (S) NORMSINV NORMSDIST CHIDIST CHIINV CHIDIST FDIST FINV FDIST 8/27
t TDIST t (x ±x ) t TINV TDIST (B) BETADIST (B) BETAINV BETADIST EXPONDIST = 1/λ ( ) GAMMADIST ( ) GAMMAINV GAMMADIST BINOMDIST p n x CRITIBINOM p n α? HYPGEOMDIST N M N M 2 n x LOGNORMDIST exp(x) X LOGINV LOGNORMDIST POISSON 1/λ x NEGBINOMDIST p r x WEIBUL (x) (p) [ ] (p) (x)[ ] (x) (p) (p) (x) (x) (±x ) (p) (p) (x) Excel NORMDIST TRUE NORMINV p (x) NORMSDIST NORMSINV p (x) CHIDIST CHIINV p (x) FDIST F 2 FINV F p (x) TDIST t TINV t p (x) 1, 2 9/27
BETADIST α, β BETAINV p (x) EXPONDIST λ TRUE GAMMADIST α, β TRUE α = 1 λ = 1/β β α β GAMMAINV p (x) BINOMDIST x, n, p = TRUE CRITIBINOM n, p, α HYPGEOMDIST N, M, N M n, x LOGNORMDIST X LOGINV X POISSON x, λ = TRUE NEGBINOMDIST r, p, x WEIBUL or α β λ = 1/β = TRUE ) TRUEFALSE 1, 0 = FALSE 4 [] [] Excel Microsoft Excel [] [] 5 5.1 [] : 10/27
2 3 : [ ] [ ] / [] [] : 95% 5% K : k k k 1 K : k k k 1 : 1 2 [] 2 : A1 11/27
/ = (,,, ) 1 1 2 (true) false 4 12/27
: [] () 5.2 20 () [] : (optional): 2 3 2.9999 3 3.9999 4 : 1 2 2 2 2 2 2 5 13/27
: : A1 : : : : 5.3 N CORREL PEARSON 2 N 3 CORREL ( PEARSON) 2 2 2-1 +1 2 ( ) ( ) (0 ) [] : : [ ] [ ] / [] [] 14/27
: 2 1 : A1 : 5.4 N -1 +1 2 COVAR N=2 2 COVAR i i i VARP 2 () () (0 ) [] [ ] [ ] / [] [] 2 A1 15/27
5.5 RANK PERCENTRANK RANK RANK RANK [ ] [ ] [ ] / [ ] [] [ ] [] 1 1 4 A1 6 6.1 1 2 [ ] [ ] [ ] 1 [] []( ) 0 1 [] 0 1 [] 2 (p ) 16/27
0 1 0 1 1 0 [] 2 (p ) [ ]1/ [ ] ( ) []( ) 2 1 [] [ ] [] [] A1 [] (seed) : : A1 6.2 4 [] : 17/27
1 2 : : [ ] [ ] : 1 : : 1 [ ] [ ] : A1 : 6.3 (mid rank) [ ] [ ] [] [ ] [ ] [] [] [ ] [] [ ] [ ] [] 1 1 4 [] A1 [] 18/27
7 7.1 F F : 2 2 F 2 2 F 2 F ( F ) f 1 f < 1 P(F <= f ) f F F α 1 f > 1 P(F <= f ) f F F α 1 [F : 2 ] 1 1 2 2 α 0 1 I α = 0.01, 0.05, 0.10 A1 7.2 t 2 t 2 3 3 3 t t t Stat t t < 0 P(T <= t) t t t >= 0 P(T <= t) t t 19/27
t t t α P(T <= t) t t P P t α t : 1 2 2 t t t 2 ( ) S 2 = n 1S 2 1 + n 2S 2 2 n 1 + n 2 2 [t : ] 1 1 1 1 2 2 2 1 1 1 0 () 0 1 I A1 t : 2 2 t t 2 t 2 t [t : 2 ] 1 1 1 1 2 2 1 1 (7.1) 20/27
0 () 0 1 I A1 t : 2 2 t t 2 t t 2 2 2 t t = x y 0 S 1 2 m + S 2 2 n (7.2) df t df Excel TTEST df TTEST df TTEST t d f = ( S 1 2 m + S 2 2 n )2 (S 1 2/m)2 m 1 + (S 2 2/n)2 n 1 [t : 2 ] 1 1 1 1 2 2 1 1 0 () (7.3) 21/27
0 1 I A1 7.3 z z : 2 2 z 2 ZTEST z P(Z <= z) P(Z >= ABS (z)) z z 0 P(Z <= z) P(Z >= ABS (z) or Z <= ABS (z)) z z 0 2 z 2 0 z 2 [z : 2 ] 1 1 1 1 2 2 1 1 0 () 1 () 1 2 () 2 0 1 I 22/27
A1 8 (Analysis Variance) 8.1 : 2 TTEST 3 TTEST [ : ] : : [ ] [ ] / [] [] α: F α I A1 8.2 : 2 A B C 6 23/27
2 6 1 75 58 68 56 71 61 75 60 66 62 70 60 68 59 68 68 [ ] : 1 : 1 : F I : : A1 : [ ] 2 1 ( 1 ) 1 [ : ] F I 24/27
A1 9 9.1 R-2 1 LINEST [R ] Y : 1 X 16 95% 0 y R-2 7 A1 25/27
9.2 F (t+1) = 1 NA t j+1 (9.1) N N A j j F j j [ ] 4 1 3 [ ] 2 #N/A [ ] [] 1 9.3 a 0.2 0.3 20% 30% [ ] 4 1 1 0.3 j=1 26/27
0.2 0.3 20% 30% [ ] 2 #N/A [ ] [] 1 27/27