統計的仮説検定とExcelによるt検定
|
|
- こうき いさし
- 7 years ago
- Views:
Transcription
1 I L14( Fri) : Time-stamp: Fri 14:03 JST hig 1,,,, p, Excel p, t. ( ) L14 Excel t I(015) 1 / 0
2 L13-Q1 Quiz : n = 9. σ 0.95, S n 1 (n 1) <σ < S χ α <σ < <σ < 64. χ 1 α n 1 (n 1) L13-Q Quiz : n = 9., X = 1 9 [ ] = 80g., S = [(78 80) + + (8 80) ] = 4g., µ 80g, σ 4g. ( ) L14 Excel t I(015) / 0
3 µ 0.95, S X t 0.05 (9 1) n <µ < X + t 0.05(9 1) <µ < <µ < σ 0.95, S n 1 (n 1) <σ < S χ α <σ < <σ < χ 1 α n 1 (n 1) S n ( ) L14 Excel t I(015) 3 / 0
4 3 4 Excel t Excel ( ) L14 Excel t I(015) 4 / 0
5 ( ) N(µ, σ ), σ 0!(σ 0 ) H 1 σ σ 0. ( ) H 0 σ = σ 0. n S,, Y = (n 1) S, n 1. σ0 y 0 = χ 1 α (n 1), y 1 = χ α (n 1) ( ) L14 Excel t I(015) 5 / 0
6 1 α = 0.95, ( ) P χ 1 α (n 1) < (n 1) S σ0 < χ α (n 1) = 1 α., S,, S S < σ 0 χ 1 α (n 1), σ0 n 1,. χ α (n 1) < S n 1 ( ) L14 Excel t I(015) 6 / 0
7 L14-Q1 TA Prob and Sol: S, σ 0 = 4g., S 9, ( g). 76, 76, 76, 76, 80, 84, 84, 84, 84. S σ, σ 0?, α = 0.05,. 1 α = 0.05,. ( ) L14 Excel t I(015) 7 / 0
8 3, σ, σ0 = 4 4 n S, χ = (n 1) s, n 1. σ0. 5 χ = (n 1) s = (9 1) 16 σ0 4 = 3. 6,, χ < χ 1 α (n 1) =.180, χ > χ α (n 1) = σ 0 = 4.,. σ0 ( σ0 )., p Excel p, p = < α,. ( ) L14 Excel t I(015) 8 / 0
9 3 4 Excel t Excel ( ) L14 Excel t I(015) 9 / 0
10 ,, q 0 = H 1 q q 0 H 0 q = q 0 : 100 X. X = 0, 5, 6,..., 100. ( ) L14 Excel t I(015) 10 / 0
11 L14-Q q 0 = 0.03,, α. α., α. ( ) L14 Excel t I(015) 11 / 0
12 L14-Q3 q( q 0 ),, β., 1 β β.. ( ) L14 Excel t I(015) 1 / 0
13 ,, H 0 H 0 H 0 ( β ) H 0 1 ( α ) α: 1 α: 1 β: or, β α., α, β. ( ) L14 Excel t I(015) 13 / 0
14 p (t ) p (p-value),. p < α. ( ) L14 Excel t I(015) 14 / 0
15 Excel 3 4 Excel t Excel ( ) L14 Excel t I(015) 15 / 0
16 Excel Excel 013 Excel average var stdev : average, varp, stdevp. ( ) L14 Excel t I(015) 16 / 0
17 Excel Excel 013 t n: t Excel p =t.dist.rt(t, n) t =t.inv( p, n) Excel Excel,. R II, II ( ) L14 Excel t I(015) 17 / 0
18 Excel Excel t T T p p < α t, t II ( ) L14 Excel t I(015) 18 / 0
19 Excel Excel 013 n: t Excel p =chisq.dist.rt(y 1, n) 1 p =chisq.dist.rt(y 0, n) y 1 =chisq.inv( p, n) y 0 =chisq.inv(1 p, n) ( ) L14 Excel t I(015) 19 / 0
20 Excel t Math., Quiz , Quiz 4 6(1-50) manaba / ryukoku.ac.jp ( ) L14 Excel t I(015) 0 / 0
独立性の検定・ピボットテーブル
II L04(2016-05-12 Thu) : Time-stamp: 2016-05-12 Thu 12:48 JST hig 2, χ 2, V Excel http://hig3.net ( ) L04 II(2016) 1 / 20 L03-Q1 Quiz : 1 { 0.95 (y = 10) P (Y = y X = 1) = 0.05 (y = 20) { 0.125 (y = 10)
More information... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2
1 ... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 3 4 5 6 7 8 9 Excel2007 10 Excel2007 11 12 13 - 14 15 16 17 18 19 20 21 22 Excel2007
More informationカテゴリ変数と独立性の検定
II L04(2015-05-01 Fri) : Time-stamp: 2015-05-01 Fri 22:28 JST hig 2, Excel 2, χ 2,. http://hig3.net () L04 II(2015) 1 / 20 : L03-S1 Quiz : 1 2 7 3 12 (x = 2) 12 (y = 3) P (X = x) = 5 12 (x = 3), P (Y =
More informationデータの分布と代表値
I L01(2015-09-18 Fri) : Time-stamp: 2015-09-26 Sat 10:37 JST hig e, http://hig3.net ( ) L01 I(2015) 1 / 26 ? 1? 2? ( ) L01 I(2015) 2 / 26 ?,,.,., 1..,. (,, 1, 2 ),.,. ( ) L01 I(2015) 3 / 26 ? I. M (3 )
More informationデータの分布
I L01(2016-09-22 Thu) : Time-stamp: 2016-09-27 Tue 11:12 JST hig e LINE@, 4, http://hig3.net () L01 I(2016) 1 / 20 ? 1? 2? () L01 I(2016) 2 / 20 ?,,.,., 1..,. (,, 1, 2 ),.,. () L01 I(2016) 3 / 20 ? I.
More information1 913 10301200 A B C D E F G H J K L M 1A1030 10 : 45 1A1045 11 : 00 1A1100 11 : 15 1A1115 11 : 30 1A1130 11 : 45 1A1145 12 : 00 1B1030 1B1045 1C1030
1 913 9001030 A B C D E F G H J K L M 9:00 1A0900 9:15 1A0915 9:30 1A0930 9:45 1A0945 10 : 00 1A1000 10 : 15 1B0900 1B0915 1B0930 1B0945 1B1000 1C0900 1C0915 1D0915 1C0930 1C0945 1C1000 1D0930 1D0945 1D1000
More information分散分析・2次元正規分布
2 II L10(2016-06-30 Thu) : Time-stamp: 2016-06-30 Thu 13:55 JST hig F 2.. http://hig3.net ( ) L10 2 II(2016) 1 / 24 F 2 F L09-Q1 Quiz :F 1 α = 0.05, 2 F 3 H 0, : σ 2 1 /σ2 2 = 1., H 1, σ 2 1 /σ2 2 1. 4
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 information3 3.3. I 3.3.2. [ ] N(µ, σ 2 ) σ 2 (X 1,..., X n ) X := 1 n (X 1 + + X n ): µ X N(µ, σ 2 /n) 1.8.4 Z = X µ σ/ n N(, 1) 1.8.2 < α < 1/2 Φ(z) =.5 α z α
2 2.1. : : 2 : ( ): : ( ): : : : ( ) ( ) ( ) : ( pp.53 6 2.3 2.4 ) : 2.2. ( ). i X i (i = 1, 2,..., n) X 1, X 2,..., X n X i (X 1, X 2,..., X n ) ( ) n (x 1, x 2,..., x n ) (X 1, X 2,..., X n ) : X 1,
More information2変量データの共分散・相関係数・回帰分析
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 information3 3.1 *2 1 2 3 4 5 6 *2 2
Armitage 1 2 11 10 3.32 *1 9 5 5.757 3.3667 7.5 1 9 6 5.757 7 7.5 7.5 9 7 7 9 7.5 10 9 8 7 9 9 10 9 9 9 10 9 11 9 10 10 10 9 11 9 11 11 10 9 11 9 12 13 11 10 11 9 13 13 11 10 12.5 9 14 14.243 13 12.5 12.5
More informationマルコフ連鎖の時間発展の数値計算
B L07(206-05-2 Mon : Time-stamp: 206-05-2 Mon 8:4 JST hig http://hig.net ( L07 B(206 / 20 L05-Q TA Prob and Sol:, {, 2}. M = ( 2 2 2.. 2 p(0 = ( 0 p(t. p(0 = 2 ( p(t. ( L07 B(206 2 / 20 M λ, λ 2, u, u
More informationaisatu.pdf
1 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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
More informationuntitled
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 information36
36 37 38 P r R P 39 (1+r ) P =R+P g P r g P = R r g r g == == 40 41 42 τ R P = r g+τ 43 τ (1+r ) P τ ( P P ) = R+P τ ( P P ) n P P r P P g P 44 R τ P P = (1 τ )(r g) (1 τ )P R τ 45 R R σ u R= R +u u~ (0,σ
More informationI 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(interval estimation) 3 (confidence coefficient) µ σ/sqrt(n) 4 P ( (X - µ) / (σ sqrt N < a) = α a α X α µ a σ sqrt N X µ a σ sqrt N 2
7 2 1 (interval estimation) 3 (confidence coefficient) µ σ/sqrt(n) 4 P ( (X - µ) / (σ sqrt N < a) = α a α X α µ a σ sqrt N X µ a σ sqrt N 2 (confidence interval) 5 X a σ sqrt N µ X a σ sqrt N - 6 P ( X
More information一般演題(ポスター)
6 5 13 : 00 14 : 00 A μ 13 : 00 14 : 00 A β β β 13 : 00 14 : 00 A 13 : 00 14 : 00 A 13 : 00 14 : 00 A β 13 : 00 14 : 00 A β 13 : 00 14 : 00 A 13 : 00 14 : 00 A β 13 : 00 14 : 00 A 13 : 00 14 : 00 A
More information日本糖尿病学会誌第58巻第1号
α β β β β β β α α β α β α l l α l μ l β l α β β Wfs1 β β l l l l μ l l μ μ l μ l Δ l μ μ l μ l l ll l l l l l l l l μ l l l l μ μ l l l l μ l l l l l l l l l l μ l l l μ l μ l l l l l l l l l μ l l l l
More information第85 回日本感染症学会総会学術集会後抄録(III)
β β α α α µ µ µ µ α α α α γ αβ α γ α α γ α γ µ µ β β β β β β β β β µ β α µ µ µ β β µ µ µ µ µ µ γ γ γ γ γ γ µ α β γ β β µ µ µ µ µ β β µ β β µ α β β µ µµ β µ µ µ µ µ µ λ µ µ β µ µ µ µ µ µ µ µ
More informationP-12 P-13 3 4 28 16 00 17 30 P-14 P-15 P-16 4 14 29 17 00 18 30 P-17 P-18 P-19 P-20 P-21 P-22
1 14 28 16 00 17 30 P-1 P-2 P-3 P-4 P-5 2 24 29 17 00 18 30 P-6 P-7 P-8 P-9 P-10 P-11 P-12 P-13 3 4 28 16 00 17 30 P-14 P-15 P-16 4 14 29 17 00 18 30 P-17 P-18 P-19 P-20 P-21 P-22 5 24 28 16 00 17 30 P-23
More informationP1-1 P1-2 P1-3 P1-4 P1-5 P1-6 P3-1 P3-2 P3-3 P3-4 P3-5 P3-6 P5-1 P5-2 P5-3 P5-4 P5-5 P5-6 P7-1 P7-2 P7-3 P7-4 P7-5 P7-6 P9-1 P9-2 P9-3 P9-4 P9-5 P9-6 P11-1 P11-2 P11-3 P11-4 P13-1 P13-2 P13-3 P13-4 P13-5
More information54_2-05-地方会.indd
82 58 59 21 83 84 2 9 4 85 86 1. 87 6 88 89 β 1 90 2 3 p 4 t 5 6 EQ 91 7 8 9 1 10 2 92 11 3 12 13 IT p 14 93 15 16 ACTIVE 17 18 94 p p p 19 20 21 22 95 23 24 25 2 26 β β 96 27 1 28 29 30 97 31 32 33 1
More information時系列解析
B L12(2016-07-11 Mon) : Time-stamp: 2016-07-11 Mon 17:25 JST hig,, Excel,. http://hig3.net ( ) L12 B(2016) 1 / 24 L11-Q1 Quiz : 1 E[R] = 1 2, V[R] = 9 12 = 3 4. R(t), E[X(30)] = E[X(0)] + 30 1 2 = 115,
More informationMicro-D 小型高密度角型コネクタ
Micro- 1 2 0.64 1.27 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 1.09 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 3 4 J J
More informationhttp://banso.cocolog-nifty.com/ 100 100 250 5 1 1 http://www.banso.com/ 2009 5 2 10 http://www.banso.com/ 2009 5 2 http://www.banso.com/ 2009 5 2 http://www.banso.com/ < /> < /> / http://www.banso.com/
More information1 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診療ガイドライン外来編2014(A4)/FUJGG2014‐01(大扉)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
More informationn=360 28.6% 34.4% 36.9% n=360 2.5% 17.8% 19.2% n=64 0.8% 0.3% n=69 1.7% 3.6% 0.6% 1.4% 1.9% < > n=218 1.4% 5.6% 3.1% 60.6% 0.6% 6.9% 10.8% 6.4% 10.3% 33.1% 1.4% 3.6% 1.1% 0.0% 3.1% n=360 0% 50%
More information疎な転置推移確率行列
B E05(2019-05-15 Tue) : Time-stamp: 2019-05-17 Fri 16:18 JST hig http://hig3.net ( ) E05 B(2019) 1 / 11 x = 0,..., m 1 m. p(t), p(x, t) 1 double p [m] = { 1. 0, 0. 0,...., 0. 0 } ; /. m. / 2 / {p ( 0,
More information受賞講演要旨2012cs3
アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート アハ ート α β α α α α α
More information38
3 37 38 3.1. 3.1.1. 3.1-1 2005 12 5 7 2006 5 31 6 2 2006 8 10 11 14 2006 10 18 20 3.1-1 9 00 17 3 3.1.2. 3.1-2 3.1-1 9 9 3.1-2 M- M-2 M-3 N- N-2 N-3 S- S-2 S-3 3.1.2.1. 25 26 3.1.2.2. 3.1-3 25 26 39 3.1-1
More information項 目
1 1 2 3 11 4 6 5 7,000 2 120 1.3 4,000 04 450 < > 5 3 6 7 8 9 4 10 11 5 12 45 6 13 E. 7 B. C. 14 15 16 17 18 19 20 21 22 23 8 24 25 9 27 2 26 6 27 3 1 3 3 28 29 30 9 31 32 33 500 1 4000 0 2~3 10 10 34
More information2 1 2 3 27 2 6 2 5 19 50 1 2
1 2 1 2 3 27 2 6 2 5 19 50 1 2 2 17 1 5 6 5 6 3 5 5 20 5 5 5 4 1 5 18 18 6 6 7 8 TA 1 2 9 36 36 19 36 1 2 3 4 9 5 10 10 11 2 27 12 17 13 6 30 16 15 14 15 16 17 18 19 28 34 20 50 50 5 6 3 21 40 1 22 23
More information●70974_100_AC009160_KAPヘ<3099>ーシス自動車約款(11.10).indb
" # $ % & ' ( ) * +, -. / 0 1 2 3 4 5 6 7 8 9 : ; < = >? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y " # $ % & ' ( ) * + , -. / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B
More informationuntitled
i ii (1) (1) (2) (1) (3) (1) (1) (2) (1) (3) (1) (1) (2) (1) (3) (2) (3) (1) (2) (3) (1) (1) (1) (1) (2) (1) (3) (1) (2) (1) (3) (1) (1) (1) (2) (1) (3) (1) (1) (2) (1) (3)
More information