XX data 03.xls sheet(1) data 03.xls sheet(1) 2 1. n 1 2. m 1 3. O 11 O
|
|
|
- はすな はなだて
- 5 years ago
- Views:
Transcription
1 : website: kkarato@eco.u-toyama.ac.jp IF
2 XX data 03.xls sheet(1) data 03.xls sheet(1) 2 1. n 1 2. m 1 3. O 11 O 12, O 21, O 22, n 2, m 2 2 O 11 = 3 O 12 = 4 n 1 = 7 O21 = 1 O 22 = 2 n 2 = 3 m 1 = 4 m 2 = 6 N = 10
3 1 3 O 12 = n 1 O 11 O 21 = m 1 O 11 n 2 = N n 1 m 2 = N m 1 O 22 = n 2 O 21 ( O 22 = m 2 O 12 ) X {x 1, x 2, } Y {y 1, y 2 } K L (K 1) (L 1) (K 1) (L 1) 1.2 IF x y 1 IF IF = if(, ) = if( = 5, 1 0 ) = 5 = 1 = if( = 3, " " " " ) = 3 = 2 x 1 x 1 = { 1, 0, 1 0 data 03.xls sheet(1) F4 = IF ( C4 = "", 1, 0 ) 2 y G4
4 1 4 = IF ( D4 = "", 1, 0 ) x 1 n 1 y 1 m = IF ( F4 + G4 = 2, 1, 0 ) x 1 = 1 y 1 = x 1i + y 1i = H O 11 1 data 03.xls sheet(2) T Excel IF 2 data 03.xls sheet(2) OK 1 2
5 data 03.xls sheet(3)
6 2 6 3 data 03.xls sheet(5) N m p 1, p 2,, p m H 0 : p 1 = p 10, p 2 = p 20,, p m = p m0 O 1, O 2,, O m E 1 = Np 10, E 2 = Np 20,, E m = Np m0 m (O j E j ) 2 Q = m 1 χ 2 (1) E j j=1 3 data 03.xls sheet(6) A A [ ] [%] A 5%
7 2 7 3 A A H 0 : p 1 = 0.62, p 2 = 0.31, p 3 = 0.07 p 1, p 2, p 3 A 3 A O 1 = 220 ( 1 ) O 2 = 99 ( 2 ) O 3 = 41 ( 3 ) N = = 360[ ] A E 1 = = ( 1 ) E 2 = = ( 2 ) E 3 = = 25.2 ( 3 ) (1) m = = 2 χ 2 5% χ ,2 = Q > Q A : Q = : 0.05 : m = 3 : m 1 = 2 ( ) : C Q = ( ) ( ) = A A χ 2 : CHIINV = chiinv(, )
8 2 8 3 CHITEST p 4 2 χ 2 : 5% f(x) chiinv(0.05,2)= x χ 2 p (1): CHIDIST = chidist(, ) Q = p % 0.05
9 2 9 χ 2 p (2): CHITEST = chitest(, ) CHITEST p p Q = chiinv(p, ) 4 p = chidist(q, ) Q = chiinv(p, ) data 03.xls sheet(7). 5% : Q = : 0.05 : m = 7 : m 1 = 6 : C Q = p K L (K 1)(L 1) χ 2
10 data 03.xls sheet(8) N = % (, ) (, ) ( ) ( ) ( ) O11 O = = O 21 O N = = 25[ ] (2) {E ij } ( ) = Pr(, ) = Pr() Pr() = = Pr(, ) = Pr() Pr() = = Pr(, ) = Pr() Pr() = = Pr(, ) = Pr() Pr() = = ( ) Pr(, ) N Pr(, ) N = Pr(, ) N Pr(, ) N ( 6.6 ) (3) K L ( ij ij ) 2 Q = (K 1)(L 1) χ 2 (4) ij i=1 j=1 K L (O ij E ij ) 2 Q = i=1 j=1 K L K = 2, L = 2 (2 1) (2 1) = 1 χ 2 5% Q > Q Q O ij
11 2 11 : Q = : 0.05 (5 6.6) (10 8.4) (6 4.4) (4 5.6)2 5.6 = : K = 2 : L = 2 : (K 1)(L 1) = 1 : C Q = C Q χ ,1 = chiinv(0.05,1) p = chidist(, ) Pr( < χ 2 ) = % 5% = chitest(, ) p 5 data 03.xls sheet(4) 5%
untitled
\\\\\ \\\\\ Excel nxxls.exe [(N)] (C:\ProgramFiles\CS) \\\\\ Excel [] \\\\\ notes.ini [] KeyFileName \\\\\ e-mail \\\\\ \\\\\ No. [] [] \\\\\ Excel Excel (XLS) [OK] (V1.1) \\\\\ \\\\\ \\\\\ \\\\\ \\\\\
1 2 3 1 34060120 1,00040 2,000 1 5 10 50 2014B 305,000140 285 5 6 9 1,838 50 922 78 5025 50 10 1 2
0120-563-506 / 9001800 9001700 123113 0120-860-777 163-8626 6-13-1 Tel.03-6742-3111 http://www.himawari-life.co.jp 1 2 3 1 34060120 1,00040 2,000 1 5 10 50 2014B 305,000140 285 5 6 9 1,838 50 922 78 5025
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
17 17 17 17 11 21 28 1 24 12 36 2,000 2 22 11 3.67 3.38 22 2.97 21 10 1.7 1.12 22 10 13 2.75 11 10 15 24 10 12 14 3 17 17 2006 4 17 10 24 12 17 5 15 17 17 11 40 6 17 40 17 11 7 24 17 24 17 8 40 17 17 9
PowerPoint Presentation
2 9/ 3 3 9/ 9 4 5 , PR () 6 ,,, (11) 7 PR 8 9 10 11 TEL. 106 8/131512/291/3 TEL. 107 12/291/3 12 http://www.f-turn.jp/ 13 21 4 21 14 200910 U 200911 U 200911 20102 15 20102 PR 20103 20103 16 20103 20104
untitled
,337 37 35 0,349,09 35 55 988 3 0 0 3,387 7 90 0,369,46 5 57 5 0 90 38 8,369 3 4 5 6 7 8 9 0 3 4 5 6 7 8 9 0 3 4 5 6 8 9 30 3 3 5,400 7,00 9,000 0,800,600 4,400 6,00 8,000 9,800,600 3,400 5,00 7,000 8,800
,877 61,524 33, ,292, ,653 57,601 95,188 2,416 1,767,
02 02 02 180,771 07 02 01 1,377 07 02 02 1,051,703 07 02 05 220,099 07 03 01 926,597 08 02 04 1,877,566 08 04 02 2,973,603 08 05 03 672,950 10 06 03 778,433 10 06 04 735,789 10 06 06 225,392 10 06 07 365,442
1...1 1...1 2...1 2.1...1 2.2...5 2.3...6 1...6 2...6 3...7 4...7 5...7 2.4...8 2...9 1...9 2... 10 2.1... 10 1... 10 2... 11 2.2... 12 1 2... 13 3... 18 4... 22 5... 23 6... 24 2.3... 34 1... 34 2...
2
() () 980-8578 Tel: 022-795-6092 Fax: 022-795-6096 email: 1. 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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 17 46 47 4.1.1
PowerPoint 2002
5.1.1 [ ] [ ] 5 1 5.1.2 [ ] 5 2 5.1.3 [ ] [ ] 5 3 5.1.4 [ ] [ ] [ ] 5 4 5.2.1 [ ] [ ] [ ] [ ] [ ] [] [OK] 5 5 5.2.2 [ ] [ ] [ ] [ ] [ ] [] [ ] [ ] [OK] [OK] 5 6 5.2.3 3-D 3-D [ ] [3-D] 3D 5 7 5.2.4 [Ctrl]
独立性の検定・ピボットテーブル
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)
永田靖著「サンプルサイズの決め方」―補助資料― Excel による検出力とサンプルサイズの計算
2004. 4. 8 Excel 0 1 3 1 2 3.1 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 2 3.2 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 3 3.3
AHPを用いた大相撲の新しい番付編成
5304050 2008/2/15 1 2008/2/15 2 42 2008/2/15 3 2008/2/15 4 195 2008/2/15 5 2008/2/15 6 i j ij >1 ij ij1/>1 i j i 1 ji 1/ j ij 2008/2/15 7 1 =2.01/=0.5 =1.51/=0.67 2008/2/15 8 1 2008/2/15 9 () u ) i i i
2010 5 No.20 2 / 32
2010 5 No.20 2 / 32 2010 5 No.20 3 / 32 2010 5 No.20 4 / 32 2010 5 No.20 5 / 32 2010 5 No.20 6 / 32 2010 5 No.20 7 / 32 2010 5 No.20 8 / 32 2010 5 No.20 9 / 32 2010 5 No.20 10 / 32 2010 5 No.20 11 / 32
（事務局）
10. JR JR JR OK - 1 - JR.5 JR JR JR JR JR - 2 - NO1 IT 1.5 F PR - 3 - PR - 4 - JR - 5 - - 6 - - 7 - 8 45 JR 11-8 - 5 120 2 40 14 28 20 28 14 20-9 - 45 JR - 10 - JR JR JR JR JR JR JR JR JR JR JR JR JR JR
152 NPO,,
151 NPO NPO NPO FM NPO NPO 152 NPO,, NPO 153 154 NPO NPO 155 156 NPO FAX , NPO 157 158 NPO NPO OB NPO NPO NPO NPO, NPO 159,.,,,,, 160 NPO, NPO NPO NPO NPO PR NPO 161 162 NPO NPO NPO NPO NPO NPO NPO NPO
カテゴリ変数と独立性の検定
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 =
Excel2000
Microsoft Excel 2000 Excel Excel ( )m...1...1...1 Shift...2 Shift...2...3...4...6...7...8...10...11...12...13...14...16...17...19...19...20 Excel B2 E5 E5 1/21 Shift B2 Shift E5 Shift B2 Shift Shift 2/21
untitled
1 2 3 4 5 6 7 8 9 10 40% 2000 11 12 13 o o o o o o v v o v v v o v o v o o o o o o o o o o o o v o o o o o v o o v o o v v o o v o o v o o v o o o o o v o o o o o o o o o v 14 15 1980 16 17 18 19 20 8013%
untitled
1 ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) 2 ( ) 1 ( ) ( ) ( ) ( ) 3 ( ) a b ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) 4 ( ) ( ) ( ) ( ) ( ) ( ) < > 5 a b c d ( ) ( ) ( ) ( ) ( ) 18 73 ( ) ( ) a b 6 6 c ( ) (
t χ 2 F Q t χ 2 F 1 2 µ, σ 2 N(µ, σ 2 ) f(x µ, σ 2 ) = 1 ( exp (x ) µ)2 2πσ 2 2σ 2 0, N(0, 1) (100 α) z(α) t χ 2 *1 2.1 t (i)x N(µ, σ 2 ) x µ σ N(0, 1
t χ F Q t χ F µ, σ N(µ, σ ) f(x µ, σ ) = ( exp (x ) µ) πσ σ 0, N(0, ) (00 α) z(α) t χ *. t (i)x N(µ, σ ) x µ σ N(0, ) (ii)x,, x N(µ, σ ) x = x+ +x N(µ, σ ) (iii) (i),(ii) z = x µ N(0, ) σ N(0, ) ( 9 97.
「東京都子供・子育て支援総合計画」中間見直し版（案）第2章 子供と家庭をめぐる状況
1 (1) (2) (3) (4) (5) (6) (7) (8) 2 (1) (2) (3) (4) (5) (6) (7) 10,000 100% 8,000 78.7% 78.1% 79.3% 78.3% 74.1% 75.4% 73.2% 80% 6,000 46.6% 47.5% 50.9% 51.5% 49.9% 51.8% 52.2% 60% 4,000 2,000 3,713
CKS
3331 Arts Chiyoda TELFAX E-MAIL: pr URL: http://www.3331.jp 3331 Arts Chiyoda TELFAX E-MAIL: pr URL: http://www.3331.jp 3331 Arts Chiyoda TELFAX E-MAIL: pr URL: http://www.3331.jp 3331 Arts Chiyoda TELFAX
1 ( ) ( )
1 ( ) ( ) 1 2 3 4 ( ) ( ). ( ) ( ) (1 ) 1 () 5 6 7 8 9 10 ( ) 11 12 ! 13 14 P.7 15 16 17 ( ) (P.47) 17 (P.117) 1116 (P.80) 10 (P.66) ( ) 16 (P.114) 12 (P.91) (P.42) (P.20) (P.23) ( ) 18 (P.125) (P.25)
報告書
1 2 3 4 5 6 7 or 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2.65 2.45 2.31 2.30 2.29 1.95 1.79 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 60 55 60 75 25 23 6064 65 60 1015
2 94.3 91.3 5.1 7.5 0.0 0.0 0.1 0.5 0.6 0.1 0.1 0.4 21.4% 15.8% 14.8% 15.0% 16.0% 16.5% 0.5% 16.1% 15.2% 16.9% 15.7% 17.1% 18.6% 0.4% 21.4% 15.8% 14.8
15 7 8,000 15 4 1 0 5 15 4 2 15 10 1 15 4 1 6 11 4,500 3,500 16 26 35 27 34 16 2 19 16 2 24 16 3 15 1 2 94.3 91.3 5.1 7.5 0.0 0.0 0.1 0.5 0.6 0.1 0.1 0.4 21.4% 15.8% 14.8% 15.0% 16.0% 16.5% 0.5% 16.1%
年計グラフ作成システム
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
1 2 3 4 5 6 140,000 70,000 116,797 120,000 111,322 114,180 60,000 103,204 114,395 115,479 100,000 91,713 106,508 50,000 98,664 40,691 37,846 38,941 80,000 40,000 85,214 34,974 32,328 (29,256 60,000 27,383
新入_本文.smd
52 28 220 28 4 1 017-777-1511 2 2 8 2 9 8 9 47.2% 12.8% 11.5% 6.0% 4 2 (49.6%)(13.0%) (14.7%) (7.4%)(8.4%) (52.3%)(9.1%) (11.4%) (10.0%) 33.0% 23.4% 15.6% 9.6% (26.0%) (18.3%) (46.5%) (30.0%) (20.0%) 2
untitled
21 1 28 () 21 2 10 () 2,000 814 40.7% 65 4 2 30.61 19.23 19.0 7074 105 12.9% 75 121 14.9% 6569 107 13.1% 4 0.5% 6064 99 12.2% 19 0 0.0% 2029 36 4.4% 5559 67 8.2% 3039 107 13.1% 4049 102 12.5% 5054 66 8.1%
( ) () ( ) 12/6
( ) () ( ) 12/6 ( ) 21 20 167 167 25 25 36.08 36.65 0.57 52 73 51 99 142 36.65 138 36.08 2500 99 5000 99 51 158 51 51 52 52 73 110 158 165 165 99 166 48.04 138 36.08 28 11.96 PR 51 52 158 99 52 51 73 52
PR
1-4 29 1-13 41 1-23 43 1-39 29 PR 1-42 28 1-46 52 1-49 47 1-51 40 1-64 52 1-66 58 1-72 28 1-74 48 1-81 29 1-93 27 1-95 30 1-97 39 1-98 40 1-100 34 2-1 41 2-5 47 2-105 38 2-108 44 2-110 55 2-111 44 2-114
(iii) x, x N(µ, ) z = x µ () N(0, ) () 0 (y,, y 0 ) (σ = 6) *3 0 y y 2 y 3 y 4 y 5 y 6 y 7 y 8 y 9 y ( ) *4 H 0 : µ
t 2 Armitage t t t χ 2 F χ 2 F 2 µ, N(µ, ) f(x µ, ) = ( ) exp (x µ)2 2πσ 2 2 0, N(0, ) (00 α) z(α) t * 2. t (i)x N(µ, ) x µ σ N(0, ) 2 (ii)x,, x N(µ, ) x = x + +x ( N µ, σ2 ) (iii) (i),(ii) x,, x N(µ,
OR 2 Excel 2 3.. 4. OK. 1a: Excel2007 Office. Excel2003 1.. 1b. 2.. 3. OK. 2.,,. ツール アドイン 1b: Excel2003 :,.,.,.,,,.,,. 1. Excel2003.
OR 2 Excel 1 2 2.1 Excel.,. 2.2, x mathematical programming optimization problem, OR 1., 1 : f(x) h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,..., l, f(x) h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,...,
( ) 47.9 (22.3 )
1993 3 1870 1266 67.7 1992 12 (96.0 ) 20 1.4 30 5.5 40 29.0 50 33.0 60 27.6 40 60 40 60 1 40-60 40-50 40 20 70 ( ) 47.9 (22.3 ) 70.2 15.6 100.0 18 18 2 63.0 11.4 69.0 10.1 10 73.8 20 42.5 (72.6 ) (47.8
<8D4C95F182B182B382A2388C8E8D862E706466>
21 EventInvitationLife TaxOther 1 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 16 Web-site http://www.city.kosai.shizuoka.jp/ E-mail public@city.kosai.shizuoka.jp 6
untitled
9 8 29 () 9 8 29 () 9 11 30 () 10 2 14 () 3 10 7 24 () 10 10 9 () 10 8 2 10 11 14 () 10 12 25 () 40 50 100 1953 11 2 26 11 11 3 29 11 6 10 11 1 12 15 2 3 12 12 10 6 12 4 8 5 55 60 100 100 2 25 15 7 29
?
240-8501 79-2 Email: nakamoto@ynu.ac.jp 1 3 1.1...................................... 3 1.2?................................. 6 1.3..................................... 8 1.4.......................................
1.0% 53.7% 45.3% 70 20.4% 0.9% 20 9.9% 30 15.9% 60 20.0% 40 19.2% 50 13.7% 21.0% 1.1% 3.0% 5.2% 16.1% 35.3% 0.9% 17.3% 10.6% 13.3% 1.2% 4.8% 20.3% 49.8% 1.2% 12.6% 9.6% 13.4% 28.8% 14.5% 19.8% 1.0% 1 2.7%
untitled
83 01 01 02 07 09 10 170,356 114,020 56,335 40,058 16,276 4,036 221 20,091 33 461 19,663 7,472 12,190 331 12,521 202,821 135,705 67,115 43,675 23,440 3,460 450 26,451 537 487 26,501 9,801 16,700 68
museum data no74
74 Museum Data No.74 (2008.12) 1 2 Museum Data No.74 (2008.12) Museum Data No.74 (2008.12) 3 4 Museum Data No.74 (2008.12) Museum Data No.74 (2008.12) 5 6 Museum Data No.74 (2008.12) Museum Data No.74
5989-1441JA.qxd
Agilent Agilent Data Sheet 2 3 4 5 6 7 8 9 www.agilent.co.jp/find/jpconnectivity 10 www.agilent.co.jp/find/ jpconnectivity www.agilent.co.jp/find/adn 11 192-8510 9-1 9:00-19:00 12:00-13:00 FAX E-mail Web
橡Taro13-EXCEL統計学.PDF
Excel 4.1 4.1.1 1 X n X,X, 1,Xn X=X X X /n 1 n Excel AVERAGE =AVERAGE Excel MEDIAN 3 =MEDIAN Excel MODE =MODE 4.1. 1 Excel MAX MIN =MAX MIN n X,X,,X X 4-1 1 n V X1-X + X-X + + Xn-X V= n 0 0 Excel VARP
株主通信：第16期 中間報告書
9 1 20,000 15,000 10,000 5,000 2007/4 2008/4 2009/4 2010/4 2011/4 2012/4 2013/4 01 02 2 3 03 04 4 05 06 5 133,362 206,945 344,360 363,936 67,583 128,114 819 18,583 412,477 846,445 164,935 422,265 1,433,645
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
untitled
...1...3 -... 3 -... 3...5 -... 5 -... 5 -... 6 -... 7 -... 7 -... 7 -... 10 -... 17 -... 17 -... 18 -... 20 -... 21 1 TEL 2 3 4 ) ) 5 6 7 8 9 10 11 () (4) () (4) () () 730-0042730-8586 730-0042 730-0042730-8586
: : : : ) ) 1. d ij f i e i x i v j m a ij m f ij n x i =
1 1980 1) 1 2 3 19721960 1965 2) 1999 1 69 1980 1972: 55 1999: 179 2041999: 210 211 1999: 211 3 2003 1987 92 97 3) 1960 1965 1970 1985 1990 1995 4) 1. d ij f i e i x i v j m a ij m f ij n x i = n d ij
統計学のポイント整理
.. 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!
( )/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
ii : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 27 (1) Excel : : : : : : : : : : : : : : : : : : : : : :
i 2006. 4. 11 Excel JMP 0 1 1 (ICC) 2 1.1 2 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 2 (1) : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : :
Microsoft Word - 2015随時手引き(工事)
27 28 1/18 27 5 7 29 1 2 27 28 2/18 3/18 e-mail 27 28 4/18 (CD-R DVD-R) 29 3 31 5/18 3 3 3 1 3 1 3 3 3 6/18 7/18 1 3 2 3 A4 Excel (CD-R DVD-R) 例 : 新 規 ( 工 事 ) 都 市 づくり 建 設.xls 新 規 登 録 の 場 合 09998 8/18 9/18
1 -, XX Total Fertility Rate 1 2
2005 3 No. REGION- 10 1 -, XX 10 2 3 4 Total Fertility Rate 1 http://www.kyoto-su.ac.jp/project/orc/econ-public/region/yamada/pdf/future-pop.xls 2 http://www.stat.go.jp/data/jinsui/2003np/zuhyou/05k3f-1.xls
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
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,
* 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
