2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2

Size: px
Start display at page:

Download "2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2"

Transcription

1 / //descrptvea1-a.tex statstcs statstcum (EBM) 1

2 2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2

3 3.1 2 * 1 0 ( ) () ( ) * 3.2 IQ 3

4 * Staley Smth Steves 1946 O the theory of scales of measuremet 4 Wkpeda, Excel help 4 Frequecy Dstrbuto Wdows (McroSoft) OpeOffce.org 4.1 4

5 (cm) BMI ( ) (m) 2 BMI BMI BMI 1: : (Hstogram) 5

6 2 (tally mark) x skewess L L L L kurtoss, excess ; leptokurtc ; platykurtc Hstogram

7 Q 1, Q 2, Q 3 Q 1, Q (max) (m) rage 2. (class) Starjes k = 1 + log 2 = log (class wdth) R/k 4. 7

8 3 (Boxchart) A B C D E F G 1 ( ) ( ) 2 a 0 a 1 x 1 f 1 F 1 = f 1 p 1 = f 1/ P 1 = p 1 3 a 1 a 2 x 2 f 2 F 2 = f 1 + f 2 p 2 = f 2/ P 2 = p 1 + p 2 4 a 2 a 3 x 3 f 3 F 3 = f 1 + f 2 + f 3 p 3 = f 3/ P 3 = p 1 + p 2 + p a k 1 a k x k f k F k = p k = f k / P k = x = (a 1 + a )/2,( = 1, 2,, k) F k = f 1 + f f k =, P k = p 1 + p p k = 1 =max( ) =m( ) D2 D6 =frequecy, ( A2 A6) CTRL+SHIFT+ENTER E2 =D2 E3 =D2+D3 E3 E4 E6 F2 =D2/D$7 frequecy

9 4 5 5 (average,mea) (SD,stadard devato),meda ( (varace) (kurtoss, excess)(bulge ) (skewess) (rage) (m) (max) (sum) (sze) 1. Excel -VBA 2.OK 3. OK 9

10 {X, = 1,, }, sort (Order Statstcs) {X (), = 1,, } X 1, X 2,, X X (1) X (2) X () X 1 + X X = X (1) + X (2) + + X () X k x 1, x 2,, x k (k ) ( ) x 1 x 2 x k f 1 f 2 f k p 1 p 2 p k 1 2 f = 1, = 1, 2,, X = X 1 + X X = x 1 f 1 + x 2 f x k f k = j x f j, f = f 1 + f f k = X2 = X2 1 + X X 2 = x 2 1 f 1 + x 2 2 f x 2 k f k = j x2 j f j, 1 1 X = 1 (X 1 + X X ) = x 1 p 1 + x 2 p x k p k = j x j p j, X2 = 1 (X2 1 + X X 2 ) = x 2 1 p 1 + x 2 2 p x 2 k p k = j x j p 2 j, X = 1 =1 X = 1 k j=1 x jf j = k j=1 x jp j AVERAGE SE SE = s = (X X) 2 = X2 X2 j = x2 j f j X 2 j = x2 j p j X 2 ( 1) ( 1) ( 1) 1 Me Me = X ((/2)+1) ( ) = X ((+1)/2) ( ) = meda( ) 2 = quartle(, 2) Mo ( ) MODE 2 #N/A (Not Avalable) max f MODE # N/A (Not Avalable) SD SD = s = (X X) 2 STDEV VAR ( 1) 10

11 s 2 s 2 = 1 1 VAR (X X) 2 = ( 1 ) (X X j ) 2 = 1 2 <j =1 VARP ( 1) v 2 = 1 (X X) 2 = 1 =1 k x 2 jf j X 2 = j=1 k x 2 jp j X 2 j=1 k x 2 jp j X 2 KW KURT 1 ( ) 4 X X 3 s 3 SK SKEW 1 ( ) 3 X X s L L L R L R = max( ) m( ) () MAX x 1, x 2,, x max x MIN x 1, x 2,, x m x SUM x 1, x 2,, x x, N COUNTA 95.0% 95% 1/2 95% TM(trmmed mea) TRIMMEAN TRIMMEAN(, ) (1) (2) = MD (Mea Devato) = 1 X X j=1 11

12 Z () Z = X X s x ( ( 100) 10Z + 50 X Q 1, Q 2, Q 3 25% 4 25% Q % 3 75% 3 =QUARTILE(, ) (, QUARTILE ) = (0, ), (1, 1 (25%)) (2, 2 = (50%)) (3, 3 (75%)) (4, ) Q 3 Q 1 (dectle) (percetle) ( 4 CV(Coeffcet of Varato)= s x X ( ) 10% 10% % ± X N(µ, σ 2 ) µ % ±2 σ X (sample covarace): =COVAR( A, B) Cov(x, y) = 1 1 = COV AR(x, y ) (X X)(Y Y ) 1 2 X, Y 0 12

13 1 N COVAR N=2 2 COVAR VARP 2 ( ) ( ) (0 ) (sample correlato coeffcet): =CORREL( A, B) = correl(x, y ) x s x, y s y ρ = Cov(x, y) s x s y ( x = Cov, y ) s x s y X X, Y Y, = 1, 2,, s x s y N CORREL PEARSON 2 N 3 CORREL ( PEARSON) ( ) ( ) (0 ) 13

14 (Speama s rak correlato coeffcet) r s = 1 6 (x y ) 2 ( 2 = 1 1) (x y ) 2 / ( ) 1 3 x, y 1, 2,, =[COUNT( ) RANK(,, 0) - RANK(,, 1)]/2 RANK(,, )

15 7: Corrado G

16 0 1 Wkpeda (G coeffcet) 100 G Idex Japa 24.9 Uted Kgdom 36.0 Swede 25.0 Ira 43.0 Germay 28.3 Uted States 46.6 Frace 32.7 Argeta 52.2 Paksta 33.0 Mexco 54.6 Caada 33.1 South Afrca 57.8 Swtzerlad 33.1 Namba 70.7 ( Bob Sutclffe (2007), Postscrpt to the artcle World equalty ad globalzato (Oxford Revew of Ecoomc Polcy, Sprg 2004), Retreved o G = L(x)dx = 1/2 1 0 L(x)dx 1/2 or = 1 2 L(x )(.e.l(x) ) L(x) y G L (1, 1) y = x L(x)dx (0.8, 0.6) y = L(x) (0.4, 0.2) 0 1 x (0, 0) F (1) = 1, 2,, 16

17 x x 1 x 2 x p = f(x ) p 1 p 2 p F F 1 = p 1 F 2 = p 2 + F 1 F = p + F 1 = 1 L = j=1 x jf(x j ) / L = L = j=1 x jf(x j ) L +1 + L (F +1 F ) 2 ( = 1, 2,, ) L 0 = 0 L 1 L 2 L 1 L = (2) < x < x f(x) F (x) = x f(t)dt L(x) = x / tf(t)dt L (0 x 1) L = tf(t)dt () L(0) = 0 L(x) L(y) L(1) = 1, 0 < x < y < 1 () 0 < L(x) x, 0 < x < 1 x = (x, = 1, 2,, ) F = (/, = 1, 2,, ) s xy G CV(x) R XF G = CV (x) R XF X = {x 1, x 2,, x } x = 1 x ( ) x x j,, j = 1, 2,, ()D D = 1 2 x x j = 2 2 x x j,j,j 2 {(, j);, j = 1, 2,, } <j ( 1)/2 { < j;, j = 1, 2,, } G G = D 2x {x 1, x 2,, x } (order statstcs) <j x (1) x (2) x () ( ) <j x x j = x 1 x 2 + x 1 x x 1 x + x 2 x x 2 x x 1 x = ( ) x (2) x (1) + ( ) x (3) x (1) + + ( ) x () x (1) + ( ) x (3) x (2) + + ( ) x () x (2) ( ) x () x ( 1) 17

18 <j x x j = ( 1)x () + (( 2) 1) x ( 1) + + (1 ( 2)) x (2) + (0 ( 1)) x (1) = x () ( + 1)x () = 2 x () ( + 1)x = 2 ( x () x ) x = x () = x, = ( + 1)/2 x = (x (1), x (2),, x () ) F = (F ) = F = 1 s 2 F = s F F = ( 1 2) (F F j ) 2 <j 2 s XF = = = = (x () x)(f F ) ( 1 1 (x () x) + 1 ) ( ) (x () x) X F ρ ρ = s XF s X s F = 1 1 D = 4 2 ( x () x ), (x () x) D 4 = ( 1, 2,, ) = 1 1 (F F ) 2 = ( ) ( / ) + 1 s X 12 ( ) (x () x) = S xy G = D 2X D = ( 1 ) 4 x () x (j) = ( x () x ) ( 1) 2 <j D 2x = 2 ( ) (x () x) = 2 ( 1)x x s XF = 2 x ρs Xs F = x ρs X 12 = ρcv (X) G G =,j x x j / 2 2x = 1 2 x x x j 0.577ρCV <j 18

19 8 R-2 1 / LINEST X Y (1 Y a X + b Y = a X b Y = a e X Y = a logx R2 OK 9 R R2 2 [ ] Mcrosoft Offce Excel ( : Offce ) Mcrosoft Offce Excel Excel (Mcrosoft Offce ) [Excel ] [ ] [ ] [Excel ] R-2 R Y 2 (X 1, X 2,, X ) b Y a 1 X 1 + a 2 X a X + b A (Y ) B (X 1 ) C (X 2 ) b Y a 1 X 1 + a 2 X 2 + b a 1, a 2, b 19

20 11 10 A B C 1 Y X1 X R 0.98 R R F t P - 95% 95% 95.0% 95.0% X X

21 12 Y = 0.25 X X Y 2 X P P 0.05 X 0 t p Y X (1) P (T t) < (2) t < t t tv t = tv 5%(0.05) 1%(0.01) k 1 k tv 2 5% t P NG 21

22 3 0.7 R2 0.5 R2 R2 R2 R2 AIC

statstcs statstcum (EBM) 2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2

statstcs statstcum (EBM) 2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2 (descrptve statstcs) 2010 9 3 1 1 2 2 3 2 3.1............................................. 3 3.2............................................. 3 4 4 4.1........................................ 5 5 6 6 -pvot

More information

countif Excel E4:E10E4:E10 OK 2/25

countif Excel E4:E10E4:E10 OK 2/25 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 )

More information

Excel97関数編

Excel97関数編 Excel97 SUM Microsoft Excel 97... 1... 1... 1... 2... 3... 3... 4... 5... 6... 6... 7 SUM... 8... 11 Microsoft Excel 97 AVERAGE MIN MAX SUM IF 2 RANK TODAY ROUND COUNT INT VLOOKUP 1/15 Excel A B C A B

More information

(Nov/2009) 2 / = (,,, ) 1 4 3 3 2/8

(Nov/2009) 2 / = (,,, ) 1 4 3 3 2/8 (Nov/2009) 1 sun open-office calc 2 1 2 3 3 1 3 1 2 3 1 2 3 1/8 (Nov/2009) 2 / = (,,, ) 1 4 3 3 2/8 (Nov/2009) 1 (true) false 1 2 2 A1:A10 A 1 2 150 3 200 4 250 5 320 6 330 7 360 8 380 9 420 10 480 (1)

More information

2変量データの共分散・相関係数・回帰分析

2変量データの共分散・相関係数・回帰分析 2, 1, Excel 2, Excel http://hig3.net ( ) L04 2 I(2017) 1 / 24 2 I L04(2017-10-11 Wed) : Time-stamp: 2017-10-10 Tue 23:02 JST hig L03-Q1 L03-Q2 Quiz : 1.6m, 0.0025m 2, 0.05m. L03-Q3 Quiz : Sx 2 = 4, S x

More information

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

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 1....................... 1 2............................... 2 2.1 -countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3....................... 8 4 [].................... 10 5................................ 10 5.1

More information

1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1

1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1 1 21 10 5 1 E-mail: qliu@res.otaru-uc.ac.jp 1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1 B 1.1.3 boy W ID 1 2 3 DI DII DIII OL OL 1.1.4 2 1.1.5 1.1.6 1.1.7 1.1.8 1.2 1.2.1 1. 2. 3 1.2.2

More information

populatio sample II, B II? [1] I. [2] 1 [3] David J. Had [4] 2 [5] 3 2

populatio sample II, B II?  [1] I. [2] 1 [3] David J. Had [4] 2 [5] 3 2 (2015 ) 1 NHK 2012 5 28 2013 7 3 2014 9 17 2015 4 8!? New York Times 2009 8 5 For Today s Graduate, Just Oe Word: Statistics Google Hal Varia I keep sayig that the sexy job i the ext 10 years will be statisticias.

More information

151021slide.dvi

151021slide.dvi : Mac I 1 ( 5 Windows (Mac Excel : Excel 2007 9 10 1 4 http://asakura.co.jp/ books/isbn/978-4-254-12172-8/ (1 1 9 1/29 (,,... (,,,... (,,, (3 3/29 (, (F7, Ctrl + i, (Shift +, Shift + Ctrl (, a i (, Enter,

More information

untitled

untitled 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

More information

15 2004.03 194

15 2004.03 194 The Statistical Processing using EXCEL MIYOSHI Yoshihiko In this paper, I summarize the method of performing statistical processing using only the basic function of EXCEL without the VBA macro, add-in

More information

I L01( Wed) : Time-stamp: Wed 07:38 JST hig e, ( ) L01 I(2017) 1 / 19

I L01( Wed) : Time-stamp: Wed 07:38 JST hig e,   ( ) L01 I(2017) 1 / 19 I L01(2017-09-20 Wed) : Time-stamp: 2017-09-20 Wed 07:38 JST hig e, http://hig3.net ( ) L01 I(2017) 1 / 19 ? 1? 2? ( ) L01 I(2017) 2 / 19 ?,,.,., 1..,. 1,2,.,.,. ( ) L01 I(2017) 3 / 19 ? I. M (3 ) II,

More information

() Statistik19 Statistik () 19 ( ) (18 ) ()

() Statistik19 Statistik () 19 ( ) (18 ) () 010 4 5 1 8.1.............................................. 8............................................. 11.3............................................. 11.4............................................

More information

(I) (II) 2 (I) 2 (II) 2 (III) (I) (II) (II) : 2 Typeset by Akio Namba usig Powerdot. 2 / 47

(I) (II) 2 (I) 2 (II) 2 (III) (I) (II) (II) : 2 Typeset by Akio Namba usig Powerdot. 2 / 47 4 Typeset by Akio Namba usig Powerdot. / 47 (I) (II) 2 (I) 2 (II) 2 (III) (I) (II) (II) : 2 Typeset by Akio Namba usig Powerdot. 2 / 47 (I) (II) 2 (I) 2 (II) 2 (III) (I) (II) (II) : 2 (radom variable):

More information

Microsoft Word - 1.データの整理.doc

Microsoft Word - 1.データの整理.doc 1.データの 分 類... 1 1.1 連 続 値 離 散 値 データ... 1 1.2 データの 尺 度 水 準... 1 2.データの 図 示 要 約... 2 2.1 ヒストグラム(hstogram)... 2 2.2 箱 ヒゲ 図 (box ad whsker plot)... 4 2.3 散 布 図 (scatter plot)... 5 3.データの 数 値 要 約... 6 3.1 分

More information

ユニセフ表紙_CS6_三.indd

ユニセフ表紙_CS6_三.indd 16 179 97 101 94 121 70 36 30,552 1,042 100 700 61 32 110 41 15 16 13 35 13 7 3,173 41 1 4,700 77 97 81 47 25 26 24 40 22 14 39,208 952 25 5,290 71 73 x 99 185 9 3 3 3 8 2 1 79 0 d 1 226 167 175 159 133

More information

P15 P211 1 P1 P4 P2 P3 P4 P17

P15 P211 1 P1 P4 P2 P3 P4 P17 P15 P211 1 P1 P4 P2 P3 P4 P17 P3 P4 P7 P8 P9 2 1 Q A P17 P17 1 2 3 4 3 5 6 7 8 2 P17 Q A P17 4 1 2 3 4 2 P17 P4 P12 P17 P4 5 5 6 7 8 2 P4 P4 6 1 2 3 4 3 P17 P10 P17 7 5 6 7 8 4 0120-096-991 P17 8 1 2 3

More information

6.1 (P (P (P (P (P (P (, P (, P.

6.1 (P (P (P (P (P (P (, P (, P. (011 30 7 0 ( ( 3 ( 010 1 (P.3 1 1.1 (P.4.................. 1 1. (P.4............... 1 (P.15.1 (P.16................. (P.0............3 (P.18 3.4 (P.3............... 4 3 (P.9 4 3.1 (P.30........... 4 3.

More information

2 2.1 Excel 2013 Excel

2 2.1 Excel 2013 Excel 4 1 4 : (1) (2) 1 (spread sheet) APPLE II 1 Microsoft Excel 2 2.1 Excel 2013 Excel 2013 4 2 1 4 3 2.2 1 A,B,C,... 1,2,3... F8 F8 G3 A1 F17 A,B,... 1,2,... 2.2.1 End 1 2.2.2 Excel + 2.2.3 (1) (2) Enter

More information

6 BV17057 30 2 7 1 1 1.1.................................................... 1 1.2.................................................. 1 1.3 6............................... 1 1.4....................................................

More information

Microsoft PowerPoint - Lecture 10.ppt [互換モード]

Microsoft PowerPoint - Lecture 10.ppt [互換モード] 講義予定 環境プラニング演習 II 第 0 回 009. 6. 7 千葉大学工学部都市環境システム学科 山崎文雄 http://ares.tu.cha-u.jp/ tu ujp/ ( 009 年 4 月 8 日 ( 土 :50 ー 4:0 演習の説明, 微分 積分と数値計算 ( 009 年 4 月 5 日 ( 土 :50 ー 4:0 微分 積分と数値計算 (3 009 年 5 月 9 日 ( 土 :50

More information

y = x x R = 0. 9, R = σ $ = y x w = x y x x w = x y α ε = + β + x x x y α ε = + β + γ x + x x x x' = / x y' = y/ x y' =

y = x x R = 0. 9, R = σ $ = y x w = x y x x w = x y α ε = + β + x x x y α ε = + β + γ x + x x x x' = / x y' = y/ x y' = y x = α + β + ε =,, ε V( ε) = E( ε ) = σ α $ $ β w ( 0) σ = w σ σ y α x ε = + β + w w w w ε / w ( w y x α β ) = α$ $ W = yw βwxw $β = W ( W) ( W)( W) w x x w x x y y = = x W y W x y x y xw = y W = w w

More information

2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26 $ $E26 E$26 E$26 $G34 $ E26 F4

2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26 $ $E26 E$26 E$26 $G34 $ E26 F4 1234567 0.1234567 = 2 3 =2+3 =2-3 =2*3 =2/3 =2^3 1:^, 2:*/, 3:+- () =2+3*4 =(2+3)*4 =3*2^2 =(3*2)^2 =(3+6)^0.5 A12 =A12+B12 ( ) ( )0.4 ( 100)0.9 % 1 2 Excel =sum( ) =average( ) B15:D20 : $E$26 E26 $ =A26*$E$26

More information

統計学のポイント整理

統計学のポイント整理 .. September 17, 2012 1 / 55 n! = n (n 1) (n 2) 1 0! = 1 10! = 10 9 8 1 = 3628800 n k np k np k = n! (n k)! (1) 5 3 5 P 3 = 5! = 5 4 3 = 60 (5 3)! n k n C k nc k = npk k! = n! k!(n k)! (2) 5 3 5C 3 = 5!

More information

untitled

untitled 11 10 267 6 129 48.3 6 63 2 1 2JIS ME JIS T 1005JIS 1994 1 11 A 10 1999 5 3 13 ME 4 2 11 B B 1999 4 10 267 6 B 7 9 6 10 12 3 11 Excel MODE Excel STANDARDIZE STANDARDIZE(X,)X AVERAGE STDEVP Excel VAR 0.5

More information

ii : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 27 (1) Excel : : : : : : : : : : : : : : : : : : : : : :

ii : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 27 (1) Excel : : : : : : : : : : : : : : : : : : : : : : i 2006. 4. 11 Excel JMP 0 1 1 (ICC) 2 1.1 2 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 2 (1) : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : :

More information

( 30 ) 30 4 5 1 4 1.1............................................... 4 1.............................................. 4 1..1.................................. 4 1.......................................

More information

renshumondai-kaito.dvi

renshumondai-kaito.dvi 3 1 13 14 1.1 1 44.5 39.5 49.5 2 0.10 2 0.10 54.5 49.5 59.5 5 0.25 7 0.35 64.5 59.5 69.5 8 0.40 15 0.75 74.5 69.5 79.5 3 0.15 18 0.90 84.5 79.5 89.5 2 0.10 20 1.00 20 1.00 2 1.2 1 16.5 20.5 12.5 2 0.10

More information

( 28 ) ( ) ( ) 0 This note is c 2016, 2017 by Setsuo Taniguchi. It may be used for personal or classroom purposes, but not for commercial purp

( 28 ) ( ) ( ) 0 This note is c 2016, 2017 by Setsuo Taniguchi. It may be used for personal or classroom purposes, but not for commercial purp ( 28) ( ) ( 28 9 22 ) 0 This ote is c 2016, 2017 by Setsuo Taiguchi. It may be used for persoal or classroom purposes, but ot for commercial purposes. i (http://www.stat.go.jp/teacher/c2epi1.htm ) = statistics

More information

0 (1 ) 0 (1 ) 01 Excel Excel ( ) = Excel Excel =5+ 5 + 7 =5-5 3 =5* 5 10 =5/ 5 5 =5^ 5 5 ( ), 0, Excel, Excel 13E+05 13 10 5 13000 13E-05 13 10 5 0000

0 (1 ) 0 (1 ) 01 Excel Excel ( ) = Excel Excel =5+ 5 + 7 =5-5 3 =5* 5 10 =5/ 5 5 =5^ 5 5 ( ), 0, Excel, Excel 13E+05 13 10 5 13000 13E-05 13 10 5 0000 1 ( S/E) 006 7 30 0 (1 ) 01 Excel 0 7 3 1 (-4 ) 5 11 5 1 6 13 7 (5-7 ) 9 1 1 9 11 3 Simplex 1 4 (shadow price) 14 5 (reduced cost) 14 3 (8-10 ) 17 31 17 3 18 33 19 34 35 36 Excel 3 4 (11-13 ) 5 41 5 4

More information

ユニセフ表紙_CS6_三.indd

ユニセフ表紙_CS6_三.indd 16 179 97 101 94 121 70 36 30,552 1,042 100 700 61 32 110 41 15 16 13 35 13 7 3,173 41 1 4,700 77 97 81 47 25 26 24 40 22 14 39,208 952 25 5,290 71 73 x 99 185 9 3 3 3 8 2 1 79 0 d 1 226 167 175 159 133

More information

( )/2 hara/lectures/lectures-j.html 2, {H} {T } S = {H, T } {(H, H), (H, T )} {(H, T ), (T, T )} {(H, H), (T, T )} {1

( )/2   hara/lectures/lectures-j.html 2, {H} {T } S = {H, T } {(H, H), (H, T )} {(H, T ), (T, T )} {(H, H), (T, T )} {1 ( )/2 http://www2.math.kyushu-u.ac.jp/ hara/lectures/lectures-j.html 1 2011 ( )/2 2 2011 4 1 2 1.1 1 2 1 2 3 4 5 1.1.1 sample space S S = {H, T } H T T H S = {(H, H), (H, T ), (T, H), (T, T )} (T, H) S

More information

6.1 (P (P (P (P (P (P (, P (, P.101

6.1 (P (P (P (P (P (P (, P (, P.101 (008 0 3 7 ( ( ( 00 1 (P.3 1 1.1 (P.3.................. 1 1. (P.4............... 1 (P.15.1 (P.15................. (P.18............3 (P.17......... 3.4 (P................ 4 3 (P.7 4 3.1 ( P.7...........

More information

untitled

untitled Microsoft Excel 1. 2. 3. 4. VBA) A IV 256 BMI (Body Mass Index) AVERAGE,COUNTIF BMI ( kg ) = 22 ( m) 2 BMI (Body Mass Index) BMI = ( kg ( m ) ) 2 BMI BMI 20 BMI 20 24 BMI 24 26.5 BMI 26.5 E1 kg Del Back

More information

9 2 1 f(x, y) = xy sin x cos y x y cos y y x sin x d (x, y) = y cos y (x sin x) = y cos y(sin x + x cos x) x dx d (x, y) = x sin x (y cos y) = x sin x

9 2 1 f(x, y) = xy sin x cos y x y cos y y x sin x d (x, y) = y cos y (x sin x) = y cos y(sin x + x cos x) x dx d (x, y) = x sin x (y cos y) = x sin x 2009 9 6 16 7 1 7.1 1 1 1 9 2 1 f(x, y) = xy sin x cos y x y cos y y x sin x d (x, y) = y cos y (x sin x) = y cos y(sin x + x cos x) x dx d (x, y) = x sin x (y cos y) = x sin x(cos y y sin y) y dy 1 sin

More information

Microsoft PowerPoint - 13統計の分析と利用_1-1.pptx

Microsoft PowerPoint - 13統計の分析と利用_1-1.pptx 統 計 の 分 析 と 利 用. データとその 扱 い PartⅠ -. 一 次 元 のデータ 度 数 分 布 ヒストグラム 幹 葉 プロット 箱 ひげ 図 代 表 値 と 散 らばり データの 尺 度 -. 二 次 元 のデータ 変 数 の 関 係 : 散 布 図, 共 分 散 相 関 係 数 変 数 の 関 係 :クロス 集 計,クラメルの 連 関 係 数 変 数 の 関 係 3: 点 グラフ,

More information

MICROLINK マリオネット 操作説明書

MICROLINK マリオネット 操作説明書 2001 7 2 2001 7 18 2001 7 30 2001 9 18 1 1.... 6 2....8 2.1....8 2.2.... 8 2.3.... 9 2.4.... 9 2.4.1.... 10 2.4.2.... 10 2.4.3.... 11 2.4.4.... 12 2.5.... 13 3.... 15 3.1.... 15 3.2.... 15 3.2.1.... 15

More information

1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) (

1 Excel 1. [Standard] (call [Call Standard]) Excel [ ] [E ] Excel m 1 ( ) ( 1 Excel 1. [Standard] (call [Call Standard]) Excel [] [E ] Excel 2. 2 2.1 50m 1 ( ) 30 1. 2019 (http://news.fukuoka-edu.ac.jp/form/guide/navi2019.pdf), p.7 8 2. Excel 2019 4 Excel 2019 Excel 2013 [] [R]

More information

<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63>

<4D6963726F736F667420576F7264202D204850835483938376838B8379815B83578B6594BB2D834A836F815B82D082C88C60202E646F63> 例 題 で 学 ぶ Excel 統 計 入 門 第 2 版 サンプルページ この 本 の 定 価 判 型 などは, 以 下 の URL からご 覧 いただけます. http://www.morikita.co.jp/books/mid/084302 このサンプルページの 内 容 は, 第 2 版 発 行 当 時 のものです. i 2 9 2 Web 2 Excel Excel Excel 11 Excel

More information

20130521_11_19_2.indd

20130521_11_19_2.indd MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX ac 450+ 450Mbps 450 Mbps 300+ 300Mbps 300 Mbps 300 Mbps 1300+ ac 450Mbps 866+ 300Mbps 300 Mbps 300& PLC 240 Mbps 300 Mbps

More information

¥¤¥ó¥¿¡¼¥Í¥Ã¥È·×¬¤È¥Ç¡¼¥¿²òÀÏ Âè2²ó

¥¤¥ó¥¿¡¼¥Í¥Ã¥È·×¬¤È¥Ç¡¼¥¿²òÀÏ Âè2²ó 2 2015 4 20 1 (4/13) : ruby 2 / 49 2 ( ) : gnuplot 3 / 49 1 1 2014 6 IIJ / 4 / 49 1 ( ) / 5 / 49 ( ) 6 / 49 (summary statistics) : (mean) (median) (mode) : (range) (variance) (standard deviation) 7 / 49

More information

1 1.1 Excel Excel Excel log 1, log 2, log 3,, log 10 e = ln 10 log cm 1mm 1 10 =0.1mm = f(x) f(x) = n

1 1.1 Excel Excel Excel log 1, log 2, log 3,, log 10 e = ln 10 log cm 1mm 1 10 =0.1mm = f(x) f(x) = n 1 1.1 Excel Excel Excel log 1, log, log,, log e.7188188 ln log 1. 5cm 1mm 1 0.1mm 0.1 4 4 1 4.1 fx) fx) n0 f n) 0) x n n! n + 1 R n+1 x) fx) f0) + f 0) 1! x + f 0)! x + + f n) 0) x n + R n+1 x) n! 1 .

More information

1. A0 A B A0 A : A1,...,A5 B : B1,...,B12 2. 5 3. 4. 5. A0 (1) A, B A B f K K A ϕ 1, ϕ 2 f ϕ 1 = f ϕ 2 ϕ 1 = ϕ 2 (2) N A 1, A 2, A 3,... N A n X N n X N, A n N n=1 1 A1 d (d 2) A (, k A k = O), A O. f

More information

* n x 11,, x 1n N(µ 1, σ 2 ) x 21,, x 2n N(µ 2, σ 2 ) H 0 µ 1 = µ 2 (= µ ) H 1 µ 1 µ 2 H 0, H 1 *2 σ 2 σ 2 0, σ 2 1 *1 *2 H 0 H

* n x 11,, x 1n N(µ 1, σ 2 ) x 21,, x 2n N(µ 2, σ 2 ) H 0 µ 1 = µ 2 (= µ ) H 1 µ 1 µ 2 H 0, H 1 *2 σ 2 σ 2 0, σ 2 1 *1 *2 H 0 H 1 1 1.1 *1 1. 1.3.1 n x 11,, x 1n Nµ 1, σ x 1,, x n Nµ, σ H 0 µ 1 = µ = µ H 1 µ 1 µ H 0, H 1 * σ σ 0, σ 1 *1 * H 0 H 0, H 1 H 1 1 H 0 µ, σ 0 H 1 µ 1, µ, σ 1 L 0 µ, σ x L 1 µ 1, µ, σ x x H 0 L 0 µ, σ 0

More information

年計グラフ作成システム

年計グラフ作成システム 2003/01/20 2.00 1/29 2003/01/20...2...3...4...5...7...9... 11...13...15...16...17...18...19...20...21...23...24...26...27 FAQ...29 2/29 2003/01/20 Microsoft Access 2000 Microsoft Excel 3/29 2003/01/20

More information

TOPIX30 2 / 37

TOPIX30 2 / 37 W707 s-taiji@is.titech.ac.jp 1 / 37 TOPIX30 2 / 37 1 2 TOPIX30 3 / 37 2000 3000 4000 5000 6000 x 1992 1993 1994 1995 1996 1997 1998 Time 4 / 37 t {X t } t i.i.d. t 5 / 37 Definition ( ) {X t } t. t 1,...,

More information

PowerPoint プレゼンテーション

PowerPoint プレゼンテーション 003.10.3 003.10.8 Y 1 0031016 B4(4 3 B4,1 M 0 C,Q 0. M,Q 1.- MQ 003/10/16 10/8 Girder BeamColumn Foundation SlabWall Girder BeamColumn Foundation SlabWall 1.-1 5mm 0 kn/m 3 0.05m=0.5 kn/m 60mm 18 kn/m

More information

Excel基礎講座演習-表紙とはじめにv1.3.doc

Excel基礎講座演習-表紙とはじめにv1.3.doc Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation B4 11 14 1999 1 C4 E7 C4 E7 2 =C4+D4+E4 SUM MAX MIN B3 F7 Sheet2 1999 2000 3 B3 F7 C4 F7 Delete C4 F7 SUM SUM() C4 SUM 4 B3

More information

untitled

untitled Excel A D-2 B-2 D-2 B2 C-2 D-2 C2-23 - Enter D-2 B2(1000) C2(5) 5000 D-2 (D-2) (D-2) (D-3) (D-6) - 24 - (D-3) (D-6) D (D-2) =B2*C2 (D-3) =B3*C3 (D-4) =B4*C4 Excel - 25 - $A$1 1000 A-1 (B-1) =$A$1 (B-1)

More information

untitled

untitled 20 7 1 22 7 1 1 2 3 7 8 9 10 11 13 14 15 17 18 19 21 22 - 1 - - 2 - - 3 - - 4 - 50 200 50 200-5 - 50 200 50 200 50 200 - 6 - - 7 - () - 8 - (XY) - 9 - 112-10 - - 11 - - 12 - - 13 - - 14 - - 15 - - 16 -

More information

untitled

untitled 19 1 19 19 3 8 1 19 1 61 2 479 1965 64 1237 148 1272 58 183 X 1 X 2 12 2 15 A B 5 18 B 29 X 1 12 10 31 A 1 58 Y B 14 1 25 3 31 1 5 5 15 Y B 1 232 Y B 1 4235 14 11 8 5350 2409 X 1 15 10 10 B Y Y 2 X 1 X

More information

yamadaiR(cEFA).pdf

yamadaiR(cEFA).pdf R 2012/10/05 Kosugi,E.Koji (Yamadai.R) Categorical Factor Analysis by using R 2012/10/05 1 / 9 Why we use... 3 5 Kosugi,E.Koji (Yamadai.R) Categorical Factor Analysis by using R 2012/10/05 2 / 9 FA vs

More information

Excel 2007 Excel 2007 Excel 2007

Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel Excel Excel Book1 Sheet1 Excel Excel Excel 2002OSWindows XP Excel Excel Excel Excel Office Excel Excel Excel Excel Excel A A5 CtrlC B3 B3 B3 B3 Excel A1

More information

相関係数と偏差ベクトル

相関係数と偏差ベクトル 相関係数と偏差ベクトル 経営統計演習の補足資料 07 年 月 9 日金沢学院大学経営情報学部藤本祥二 相関係数の復習 r = s xy s x s y = = n σ n i= σn i= n σ n i= n σ i= x i xҧ y i തy x i xҧ n σ n i= y i തy x i xҧ x i xҧ y i തy σn i= y i തy 式が長くなるので u, v の文字で偏差を表すことにする

More information

‚åŁÎ“·„´Šš‡ðŠp‡¢‡½‹âfi`fiI…A…‰…S…−…Y…•‡ÌMarkovŸA“½fiI›ð’Í

‚åŁÎ“·„´Šš‡ðŠp‡¢‡½‹âfi`fiI…A…‰…S…−…Y…•‡ÌMarkovŸA“½fiI›ð’Í Markov 2009 10 2 Markov 2009 10 2 1 / 25 1 (GA) 2 GA 3 4 Markov 2009 10 2 2 / 25 (GA) (GA) L ( 1) I := {0, 1} L f : I (0, ) M( 2) S := I M GA (GA) f (i) i I Markov 2009 10 2 3 / 25 (GA) ρ(i, j), i, j I

More information

日本の不動産市場における価格情報とボラティリティの非対称について:大阪市の実証研究から

日本の不動産市場における価格情報とボラティリティの非対称について:大阪市の実証研究から 1 2 3 1. [2001]) 4 2 " " " " DI 3 5 6 7 8 9 10 11 1) * ( ) ( ) ( ) ( ) ( ) ( 1) * ( + + = + + t t r t P t R t P t P t P ρ ) 1 ( * + t ρ 4 PVR [2001] 12 13 14 15 16 17 18 19 20 23 24 25 26 27 ( ) stdev

More information

α β *2 α α β β α = α 1 β = 1 β 2.2 α 0 β *3 2.3 * *2 *3 *4 (µ A ) (µ P ) (µ A > µ P ) 10 (µ A = µ P + 10) 15 (µ A = µ P +

α β *2 α α β β α = α 1 β = 1 β 2.2 α 0 β *3 2.3 * *2 *3 *4 (µ A ) (µ P ) (µ A > µ P ) 10 (µ A = µ P + 10) 15 (µ A = µ P + Armitage 1 1.1 2 t *1 α β 1.2 µ x µ 2 2 2 α β 2.1 1 α β α ( ) β *1 t t 1 α β *2 α α β β α = α 1 β = 1 β 2.2 α 0 β 1 0 0 1 1 5 2.5 *3 2.3 *4 3 3.1 1 1 1 *2 *3 *4 (µ A ) (µ P ) (µ A > µ P ) 10 (µ A = µ P

More information

C:/texfile/2010/comp_rad_phys_2010.dvi

C:/texfile/2010/comp_rad_phys_2010.dvi 1 3 3 1 1.. N p N [1] p N N (1) 3. 1.1 p 1. 1.3 N N 1.3 1.4 [ (8) ] 1.1 i i = 1 i () 1 1 s = 1 ( i ; ) (3) s s s = vu u t 1 ( i ; ) (4) 1 1-1-15 1 1. i y y = i = 1 + + + N = (5) y y i i y = @y @ 1 1 +

More information

ii 3.,. 4. F. (), ,,. 8.,. 1. (75% ) (25% ) =9 7, =9 8 (. ). 1.,, (). 3.,. 1. ( ).,.,.,.,.,. ( ) (1 2 )., ( ), 0. 2., 1., 0,.

ii 3.,. 4. F. (), ,,. 8.,. 1. (75% ) (25% ) =9 7, =9 8 (. ). 1.,, (). 3.,. 1. ( ).,.,.,.,.,. ( ) (1 2 )., ( ), 0. 2., 1., 0,. 23(2011) (1 C104) 5 11 (2 C206) 5 12 http://www.math.is.tohoku.ac.jp/~obata,.,,,.. 1. 2. 3. 4. 5. 6. 7.,,. 1., 2007 ( ). 2. P. G. Hoel, 1995. 3... 1... 2.,,. ii 3.,. 4. F. (),.. 5.. 6.. 7.,,. 8.,. 1. (75%

More information

FX ) 2

FX ) 2 (FX) 1 1 2009 12 12 13 2009 1 FX ) 2 1 (FX) 2 1 2 1 2 3 2010 8 FX 1998 1 FX FX 4 1 1 (FX) () () 1998 4 1 100 120 1 100 120 120 100 20 FX 100 100 100 1 100 100 100 1 100 1 100 100 1 100 101 101 100 100

More information

2 1,2, , 2 ( ) (1) (2) (3) (4) Cameron and Trivedi(1998) , (1987) (1982) Agresti(2003)

2 1,2, , 2 ( ) (1) (2) (3) (4) Cameron and Trivedi(1998) , (1987) (1982) Agresti(2003) 3 1 1 1 2 1 2 1,2,3 1 0 50 3000, 2 ( ) 1 3 1 0 4 3 (1) (2) (3) (4) 1 1 1 2 3 Cameron and Trivedi(1998) 4 1974, (1987) (1982) Agresti(2003) 3 (1)-(4) AAA, AA+,A (1) (2) (3) (4) (5) (1)-(5) 1 2 5 3 5 (DI)

More information

2 3

2 3 Sample 2 3 4 5 6 7 8 9 3 18 24 32 34 40 45 55 63 70 77 82 96 118 121 123 131 143 149 158 167 173 187 192 204 217 224 231 17 285 290 292 1 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

More information

リスクとは何か?

リスクとは何か? http://www.craft.titech.ac.jp/~nakagawa/dir2/lecture.html#tit2005_1 Agenda Value at Risk 2 3 TOPIX 10 95% 4 TOPIX or Value at Risk 5 TOPIX = log TOPIX N 6 7 N TOPIX x, x, 1 2, L x N 8 x = N 1 EXCEL AVERAGE

More information

untitled

untitled 13,000 1 35,400 8,000 1 35,400 2 ~6 46,000 2 ~6 46,000 7 55,000 7 55,200 2,750 2,750 4,910 4,910 149,000 149,000 45,000 75,000 45,000 75,000 189,000 165,400 151,200 132,300 33 29 4 33 29 4 150,410 128,100

More information

関 数

関 数 /0/ 12 / / + 2 3 3 2 2 * 2*3 / 2/3 23 2 3 11 11 11 11 11 11 28 2468 2648 RANK SUM COUNTA SUMIF COUNTIF AVERAGE ROUND STDEVP FREQUENCY MAX LARGE MEDIAN MIN 66 6 C6:C15,,G6:G15 SUM 66 / D17,1 SUMIF / C6:C15,,G6:G15

More information

橡ボーダーライン.PDF

橡ボーダーライン.PDF 1 ( ) ( ) 2 3 4 ( ) 5 6 7 8 9 10 11 12 13 14 ( ) 15 16 17 18 19 20 ( ) 21 22 23 24 ( ) 25 26 27 28 29 30 ( ) 31 To be or not to be 32 33 34 35 36 37 38 ( ) 39 40 41 42 43 44 45 46 47 48 ( ) 49 50 51 52

More information

Microsoft Word - 研究デザインと統計学.doc

Microsoft Word - 研究デザインと統計学.doc Study design and the statistical basics Originality Accuracy Objectivity Verifiability Readability perfect Interdisciplinary Sciences Health Science 2014.12.25 2 1. 7 2. 7 3. Bias8 4. random sampling8

More information

x () g(x) = f(t) dt f(x), F (x) 3x () g(x) g (x) f(x), F (x) (3) h(x) = x 3x tf(t) dt.9 = {(x, y) ; x, y, x + y } f(x, y) = xy( x y). h (x) f(x), F (x

x () g(x) = f(t) dt f(x), F (x) 3x () g(x) g (x) f(x), F (x) (3) h(x) = x 3x tf(t) dt.9 = {(x, y) ; x, y, x + y } f(x, y) = xy( x y). h (x) f(x), F (x [ ] IC. f(x) = e x () f(x) f (x) () lim f(x) lim f(x) x + x (3) lim f(x) lim f(x) x + x (4) y = f(x) ( ) ( s46). < a < () a () lim a log xdx a log xdx ( ) n (3) lim log k log n n n k=.3 z = log(x + y ),

More information

Copyright 2003 MapNet.Corp All rights reserved (1) V2.2 (2) (3) (4) (5) (6) 1 (7) (8) (9) 1/2500 1/250 1/10000 1/10000 20 5 1/2500 20 1/500 1/500 1/250 5 1 (1) (2) (3) OK One Point () and or

More information

2 Part A B C A > B > C (0) 90, 69, 61, 68, 6, 77, 75, 20, 41, 34 (1) 8, 56, 16, 50, 43, 66, 44, 77, 55, 48 (2) 92, 74, 56, 81, 84, 86, 1, 27,

2 Part A B C A > B > C (0) 90, 69, 61, 68, 6, 77, 75, 20, 41, 34 (1) 8, 56, 16, 50, 43, 66, 44, 77, 55, 48 (2) 92, 74, 56, 81, 84, 86, 1, 27, / (1) (2) (3) ysawano@tmu.ac.jp (4) (0) (10) 11 (10) (a) (b) (c) (5) - - 11160939-11160939- - 1 2 Part 1. 1. 1. A B C A > B > C (0) 90, 69, 61, 68, 6, 77, 75, 20, 41, 34 (1) 8, 56, 16, 50, 43, 66, 44,

More information

hokou

hokou 保 健 統 計 配 布 資 料 2014/9/30 Ⅰ データのダウンロード 課 題 1 講 義 用 HP から 女 子 の 身 長 と 体 重 のデータをダウンロードし A 列 に 番 号 を 入 力 せよ A 列 の 入 力 は 後 で 説 明 する 連 続 データの 入 力 が 便 利 である 1 保 健 統 計 講 義 用 HP(http://www.tokuyama-kango.or.jp/kawada)を

More information

P072-076.indd

P072-076.indd 3 STEP0 STEP1 STEP2 STEP3 STEP4 072 3STEP4 STEP3 STEP2 STEP1 STEP0 073 3 STEP0 STEP1 STEP2 STEP3 STEP4 074 3STEP4 STEP3 STEP2 STEP1 STEP0 075 3 STEP0 STEP1 STEP2 STEP3 STEP4 076 3STEP4 STEP3 STEP2 STEP1

More information

STEP1 STEP3 STEP2 STEP4 STEP6 STEP5 STEP7 10,000,000 2,060 38 0 0 0 1978 4 1 2015 9 30 15,000,000 2,060 38 0 0 0 197941 2016930 10,000,000 2,060 38 0 0 0 197941 2016930 3 000 000 0 0 0 600 15

More information

1

1 1 2 3 4 5 6 7 8 9 0 1 2 6 3 1 2 3 4 5 6 7 8 9 0 5 4 STEP 02 STEP 01 STEP 03 STEP 04 1F 1F 2F 2F 2F 1F 1 2 3 4 5 http://smarthouse-center.org/sdk/ http://smarthouse-center.org/inquiries/ http://sh-center.org/

More information