1....................... 1 2............................... 2 2.1 -countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3 []............ 8 4................................. 8 4.1 (8 ) 4.2 (11 ) 4.3 (12 ) 4.4 (13 ) 4.5 (14 ) 5........................ 14 5.1 (14 ) 5.2 (15 ) 5.3 (16 ) 6.................................... 17 6.1 F (17 ) 6.2 t (17 ) 6.3 z (20 ) 7................................ 21 7.1 : (21 ) 7.2 : (21 ) 8........................ 23 8.1 (23 ) 8.2 (24 ) 8.3 (24 ) 1 (Microsoft) (excel) (Sun Microsystems) = (open-office calc) 1 2 3 3 1 3 1 2 3 1/25
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/25
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/25
9 10 11 ( ) 12 10. 13 14 4/25
11. 0 (S) 16 15 12. 13. H3:H10 14. 2 OK 15. OK 16. 17 18 5/25
19 20 21 22 23 k = 1 + log 2 n n 100 k 5.6 k = 6 6/25
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/25
Ctrl, Shift active, nonactive shift+ ctrl+ arrow key 1 25 24 3 [] [] Excel Microsoft Excel [] [] 4 4.1 8/25
2 2 [] : : [ ] [ ] / [] [] : 95% 5% K : k k k 1 K : k k k 1 : 1 2 [] 2 : A1 9/25
/ = (,,, ) 1 1 2 (true) false 3 10/25
: [] () 4.2 20 () [] : (optional): 2 3 2.9999 3 3.9999 4 1 2 2 2 2 2 2 4 11/25
: : : A1 : : : : 4.3 N CORREL PEARSON 2 N 3 CORREL ( PEARSON) 2 2 2-1 +1 2 ( ) ( ) (0 ) [] : : [ ] [ ] / [] [] 12/25
: 2 1 : A1 : 4.4 N -1 +1 2 COVAR N=2 2 COVAR i i i VARP 2 () () (0 ) [] [ ] [ ] / [] [] 2 A1 13/25
4.5 RANK PERCENTRANK RANK RANK RANK [ ] [ ] [ ] / [ ] [] [ ] [] 1 1 4 A1 5 5.1 1 2 [ ] [ ] [ ] 1 [] []( ) 0 1 [] 0 1 [] 2 (p ) 14/25
0 1 0 1 1 0 [] 2 (p ) [ ]1/ [ ] ( ) []( ) 2 1 [] [ ] [] [] A1 [] (seed) : : A1 5.2 4 [] : 15/25
1 2 : : [ ] [ ] : 1 : : 1 [ ] [ ] : A1 : 5.3 (mid rank) [ ] [ ] [] [ ] [ ] [] [] [ ] [] [ ] [ ] [] 1 1 4 [] A1 [] 16/25
6 6.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 6.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 17/25
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 (6.1) 18/25
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 (6.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 () (6.3) 19/25
0 1 I A1 6.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 20/25
A1 7 (Analysis Variance) 7.1 : 2 TTEST 3 TTEST [ : ] : : [ ] [ ] / [] [] α: F α I A1 7.2 : 2 A B C 6 21/25
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 22/25
A1 8 8.1 R-2 1 LINEST [R ] Y : 1 X 16 95% 0 y R-2 7 A1 23/25
8.2 F (t+1) = 1 NA t j+1 (8.1) N N A j j F j j [ ] 4 1 3 [ ] 2 #N/A [ ] [] 1 8.3 a 0.2 0.3 20% 30% [ ] 4 1 1 0.3 j=1 24/25
0.2 0.3 20% 30% [ ] 2 #N/A [ ] [] 1 25/25