ohp.mgp

Size: px
Start display at page:

Download "ohp.mgp"

Transcription

1 2012/10/09 A/B -- Excel --

2 !! B video Note-PC Network skype Login Windows Update Web CST Portal

3 Excel Excel ( / ( / /? ( ( [ / /etc..], = ( Excel : (Excel : ( $ [ 1] Excel [ 2] [ 3]

4 Lookup [ 1] [ 2] Excel.. tool Excel

5 (2012/10/09 (2012/10/02 excel CST Portal : QQQQ.xlsx (QQQQ : Excel sample xlsx (2012/10/09 excel CST Portal : QQQQ.xlsx (QQQQ : Excel sample xlsx

6 ( $ vs : : : ( ( cf. ( ( (Excel

7 / / Excel B2,C2,D2 B1,C1,D1 Excel A B C D Excel B ( B ( C1 111 =A1 :-2/ :0 C2 222 =A2 :-2/ :0 D1 111 =$A$1 A1

8 [ 1.1] : C3 F8 +3, +5 : D6 G11

9 [ 1.2] $ : C3 $F$8 F8 : D6 $F$8

10 [ 1.3] ( $ : C3 $F8 F 5 $ : D6 $F11 B4( B$4( $B4( $B$4(

11 [ 1.4] : B2:B8 : B2,B3,B4,B5,B6,B7,B8 ( B 2 8 F4:I4 : F4,G4,H4,I4 ( 2 F I C3:F5 : C3,D3,E3,F3,C4,D4,E4,F4,C5,D5,E5,F5! sheet1!c3 : sheet1 C3 sheet2!$f$7 : sheet2 $F$7

12 [ 2] Excel : SIN/COS/TAN, EXP/LOG, ABS, SQRT, PI, etc.. : SUM, AVERAGE, MEDIAN, MODE, etc..,,, : COUNT, COUNTIF, : LOOKUP, VLOOKUP : IF, AND, OR, NOT

13 [ 3] lookup lookup : VLOOKUP(, : ( HLOOKUP(, : ( lookup ( (x: y: =hlookup(4,$b$2:$i$3,2 16 ( 4 A B C D E F G H I 1 2 (x (y x y ( :.. (.. ( cf.

14 [ 4] : 2 x 2 4

15 [ 5] Excel Excel? Excel ( [Enter] ( i.e C6:E8 ( = { 1,2,3; 4,5,6; 7,8,9 } [Ctrl] + [Shift] + [Enter] ( [CSE] : [CSE] : =C6:E8+G6:I8 : MMULT =MMULT(C13:E15,G13:I15 : =$D$21*G20:I22 : MINVERSE =MINVERSE(C13:E15,G13:I15

16 [ 6] sample xlsx QQQQ.xlsx ( CST Portal [ ] sample (2012/10/02 (sample xlsx

17 [ 7] Excel excel COUNTIF : HLOOKUP/VLOOKUP : SUM : SQRT : T i ([ ] wikipedia: T i = 10(x i µ x σ x +50 σ x 0 µ x = 1 N N x i, σ x = i=1 1 N N (x i µ x 2 i=1

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

ohp.mgp

ohp.mgp A/B -- Excel (2) / skype -- 2011/05/24 !! Web Page http://edu-gw2.math.cst.nihon-u.ac.jp/~kurino : 2018 : Note-PC / DVD-Drive / USB Memory PC Note-PC Office MS-Office CST Portal (2012/04/24) (2012/04/17)

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

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

i I Excel iii Excel Excel Excel

i 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 information

Excel 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 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 information

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR () 601 1 () 265 OK 36.11.16 20 604 266 601 30.4.5 (1) 91621 3037 (2) 20-12.2 20-13 (3) ex. 2540-64 - LENCHAR 1 (1) vs. (2) (2) 605 50.2.13 41.4.27 10 10 40.3.17 (a)(c) 2 1 10 (a) (b) (c) 31 2 (a) (b) (c)

More information

ohp.mgp

ohp.mgp A/B -- /Hello, World -- / !! Web Page http://edu-gw2.math.cst.nihon-u.ac.jp/~kurino ( PC TA / / PC LAN ubuntu .. : + PC Note-PC ( : On-Line Web Page : http://edu-gw2.math.cst.nihon-u.ac.jp/~kurino : (?

More information

00 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.... 0........ 0 0 0 0 0 0 0 0 0 0..0..........0 0 0 0 0 0 0 0 0 0 0.... 0........ 0 0 0 0 0 0 0 0 0 0... 0...... 0... 0 0 0 0 0 0..0 0... 0 0 0 0 0.0.....0.

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

1 Microsoft Office Power Point

1 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

PowerPoint 2002

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]

More information

4 r r 2 a b c d a 66

4 r r 2 a b c d a 66 4 r r 2 a b c d a 66 b c d 3 4 j k l m d a a b c d e fghi r b c r n o p 4 67 4 d e f r g r h r i r j k l m n r o p r 68 2 r r 4 69 4 2 3 4 2 2 3 2 70 2 r r 4 2 7 4 2 3 2 3 a b a b c c 72 4 b a 4 a b 2

More information

Excel 2007 Excel 2007 "Excel " " " " Excel 2003 Excel 2007 " "" Excel Web ""

Excel 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 information

情報科学概論 第1回資料

情報科学概論 第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

(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

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

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-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 information

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-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 information

LCIExcel e Before Excel After Excel 1

LCIExcel e Before Excel After Excel 1 Excel 6 e Learning & Culture Innovation LCIExcel e Before Excel After Excel 1 LCI e Excel Part1 Part2 Part3 Part4 Part5 Part6 Part7 Part8 2 Excel 1 Sum, Concatenate, Left/Right/Mid, Count 2 If, And/Or,

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

aisatu.pdf

aisatu.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 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

2015taisetumatome.rtf

2015taisetumatome.rtf B B B( ) B3 - B3 1 3g 1/3 B 1. B1() B1() 2. B2() B2() 3. B5() B5() 4. B6() B6()( ) 5. B12() B12() 6. 1q60 160m 50m 50m 20m 8520 80 10 64 5075 30 80 B B 1 30 BB BC EPA . ?? 6 C E C 1 30 1 0.4mg4

More information

1 ETC - 1 -

1 ETC - 1 - ******** ******** - 0 - 1 ETC - 1 - ( ) ( ) ( )( )31 ( ) ( ) - 2 - - 3 - MENU MENU Enter - 4 - 1 4 A 1 C D E J K L M - 5 - A C 1 ( ) ( ) - 6 - 1 3 A 1 C D E J K L M 1 ( ) ( ) - 7 - 1 1 1 1 1 2 1 1 2 2

More information

Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の URL からご覧いただけます. このサンプルページの内容は, 初版 1 刷発行時のものです.

Excel ではじめる数値解析 サンプルページ この本の定価 判型などは, 以下の 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 information

43 IME Microsoft Office PowerPoint Microsoft Office Word Microsoft Office Excel

43 IME Microsoft Office PowerPoint Microsoft Office Word Microsoft Office Excel \n Title 情 報 教 育 の 受 講 生 における 入 力 の 調 査 Author(s) 五 月 女, 仁 子 ; Soutome, Hiroko Citation 商 経 論 叢, 48(2): 43-53 Date 2012-12-25 Type Departmental Bulletin Paper Rights publisher KANAGAWA University Repository

More information

橡統計担当者のためのエクセル表紙.PDF

橡統計担当者のためのエクセル表紙.PDF Num Lock(Pad Lock) ( Num Lock) [ ][ ] [ ][ ] Alt Alt 4 + ( ) 3+3 - ( ) 3-1 -1 * ( ) 3*3 / ( ) 3/3 % ( ) 20% ^ ( ) 3^2 (3*3 ) 2 TRUE FALSE = ( ) A1=B1 > ( ) A1>B1 < ( ) A1= ( ) A1>=B1

More information

Microsoft Word - .....J.^...O.|Word.i10...j.doc

Microsoft Word - .....J.^...O.|Word.i10...j.doc P 1. 2. R H C H, etc. R' n R' R C R'' R R H R R' R C C R R C R' R C R' R C C R 1-1 1-2 3. 1-3 1-4 4. 5. 1-5 5. 1-6 6. 10 1-7 7. 1-8 8. 2-1 2-2 2-3 9. 2-4 2-5 2-6 2-7 10. 2-8 10. 2-9 10. 2-10 10. 11. C

More information

Micro-D 小型高密度角型コネクタ

Micro-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 information

スライド タイトルなし

スライド タイトルなし AHP Analytic Hierarchy Process X4 X X4 X4 X4 a b c d AHP 00 ad4 6 2 a b c a b c a b c d 5.5 2 d d a b 5 a c.5 ad 2 6 3 a b a b c d 5.5 2 0.25 c.5 d a a b c d 5.5 2 a a b c d 5.5 2 b c 0.25.5 b c 0.2 2/3

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

/27 (13 8/24) (9/27) (9/27) / / / /16 12

/27 (13 8/24) (9/27) (9/27) / / / /16 12 79 7 79 6 14 7/8 710 10 () 9 13 9/17 610 13 9/27 49 7 14 7/8 810 1 15 8/16 11 811 1 13 9/27 (13 8/24) (9/27) (9/27) 49 15 7/12 78 15 7/27 57 1 13 8/24 15 8/16 12 810 10 40 1 Wikipedia 13 8/18, 8/28 79

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

(1)2004年度 日本地理

(1)2004年度 日本地理 1 2 3 4 1 2 3 4 5 6 7 8 9 10 11 12-5.0-5.1-1.4 4.2 8.6 12.4 16.9 19.5 16.6 10.8 3.3-2.0 6.6 16.6 16.6 18.6 21.3 23.8 26.6 28.5 28.2 27.2 24.9 21.7 18.4 22.7 5 1 2 3 4 5 6 7 8 9 10 11 12 2.2 3.5 7.7 11.1

More information

2 2 JR 1 2 (Course Power (S101.xlsx( ) µ µ Ž ƒ ƒ Œ Ž µ Œ Ž µ e µ µ Ž u u Œ d Ž e 1 JR 1 3 (1) C2)

2 2 JR 1 2 (Course Power (S101.xlsx( ) µ µ Ž ƒ ƒ Œ Ž µ Œ Ž µ e µ µ Ž u u Œ d Ž e 1 JR 1 3 (1) C2) 2 1 2 (lookup ) (1) LOOKUP (2) (ROUNDUP,ABS (3) (4) (5) 1 (LOOKUP ) VLOOKUP( HLOOKUP) 2 2 JR 1 2 (Course Power (S101.xlsx( ) µ µ Ž ƒ ƒ Œ Ž µ Œ Ž µ e µ µ Ž u u Œ d Ž e 1 JR 1 3 (1) C2) 2 3 (2) (C3) (3)

More information

Word 2000 Standard

Word 2000 Standard .1.1 [ ]-[ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [OK] [ ] 1 .1.2 [ ]-[ ] [ ] [ ] [ [ ] [ ][ ] [ ] [ ] [ / ] [OK] [ ] [ ] [ ] [ ] 2 [OK] [ ] [ ] .2.1 [ ]-[ ] [F5] [ ] [ ] [] [ ] [ ] [ ] [ ] 4 ..1 [ ]-[ ] 5 ..2

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

3 4 6 10 11 14 16 19

3 4 6 10 11 14 16 19 PowerPoint2007 3 4 6 10 11 14 16 19 PowerPoint PowerPoint PowerPoint 1 PowerPoint 1 1 2 3 4 5 2 [ ] 3 4 8 1 2 3 5 2 6 1 7 8 Office PowerPoint 2007 9 10 2 3 11 6 12 Ctrl 2 Shift 2 5 2 Shift 5 2 Delete 13

More information

(

( 2 Web http://mybook-pub-site.sakura.ne.jp/statistics Multivariate/index.html 1 2 1 2.1................................. 1 2.2 (............... 8 2.2.1................... 9 2.2.2.................. 12 2.2.3..............

More information

ohp.mgp

ohp.mgp 2019/06/11 A/B -- HTML/WWW(World Wide Web -- (TA:, [ 1 ] !!? Web Page http://edu-gw2.math.cst.nihon-u.ac.jp/~kurino VNC Server Address : 10.9.209.159 Password : vnc-2019 (2019/06/04 : : * * / / : (cf.

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

人芯経営論 ・・・リーダーシップ考②

人芯経営論 ・・・リーダーシップ考② 2009/12/15 2009/11/17 2009/11/16 2009/10/19 2009/10/15 2009/10/1 2009/9/17 2009/9/1 2009/8/17 2009/8/17 2009/8/14 2009/8/12 2009/7/28 2009/7/17 2009/7/15 2009/6/24 2009/6/18 2009/6/15 2009/5/20 2009/5/15

More information

PowerPoint プレゼンテーション

PowerPoint プレゼンテーション 0 1 2 3 4 5 6 1964 1978 7 0.0015+0.013 8 1 π 2 2 2 1 2 2 ( r 1 + r3 ) + π ( r2 + r3 ) 2 = +1,2100 9 10 11 1.9m 3 0.64m 3 12 13 14 15 16 17 () 0.095% 0.019% 1.29% (0.348%) 0.024% 0.0048% 0.32% (0.0864%)

More information

新たな基礎年金制度の構築に向けて

新たな基礎年金制度の構築に向けて [ ] 1 1 4 60 1 ( 1 ) 1 1 1 4 1 1 1 1 1 4 1 2 1 1 1 ( ) 2 1 1 1 1 1 1 1996 1 3 4.3(2) 1997 1 65 1 1 2 1/3 ( )2/3 1 1/3 ( ) 1 1 2 3 2 4 6 2.1 1 2 1 ( ) 13 1 1 1 1 2 2 ( ) ( ) 1 ( ) 60 1 1 2.2 (1) (3) ( 9

More information

http://www1.iwate-ed.jp/ WindowsXP - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

広報さっぽろ 2016年8月号 厚別区

広報さっぽろ 2016年8月号 厚別区 8/119/10 P 2016 8 11 12 P4 P6 P6 P7 13 P4 14 15 P8 16 P6 17 18 19 20 P4 21 P4 22 P7 23 P6 P7 24 25 26 P4 P4 P6 27 P4 P7 28 P6 29 30 P4 P5 31 P5 P6 2016 9 1 2 3 P4 4 P4 5 P5 6 7 8 P4 9 10 P4 1 b 2 b 3 b

More information

橡Taro9-生徒の活動.PDF

橡Taro9-生徒の活動.PDF 3 1 4 1 20 30 2 2 3-1- 1 2-2- -3- 18 1200 1 4-4- -5- 15 5 25 5-6- 1 4 2 1 10 20 2 3-7- 1 2 3 150 431 338-8- 2 3 100 4 5 6 7 1-9- 1291-10 - -11 - 10 1 35 2 3 1866 68 4 1871 1873 5 6-12 - 1 2 3 4 1 4-13

More information

PERT EXCEL

PERT EXCEL EXCEL PERT PERT EXCEL PERT EXCEL EXCEL PERT EXCEL PERT PERT EXCEL EXCEL i j PERT t je t il C t E t E D E F D E F EXCEL EXCEL t E t E D t E EXCEL MAX MAX EXCEL EXCEL t E EXCEL EXCEL EXCEL t E PERT t ie

More information

スライド 1

スライド 1 (6A-1) 1 条件付き書式の設定 英語 数学 国語 の点数が 80 点より高い場合は セルの数字を 太字斜体 の 赤 にする 1. 条件の設定 以下の問の ( ) に当てはまる適切なものを選択してください セル [B3:D5] を範囲選択 [ ホーム ] タブ ( 図 A) の ( ア ) ボタンをクリック 一覧から図 1の ( イ ) をクリックし さらに図 2の ( ウ ) をクリック 2.

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

JA2008

JA2008 A1 1 10 vs 3 2 1 3 2 0 3 2 10 2 0 0 2 1 0 3 A2 3 11 vs 0 4 4 0 0 0 0 0 3 6 0 1 4 x 11 A3 5 4 vs 5 6 5 1 0 0 3 0 4 6 0 0 1 0 4 5 A4 7 11 vs 2 8 8 2 0 0 0 0 2 7 2 7 0 2 x 11 A5 9 5 vs 3 10 9 4 0 1 0 0 5

More information

Excelを使ったAHPの計算方法

Excelを使ったAHPの計算方法 Excel 入門 ( その 3) 23 24 (a) (b) (c) (d) 1 Excel 23 Excel Excel Enter 1 2 Tab 1 Enter 2 AHP n n F2 =B2*C2*D2*E2 25 2 4 30 4 4 30 4 1 30 30 4 1 Excel G2 =F2^(1/4)^Excel 26 1 3 Excel F2 G2 G2 3 1 4 3 4 3 27

More information

untitled

untitled 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 information

PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web

PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web PDF CD-ROM CD-ROM Manual PDF Adobe Reader Adobe Web [ ] [OK] [OK] 40 () () [ ][ ] [OK] [ ] [ ][ ] ] [ [ ][ ] [ ] 3 20 [OK] - CONFORMat CONFORMat Dual 2 2 X Y 3 [ ][ ] 13 [ ][2 ] [2 ] [ ][2 ] [2 ] [ ]

More information

ネットショップ・オーナー2 ユーザーマニュアル

ネットショップ・オーナー2  ユーザーマニュアル 1 1-1 1-2 1-3 1-4 1 1-5 2 2-1 A C 2-2 A 2 C D E F G H I 2-3 2-4 2 C D E E A 3 3-1 A 3 A A 3 3 3 3-2 3-3 3-4 3 C 4 4-1 A A 4 B B C D C D E F G 4 H I J K L 4-2 4 C D E B D C A C B D 4 E F B E C 4-3 4

More information

EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編

EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編 K L N K N N N N N N N N N N N N L A B C N N N A AB B C L D N N N N N L N N N A L B N N A B C N L N N N N L N A B C D N N A L N A L B C D N L N A L N B C N N D E F N K G H N A B C A L N N N N D D

More information

ありがとうございました

ありがとうございました - 1 - - 2 - - 3 - - 4 - - 5 - 1 2 AB C A B C - 6 - - 7 - - 8 - 10 1 3 1 10 400 8 9-9 - 2600 1 119 26.44 63 50 15 325.37 131.99 457.36-10 - 5 977 1688 1805 200 7 80-11 - - 12 - - 13 - - 14 - 2-1 - 15 -

More information

EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編

EPSON エプソンプリンタ共通 取扱説明書 ネットワーク編 K L N K N N N N N N N N N N N N L A B C N N N A AB B C L D N N N N N L N N N A L B N N A B C N L N N N N L N A B C D N N A L N A L B C D N L N A L N B C N N D E F N K G H N A B C A L N N N N D D

More information

公務員人件費のシミュレーション分析

公務員人件費のシミュレーション分析 47 50 (a) (b) (c) (7) 11 10 2018 20 2028 16 17 18 19 20 21 22 20 90.1 9.9 20 87.2 12.8 2018 10 17 6.916.0 7.87.4 40.511.6 23 0.0% 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2.0% 4.0% 6.0% 8.0%

More information

Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 A B (A/B) 1 1,185 17,801 6.66% 2 943 26,598 3.55% 3 3,779 112,231 3.37% 4 8,174 246,350 3.32% 5 671 22,775 2.95% 6 2,606 89,705 2.91% 7 738 25,700 2.87% 8 1,134

More information

橡hashik-f.PDF

橡hashik-f.PDF 1 1 1 11 12 13 2 2 21 22 3 3 3 4 4 8 22 10 23 10 11 11 24 12 12 13 25 14 15 16 18 19 20 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 144 142 140 140 29.7 70.0 0.7 22.1 16.4 13.6 9.3 5.0 2.9 0.0

More information

198

198 197 198 199 200 201 202 A B C D E F G H I J K L 203 204 205 A B 206 A B C D E F 207 208 209 210 211 212 213 214 215 A B 216 217 218 219 220 221 222 223 224 225 226 227 228 229 A B C D 230 231 232 233 A

More information

1

1 1 2 3 4 5 (2,433 ) 4,026 2710 243.3 2728 402.6 6 402.6 402.6 243.3 7 8 20.5 11.5 1.51 0.50.5 1.5 9 10 11 12 13 100 99 4 97 14 A AB A 12 14.615/100 1.096/1000 B B 1.096/1000 300 A1.5 B1.25 24 4,182,500

More information