(
|
|
- ひろと にいだ
- 5 years ago
- Views:
Transcription
1 2 Web Multivariate/index.html
2 ( (
3 : RAND() (.xlsx) RAND() 2.1 Microsoft Excel 2007 Sheet1 RAND().xlsx Excel Excel URL( B3 = RAND() (2.1)
4 RAND Enter RAND() B RAND() (1) B3 Shift B12 (2) (3) (4) (5) RAND() F9 F9 2.2: RAND() (.xlsx) RAND() x 0 < x < 1 (0, 1) 0 x 1 [0, 1] 0 < x 1 (0, 1] RAND() (0, 1) 27
5 : 2.4: (.xlsx) RAND() =17 15 RAND() [1] Excel Excel VBA(Visual Basic for Application) Excel VBA???? IX, IY, IZ [1, 30268], [1, 30306], [1, 30322]
6 4 2 IX = MOD(171 IX, 30269) (2.2) IY = MOD(172 IY, 30307) (2.3) IZ = MOD(170 IZ, 30323) (2.4) RAN DOM = MOD(IX/ IY/ IZ/30323, 1) (2.5) 30269, 30307, MOD(I, J) I J (2.2) Excel B B6 (2.2) B5 B B B D 2.6 IX B5 Shift Ctrl (2) (3) (7) IX (4) D5 IX 2.5 E D E5 E30271 D G5 E IX (2.3) (2.4) , IX, IY, IZ 3 7 [2] , 30306, (= ) (2.5) IX, IY, IZ 1 IX/30269, IY/30307, IZ/ < IX/ IY/ IZ/30323 < 3 (2.6)
7 : RAND() IX (IX.xlsx) 2.6: IX (0, 3) 27 IX/ IY/ IZ/ (0, 1), (1, 2), (2, 3) (0, 1) x, y a, b, c, d 0 < a, c < x, 0 < b, d < y a x + b y = 1 + c x + d y (2.7)
8 6 2 c/x + d/y a/x + b/y 1 (b d) x y = x (a c) (2.8) x, y b d < y 0 0 (2.5) RANDOM (0, 1) (a) (2.2) (2.4) IX/30269+IY/30307+IZ/30323 (0, 3] (0, ], (0.0001, ] IX/ IY/ IZ/30323 (0, 1], (1, 2], (2, 3] 3 (0, 1] 2.7 (b) (2.5) RANDOM RAND() (0, 1) 7 1 RAND() 2.8 (2.5) RANDOM (2.2) (2.5) i R 1i R 1i R 1i = 1 nv 2 e n (r 1j r)(r ij r) (2.9) j=1 r ij i j r, v 2 e n = 1000 v 2 e v 2 e = 1 n 2 1 n i=1 n (r ij r) 2 (2.10) RAND() j=1 Excel RAND() 2.1, 2.2 RAND() Excel RAND() (2.2) (2.4) IX, IY, IZ RAND() Excel =RAND() (0, 1)
9 : RAND() 2.8: RAND() RAND() 1000 B4 D4 1 IF(a, b, c) a b c B7 A IF A7 [0.0101, ] A % [0.925, 1.053] Excel RAND()
10 :.xlsx 2.10: ( p p 1 6 {2, 4, 6}
11 2.2. ( RAND() RAND() 0 1 RAND() 2.11 B7 B16 = INT(2 RAND()) (2.11) 2 RAND() (0, 2) INT() 1 0 B7 B16 10 B4 = COUNT(B7 : B16) (2.12) B7 B16 C19 = COUNTIF($B$7 : $B$16, B19)/$B$4 (2.13) B7 B16 B19 B7, B16, B4 $B$7 $B$16 $B$4 $ (2.13) C20 B7, B16, B4 B19 $ (2.13) B19 B20 C (1) (2) (3) (4)2-D (1) (2) (3) ( B19 B20 (4)(5) 2.11
12 : (n=10)( n=10.xlsx) 2.12: (n=10)
13 2.2. ( : (n=10) 2.14: (n=10) B7 B16 INT(2*RAND()) B7 B1006 B4 COUNT(B7:B16) COUNT(B7:B1006) n
14 12 2 F19, F : (n=1000)( n=1000.xlsx) 2.16: (n=1000) Excel 1 6 1/6 2.19
15 2.2. ( : (n=1000) 2.18: (n=1000) = INT(6 RAND()) + 1 (2.14) 6*RAND() (0, 6) INT() B7 B5006 B4 F19 F /6
16 : (n=5000)( n=5000.xlsx) f(x) = 1 2πσ exp ( ) (x µ)2 2σ 2 (2.15) µ σ µ = 0, σ = 1 f(x) = 1 ) exp ( x2 2π 2 F (x) f() F (x) = x (2.16) f(y)dy (2.17) 2.20 x B4 x -4 B5 = ROUND(B , 1) (2.18)
17 2.2. ( 15 ROUND(a, b) a b+1 B (10) = (2) (2.19) (i) i (2) = (10) = (10) (2.20) (10) 2.20: (.xlsx) 2.20 C4 = NORMDIST(B4, 0, 1, FALSE) (2.21) NORMDIST(a, b, c, d) d FALSE b, c x = a b = 0, c = 1 (2.21) B4
18 : 2.22: 2.21 (1) (2) (3) (4) NORMDIST(x, 0, 1,TRUE) 2.22
19 2.2. ( 17 (2.17) F (x) f(x) (a) x = 1.81 x x = 1.81 (b) F (x) : (n=5000) n=5000.xlsx 2.23 = NORMSINV(RAND()) (2.22)
20 18 2 NORMSINV() RAND() (0, 1) 2.24 RAND() F (x) NORMSINV() x RAND() (0, 1) 0.5 RAND() NORMSINV() 0 0 x RAND() 0 1 NORMSINV() x 2.24: 2.23 = ROUND(NORMSINV(RAND()), 0) (2.23)
21 2.2. ( G19 = NORMSDIST(E ) NORMSDIST(E19 0.5) (2.24) 3 ± 0.5 NORMSDIST(x) x G (1) (2) (3) (4) (5) (1) (2) (3) (4) (5) 2.25 Excel.xlsx 2.25:.xlsx
22 : 2.27: 2.3 ( x n n q x = q/n n
23 2.3. ( Excel 2.28 n = 2 q q/n 1 i q i x i = q i /n 2.28 N = 5000 x i, i = 1, 2,, N x i AVERAGE() B10 AVERAGE(B7:B8) B7, B8 i j x ij i x i n x i = 1 n j=1 x ij (2.25) B x x x = 1 N N x i (2.26) i=1 C12 ve 2 VAR(B10:GJI10) v 2 e v 2 e = 1 N 1 N (x i x) 2 (2.27) i= C15 B10 BJI B15 (=0) C4 (=5000) 0 NORMDIST(x, µ, σ,true) (2.17) f() (2.15) µ, σ B12, C x ve 2 ve 2 NORMDIST(x , x, ve,true)-normdist(x , x, ve,true) 2 x ± 0.25 TRUE NORMDIST(x, µ, σ,true) x FALSE x 2.30 x i = 0 1 x i = 0.5
24 :, n=2 n=2.xlsx 2.29: /, n=2 n=2.xlsx 2.30: / n=2 n n= x i n=10
25 2.3. ( :, n=10 n=10.xlsx 2.32: /, n=10 n=10.xlsx f(x) = λe λx (x 0) (2.28)
26 : / n=10 [0, x] F (x) F (x) = x λe λx 0 = [ e λx] x 0 = 1 e λx (2.29) 2.24 F (x) RAND() (0, 1) F (x) RAND() = 1 e λx (2.30) x = 1 ln(1 RAND()) (2.31) λ 1-RAND() (0, 1) RAND() (0, 1) x = 1 ln(rand()) (2.32) λ 2.34 B7 (2.32) B4 λ = 2 B C14 B9 GJI [0, 0.1) n=
27 2.3. ( :.xlsx 2.35:, n=10.xlsx 2.36: n= n=
28 :, n=4 n=4.xlsx 2.38: /, n=4 n=4.xlsx 2.39: / n=4
29 : / n=100 n=100.xlsx 2.4 x i, i = 1, 2,, n ve 2 s2 ve 2 1 n = (x i x) 2 n 1 i=1 s 2 = 1 n (x i x) 2 (2.33) n i=1 ve 2 s2 n 1 n Excel VAR() (2.27) ve 2 s B9 B18 µ = 0 σ 2 = 4 10 µ = 0 σ 2 = 4 B9 B18 C9 C18 µ = 0 x i 2 (x i µ) 2 B20 C9 C18 B21 B22
30 B24 C26 σ 2 = 4 B :.xlsx 2.42:
31 29 [1] B. A. Wichmann and I. D. Hill, Algorithm AS 183: An Efficient and Portable Pseudo-Random Number Generator. Journal of the Royal Statistical Society. Series C (Applied Statistics), Vol. 31, No. 2, pp , [2] B. A. Wichmann and I. D. Hill, Correction: Algorithm AS 183: An Efficient and Portable Pseudo-Random Number Generator. Journal of the Royal Statistical Society. Series C (Applied Statistics), Vol. 33, No. 1, p. 123, 1984.
32 30 (0, 1), 2 [0, 1], 2 2, 15 AVERAGE(), 21 COUNTIF(), 9 COUNT(), 9 Excel VBA, 3 INT(), 9 NORMDIST(), 15, 16, 21 NORMSDIST(), 19 NORMSINV(), 18 RAND(), 1 RAND(), 4 ROUND(), 15 VAR(), 21, 2, 2, 14, 18, 14, 2, 18, 2, 2, 8, 10, 9, 12, 1, 2, 8, 6, 8, 15, 8, 14, 27, 1, 8, 12, 2, 21, 8, 2 $, 9, 2, 19, 14, 18, 17, 14, 27, 27
33 31, 6, 21, 27, 21, 14, 21, 9, 19, 27, 27, 27, 3, 15, 2, 9, 2, 2
34 32 3, Web
( 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 informationExcel97関数編
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 informationuntitled
1 BASIC (Beginner s All-purpose Symbolic Instruction Code) EXCEL BASIC EXCEL EXCEL VBA (Visual Basic for Applications) 2 3 1.1 Excel Excel Excel Check Point 1. 2. 1.1.1 Sheet1 A Sheet2 Sheet A A10 4 1
More information1 Microsoft Office Power Point
\n Title 情 報 教 育 におけるグループ 課 題 の 試 み Author(s) 五 月 女, 仁 子, Soutome, Hiroko Citation 商 経 論 叢, 48(3): 1-12 Date 2013-03-20 Type Departmental Bulletin Paper Rights publisher KANAGAWA University Repository
More information(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 informationExcel 2007 Excel 2007 "Excel " " " " Excel 2003 Excel 2007 " "" Excel Web ""
Microsoft Office Excel 2007 Microsoft Office Excel 2007 Microsoft Office Excel 2007 Office Excel Office Excel Office Excel Excel 2007 Excel 2007 Excel 2007 "Excel " " " " Excel 2003 Excel 2007 " "" Excel
More information2 G(k) e ikx = (ik) n x n n! n=0 (k ) ( ) X n = ( i) n n k n G(k) k=0 F (k) ln G(k) = ln e ikx n κ n F (k) = F (k) (ik) n n= n! κ n κ n = ( i) n n k n
. X {x, x 2, x 3,... x n } X X {, 2, 3, 4, 5, 6} X x i P i. 0 P i 2. n P i = 3. P (i ω) = i ω P i P 3 {x, x 2, x 3,... x n } ω P i = 6 X f(x) f(x) X n n f(x i )P i n x n i P i X n 2 G(k) e ikx = (ik) n
More informationt χ 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.
More informationPowerPoint 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]
More information情報科学概論 第1回資料
1. Excel (C) Hiroshi Pen Fujimori 1 2. (Excel) 2.1 Excel : 2.2Excel Excel (C) Hiroshi Pen Fujimori 2 256 (IV) :C (C 65536 B4 :2 (2 A3 Excel (C) Hiroshi Pen Fujimori 3 Tips: (1) B3 (2) (*1) (3) (4)Word
More information: : : : ) ) 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
More information15 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 informationii 3.,. 4. F. (), ,,. 8.,. 1. (75%) (25%) =7 20, =7 21 (. ). 1.,, (). 3.,. 1. ().,.,.,.,.,. () (12 )., (), 0. 2., 1., 0,.
24(2012) (1 C106) 4 11 (2 C206) 4 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 informationExcel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. このサンプルページの内容は, 初版 1 刷発行時のものです.
Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. http://www.morikita.co.jp/books/mid/009631 このサンプルページの内容は, 初版 1 刷発行時のものです. Excel URL http://www.morikita.co.jp/books/mid/009631 i Microsoft Windows
More informationii
i 2013 5 143 5.1...................................... 143 5.2.................................. 144 5.3....................................... 148 5.4.................................. 153 5.5...................................
More information( ) ( ) 1729 (, 2016:17) = = (1) 1 1
1729 1 2016 10 28 1 1729 1111 1111 1729 (1887 1920) (1877 1947) 1729 (, 2016:17) 12 3 1728 9 3 729 1729 = 12 3 + 1 3 = 10 3 + 9 3 (1) 1 1 2 1729 1729 19 13 7 = 1729 = 12 3 + 1 3 = 10 3 + 9 3 13 7 = 91
More informationi I Excel iii Excel Excel Excel
Excel i I Excel iii 1 1 2 Excel 2 2.1..................................... 2 2.2 Excel................................................ 2 2.3 Excel................................................ 4 2.4..............................................
More informationuntitled
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 informationSO(2)
TOP URL http://amonphys.web.fc2.com/ 1 12 3 12.1.................................. 3 12.2.......................... 4 12.3............................. 5 12.4 SO(2).................................. 6
More information橡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
More informationII (No.2) 2 4,.. (1) (cm) (2) (cm) , (
II (No.1) 1 x 1, x 2,..., x µ = 1 V = 1 k=1 x k (x k µ) 2 k=1 σ = V. V = σ 2 = 1 x 2 k µ 2 k=1 1 µ, V σ. (1) 4, 7, 3, 1, 9, 6 (2) 14, 17, 13, 11, 19, 16 (3) 12, 21, 9, 3, 27, 18 (4) 27.2, 29.3, 29.1, 26.0,
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
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 information68 A mm 1/10 A. (a) (b) A.: (a) A.3 A.4 1 1
67 A Section A.1 0 1 0 1 Balmer 7 9 1 0.1 0.01 1 9 3 10:09 6 A.1: A.1 1 10 9 68 A 10 9 10 9 1 10 9 10 1 mm 1/10 A. (a) (b) A.: (a) A.3 A.4 1 1 A.1. 69 5 1 10 15 3 40 0 0 ¾ ¾ É f Á ½ j 30 A.3: A.4: 1/10
More informationuntitled
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 information151021slide.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 informationExcel IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows XP IT-Excel2007_dl Windows XP IT- Excel 200
Excel 2007 Excel 2007 Office Professional 2007 1 90 Web http://softpress.nikkeibp.co.jp/ "BP " 6 1 Excel 2007 2 IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows
More informationI
I io@hiroshima-u.ac.jp 27 6 A A. /a δx = lim a + a exp π x2 a 2 = lim a + a = lim a + a exp a 2 π 2 x 2 + a 2 2 x a x = lim a + a Sic a x = lim a + a Rect a Gaussia Loretzia Bilateral expoetial Normalized
More informationCVaR
CVaR 20 4 24 3 24 1 31 ,.,.,. Markowitz,., (Value-at-Risk, VaR) (Conditional Value-at-Risk, CVaR). VaR, CVaR VaR. CVaR, CVaR. CVaR,,.,.,,,.,,. 1 5 2 VaR CVaR 6 2.1................................................
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 information5 Armitage x 1,, x n y i = 10x i + 3 y i = log x i {x i } {y i } 1.2 n i i x ij i j y ij, z ij i j 2 1 y = a x + b ( cm) x ij (i j )
5 Armitage. x,, x n y i = 0x i + 3 y i = log x i x i y i.2 n i i x ij i j y ij, z ij i j 2 y = a x + b 2 2. ( cm) x ij (i j ) (i) x, x 2 σ 2 x,, σ 2 x,2 σ x,, σ x,2 t t x * (ii) (i) m y ij = x ij /00 y
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 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 informationii 3.,. 4. F. ( ), ,,. 8.,. 1. (75% ) (25% ) =7 24, =7 25, =7 26 (. ). 1.,, ( ). 3.,...,.,.,.,.,. ( ) (1 2 )., ( ), 0., 1., 0,.
(1 C205) 4 10 (2 C206) 4 11 (2 B202) 4 12 25(2013) http://www.math.is.tohoku.ac.jp/~obata,.,,,..,,. 1. 2. 3. 4. 5. 6. 7. 8. 1., 2007 ( ).,. 2. P. G., 1995. 3. J. C., 1988. 1... 2.,,. ii 3.,. 4. F. ( ),..
More informationPart () () Γ Part ,
Contents a 6 6 6 6 6 6 6 7 7. 8.. 8.. 8.3. 8 Part. 9. 9.. 9.. 3. 3.. 3.. 3 4. 5 4.. 5 4.. 9 4.3. 3 Part. 6 5. () 6 5.. () 7 5.. 9 5.3. Γ 3 6. 3 6.. 3 6.. 3 6.3. 33 Part 3. 34 7. 34 7.. 34 7.. 34 8. 35
More information2 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 information1 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 informationExcel基礎講座テキスト-表紙と目次v1.3.doc
Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation < > Excel Excel Microsoft Excel = 11 11 1 G11 1 < > Excel Word Excel Sheet1Sheet2Sheet3 OK Sheet2 Sheet3 2 Word Excel Book1.
More informationコンピュータ概論
4.1 For Check Point 1. For 2. 4.1.1 For (For) For = To Step (Next) 4.1.1 Next 4.1.1 4.1.2 1 i 10 For Next Cells(i,1) Cells(1, 1) Cells(2, 1) Cells(10, 1) 4.1.2 50 1. 2 1 10 3. 0 360 10 sin() 4.1.2 For
More informationohp.mgp
2012/10/09 A/B -- Excel -- !! B video Note-PC Network skype Login Windows Update Web CST Portal Excel Excel ( / ( / /? ( ( [ / /etc..], = ( Excel : (Excel : ( $ [ 1] Excel [ 2] [ 3] Lookup [ 1] [ 2] Excel..
More informationad bc A A A = ad bc ( d ) b c a n A n A n A A det A A ( ) a b A = c d det A = ad bc σ {,,,, n} {,,, } {,,, } {,,, } ( ) σ = σ() = σ() = n sign σ sign(
I n n A AX = I, YA = I () n XY A () X = IX = (YA)X = Y(AX) = YI = Y X Y () XY A A AB AB BA (AB)(B A ) = A(BB )A = AA = I (BA)(A B ) = B(AA )B = BB = I (AB) = B A (BA) = A B A B A = B = 5 5 A B AB BA A
More information13 Excel VBA PowerPoint, Word Excel Excel Excel Excel VBA VBA VBA Visual Basic for Application Microsoft Office Visual Basic Visual Basic VBA Excel Ac
\n Title Excel 実 技 試 験 の 採 点 プログラムの 実 施 について Author(s) 五 月 女, 仁 子 ; Soutome, Hiroko Citation 商 経 論 叢, 46(3): 13-24 Date 2011-02-28 Type Departmental Bulletin Paper Rights publisher KANAGAWA University
More informationdvi
2017 65 2 185 200 2017 1 2 2016 12 28 2017 5 17 5 24 PITCHf/x PITCHf/x PITCHf/x MLB 2014 PITCHf/x 1. 1 223 8522 3 14 1 2 223 8522 3 14 1 186 65 2 2017 PITCHf/x 1.1 PITCHf/x PITCHf/x SPORTVISION MLB 30
More informationp = mv p x > h/4π λ = h p m v Ψ 2 Ψ
II p = mv p x > h/4π λ = h p m v Ψ 2 Ψ Ψ Ψ 2 0 x P'(x) m d 2 x = mω 2 x = kx = F(x) dt 2 x = cos(ωt + φ) mω 2 = k ω = m k v = dx = -ωsin(ωt + φ) dt = d 2 x dt 2 0 y v θ P(x,y) θ = ωt + φ ν = ω [Hz] 2π
More informationuntitled
yoshi@image.med.osaka-u.ac.jp http://www.image.med.osaka-u.ac.jp/member/yoshi/ II Excel, Mathematica Mathematica Osaka Electro-Communication University (2007 Apr) 09849-31503-64015-30704-18799-390 http://www.image.med.osaka-u.ac.jp/member/yoshi/
More information(2 X Poisso P (λ ϕ X (t = E[e itx ] = k= itk λk e k! e λ = (e it λ k e λ = e eitλ e λ = e λ(eit 1. k! k= 6.7 X N(, 1 ϕ X (t = e 1 2 t2 : Cauchy ϕ X (t
6 6.1 6.1 (1 Z ( X = e Z, Y = Im Z ( Z = X + iy, i = 1 (2 Z E[ e Z ] < E[ Im Z ] < Z E[Z] = E[e Z] + ie[im Z] 6.2 Z E[Z] E[ Z ] : E[ Z ] < e Z Z, Im Z Z E[Z] α = E[Z], Z = Z Z 1 {Z } E[Z] = α = α [ α ]
More information(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(µ,
More information1. A0 A B A0 A : A1,...,A5 B : B1,...,B
1. A0 A B A0 A : A1,...,A5 B : B1,...,B12 2. 3. 4. 5. A0 A, B Z Z m, n Z m n m, n A m, n B m=n (1) A, B (2) A B = A B = Z/ π : Z Z/ (3) A B Z/ (4) Z/ A, B (5) f : Z Z f(n) = n f = g π g : Z/ Z A, B (6)
More information橡scb79h16y08.PDF
S C B 05 06 04 10 29 05 1990 05 0.1 90 05 0.2 06 90 05 06 06 04 04 10 1.9 90 12 2.0 13 10 10 18.0 16.0 6.1 1 10 1.7 10 18.5 0.8 03 04 1 04 42.9 10 20.5 10 4.2 0.7 0.2 0.6 01 00 100 97 11 102.5 04 91.5
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³ÎΨÏÀ
2017 12 12 Makoto Nakashima 2017 12 12 1 / 22 2.1. C, D π- C, D. A 1, A 2 C A 1 A 2 C A 3, A 4 D A 1 A 2 D Makoto Nakashima 2017 12 12 2 / 22 . (,, L p - ). Makoto Nakashima 2017 12 12 3 / 22 . (,, L p
More information1. 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 information1 Tokyo Daily Rainfall (mm) Days (mm)
( ) r-taka@maritime.kobe-u.ac.jp 1 Tokyo Daily Rainfall (mm) 0 100 200 300 0 10000 20000 30000 40000 50000 Days (mm) 1876 1 1 2013 12 31 Tokyo, 1876 Daily Rainfall (mm) 0 50 100 150 0 100 200 300 Tokyo,
More information1. A0 A B A0 A : A1,...,A5 B : B1,...,B
1. A0 A B A0 A : A1,...,A5 B : B1,...,B12 2. 3. 4. 5. A0 A B f : A B 4 (i) f (ii) f (iii) C 2 g, h: C A f g = f h g = h (iv) C 2 g, h: B C g f = h f g = h 4 (1) (i) (iii) (2) (iii) (i) (3) (ii) (iv) (4)
More information) ] [ h m x + y + + V x) φ = Eφ 1) z E = i h t 13) x << 1) N n n= = N N + 1) 14) N n n= = N N + 1)N + 1) 6 15) N n 3 n= = 1 4 N N + 1) 16) N n 4
1. k λ ν ω T v p v g k = π λ ω = πν = π T v p = λν = ω k v g = dω dk 1) ) 3) 4). p = hk = h λ 5) E = hν = hω 6) h = h π 7) h =6.6618 1 34 J sec) hc=197.3 MeV fm = 197.3 kev pm= 197.3 ev nm = 1.97 1 3 ev
More informationMS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2
( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3
More informationuntitled
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 informationXX data 03.xls sheet(1) data 03.xls sheet(1) 2 1. n 1 2. m 1 3. O 11 O
1 5 2017 5 8 4 : website: email: http://www3.u-toyama.ac.jp/kkarato/ kkarato@eco.u-toyama.ac.jp 1 2 1.1............................. 2 1.2 IF.................................... 3 1.3...............................
More informationMS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2
( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3
More informationii : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 27 (1) Excel : : : : : : : : : : : : : : : : : : : : : :
i 2006. 4. 11 Excel JMP 0 1 1 (ICC) 2 1.1 2 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 2 (1) : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : :
More informationExcel 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医系の統計入門第 2 版 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. このサンプルページの内容は, 第 2 版 1 刷発行時のものです.
医系の統計入門第 2 版 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. http://www.morikita.co.jp/books/mid/009192 このサンプルページの内容は, 第 2 版 1 刷発行時のものです. i 2 t 1. 2. 3 2 3. 6 4. 7 5. n 2 ν 6. 2 7. 2003 ii 2 2013 10 iii 1987
More information1 (1) X = AB + AB, Y = C D + C D, Z = AD + AD P A, B, C, D P = (XY + X Y + X Y )(Y Z + Y Z + Y Z )(ZX + Z X + Z X ) (2) Q A, B, C, D Q = AB C D + AB C
平成 28 年度 10 月期入学 / 平成 29 年度 4 月期入学京都大学大学院情報学研究科修士課程システム科学専攻入学者選抜試験問題 専門科目 試験日時 : 平成 28 年 8 月 8 日 ( 月 ) 午後 1 時 00 分より同 4 時 00 分 問題冊子頁数 ( 表紙 中表紙 裏表紙を除いて ): 15 頁 選択科目 : 下記の科目のうち 2 科目を選択し解答すること 注意 : 論理回路 (3)
More informationwaseda2010a-jukaiki1-main.dvi
November, 2 Contents 6 2 8 3 3 3 32 32 33 5 34 34 6 35 35 7 4 R 2 7 4 4 9 42 42 2 43 44 2 5 : 2 5 5 23 52 52 23 53 53 23 54 24 6 24 6 6 26 62 62 26 63 t 27 7 27 7 7 28 72 72 28 73 36) 29 8 29 8 29 82 3
More information80 X 1, X 2,, X n ( λ ) λ P(X = x) = f (x; λ) = λx e λ, x = 0, 1, 2, x! l(λ) = n f (x i ; λ) = i=1 i=1 n λ x i e λ i=1 x i! = λ n i=1 x i e nλ n i=1 x
80 X 1, X 2,, X n ( λ ) λ P(X = x) = f (x; λ) = λx e λ, x = 0, 1, 2, x! l(λ) = n f (x i ; λ) = n λ x i e λ x i! = λ n x i e nλ n x i! n n log l(λ) = log(λ) x i nλ log( x i!) log l(λ) λ = 1 λ n x i n =
More informationuntitled
18 1 2,000,000 2,000,000 2007 2 2 2008 3 31 (1) 6 JCOSSAR 2007pp.57-642007.6. LCC (1) (2) 2 10mm 1020 14 12 10 8 6 4 40,50,60 2 0 1998 27.5 1995 1960 40 1) 2) 3) LCC LCC LCC 1 1) Vol.42No.5pp.29-322004.5.
More informationSAMA- SUKU-RU Contents p-adic families of Eisenstein series (modular form) Hecke Eisenstein Eisenstein p T
SAMA- SUKU-RU Contents 1. 1 2. 7.1. p-adic families of Eisenstein series 3 2.1. modular form Hecke 3 2.2. Eisenstein 5 2.3. Eisenstein p 7 3. 7.2. The projection to the ordinary part 9 3.1. The ordinary
More information目次
00D80020G 2004 3 ID POS 30 40 0 RFM i ... 2...2 2. ID POS...2 2.2...3 3...5 3....5 3.2...6 4...9 4....9 4.2...9 4.3...0 4.4...4 4.3....4 4.3.2...6 4.3.3...7 4.3.4...9 4.3.5...2 5...23 5....23 5.....23
More information09基礎分析講習会
データ解析の意味を理解しないでパソコンで計算して 序論 誤差解析 何のために も意味がない 以下の本でちゃんと勉強しよう R. A. Millikan ミリカン 水滴の蒸発 大学院生H. Fletcher 水滴を油滴に 博士論文単名 140の観測のうち49個除外 データ削除 実験データを正しく扱うために 化学同人編集部編 油滴実験 Regener がもともとThompsonの実験室(Cambridge
More information1 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 informationnm (T = K, p = kP a (1atm( )), 1bar = 10 5 P a = atm) 1 ( ) m / m
.1 1nm (T = 73.15K, p = 101.35kP a (1atm( )), 1bar = 10 5 P a = 0.9863atm) 1 ( ).413968 10 3 m 3 1 37. 1/3 3.34.414 10 3 m 3 6.0 10 3 = 3.7 (109 ) 3 (nm) 3 10 6 = 3.7 10 1 (nm) 3 = (3.34nm) 3 ( P = nrt,
More information1 I 1.1 ± e = = - = C C MKSA [m], [Kg] [s] [A] 1C 1A 1 MKSA 1C 1C +q q +q q 1
1 I 1.1 ± e = = - =1.602 10 19 C C MKA [m], [Kg] [s] [A] 1C 1A 1 MKA 1C 1C +q q +q q 1 1.1 r 1,2 q 1, q 2 r 12 2 q 1, q 2 2 F 12 = k q 1q 2 r 12 2 (1.1) k 2 k 2 ( r 1 r 2 ) ( r 2 r 1 ) q 1 q 2 (q 1 q 2
More informationFX ) 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 informationI A A441 : April 15, 2013 Version : 1.1 I Kawahira, Tomoki TA (Shigehiro, Yoshida )
I013 00-1 : April 15, 013 Version : 1.1 I Kawahira, Tomoki TA (Shigehiro, Yoshida) http://www.math.nagoya-u.ac.jp/~kawahira/courses/13s-tenbou.html pdf * 4 15 4 5 13 e πi = 1 5 0 5 7 3 4 6 3 6 10 6 17
More information2 7 V 7 {fx fx 3 } 8 P 3 {fx fx 3 } 9 V 9 {fx fx f x 2fx } V {fx fx f x 2fx + } V {{a n } {a n } a n+2 a n+ + a n n } 2 V 2 {{a n } {a n } a n+2 a n+
R 3 R n C n V??,?? k, l K x, y, z K n, i x + y + z x + y + z iv x V, x + x o x V v kx + y kx + ky vi k + lx kx + lx vii klx klx viii x x ii x + y y + x, V iii o K n, x K n, x + o x iv x K n, x + x o x
More information永田靖著「サンプルサイズの決め方」―補助資料― Excel による検出力とサンプルサイズの計算
2004. 4. 8 Excel 0 1 3 1 2 3.1 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 2 3.2 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : 3 3.3
More information<4D F736F F D B B83578B6594BB2D834A836F815B82D082C88C60202E646F63>
確率的手法による構造安全性の解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. http://www.morikita.co.jp/books/mid/55271 このサンプルページの内容は, 初版 1 刷発行当時のものです. i 25 7 ii Benjamin &Cornell Ang & Tang Schuëller 1973 1974 Ang Mathematica
More informationW u = u(x, t) u tt = a 2 u xx, a > 0 (1) D := {(x, t) : 0 x l, t 0} u (0, t) = 0, u (l, t) = 0, t 0 (2)
3 215 4 27 1 1 u u(x, t) u tt a 2 u xx, a > (1) D : {(x, t) : x, t } u (, t), u (, t), t (2) u(x, ) f(x), u(x, ) t 2, x (3) u(x, t) X(x)T (t) u (1) 1 T (t) a 2 T (t) X (x) X(x) α (2) T (t) αa 2 T (t) (4)
More informationDVIOUT-fujin
2005 Limit Distribution of Quantum Walks and Weyl Equation 2006 3 2 1 2 2 4 2.1...................... 4 2.2......................... 5 2.3..................... 6 3 8 3.1........... 8 3.2..........................
More informationp-sylow :
p-sylow :15114075 30 2 20 1 2 1.1................................... 2 1.2.................................. 2 1.3.................................. 3 2 3 2.1................................... 3 2.2................................
More informationA
A 2563 15 4 21 1 3 1.1................................................ 3 1.2............................................. 3 2 3 2.1......................................... 3 2.2............................................
More information,.,. NP,., ,.,,.,.,,, (PCA)...,,. Tipping and Bishop (1999) PCA. (PPCA)., (Ilin and Raiko, 2010). PPCA EM., , tatsukaw
,.,. NP,.,. 1 1.1.,.,,.,.,,,. 2. 1.1.1 (PCA)...,,. Tipping and Bishop (1999) PCA. (PPCA)., (Ilin and Raiko, 2010). PPCA EM., 152-8552 2-12-1, tatsukawa.m.aa@m.titech.ac.jp, 190-8562 10-3, mirai@ism.ac.jp
More information. ev=,604k m 3 Debye ɛ 0 kt e λ D = n e n e Ze 4 ln Λ ν ei = 5.6π / ɛ 0 m/ e kt e /3 ν ei v e H + +e H ev Saha x x = 3/ πme kt g i g e n
003...............................3 Debye................. 3.4................ 3 3 3 3. Larmor Cyclotron... 3 3................ 4 3.3.......... 4 3.3............ 4 3.3...... 4 3.3.3............ 5 3.4.........
More information橡CompSimmAllcpct.PDF
3 1 M dx 1 dx/ 1/ x P 0 (x) x dx x P 0 (x) x+dx P 0 (x+dx) x dx P 0 (x+dx)=p 0 (x)(1-dx/ dx/) x P 0 (x) P 0 (x+dx)=p 0 (x)(1-dx/ dx/) Tayler (dx) P 0 (x)+(dp 0 /dx)dx (dp 0 (x)/dx)dx= -P 0 (x) dx/
More informationst.dvi
9 3 5................................... 5............................. 5....................................... 5.................................. 7.........................................................................
More informationNo δs δs = r + δr r = δr (3) δs δs = r r = δr + u(r + δr, t) u(r, t) (4) δr = (δx, δy, δz) u i (r + δr, t) u i (r, t) = u i x j δx j (5) δs 2
No.2 1 2 2 δs δs = r + δr r = δr (3) δs δs = r r = δr + u(r + δr, t) u(r, t) (4) δr = (δx, δy, δz) u i (r + δr, t) u i (r, t) = u i δx j (5) δs 2 = δx i δx i + 2 u i δx i δx j = δs 2 + 2s ij δx i δx j
More information.. ( )T p T = p p = T () T x T N P (X < x T ) N = ( T ) N (2) ) N ( P (X x T ) N = T (3) T N P T N P 0
20 5 8..................................................2.....................................3 L.....................................4................................. 2 2. 3 2. (N ).........................................
More informationsec13.dvi
13 13.1 O r F R = m d 2 r dt 2 m r m = F = m r M M d2 R dt 2 = m d 2 r dt 2 = F = F (13.1) F O L = r p = m r ṙ dl dt = m ṙ ṙ + m r r = r (m r ) = r F N. (13.2) N N = R F 13.2 O ˆn ω L O r u u = ω r 1 1:
More information