countif Excel E4:E10E4:E10 OK 2/25

Size: px
Start display at page:

Download "countif Excel E4:E10E4:E10 OK 2/25"

Transcription

1 countif(2 ) 2.2 (7 ) 2.3 frequency(7 ) 3 [] (8 ) 4.2 (11 ) 4.3 (12 ) 4.4 (13 ) 4.5 (14 ) (14 ) 5.2 (15 ) 5.3 (16 ) F (17 ) 6.2 t (17 ) 6.3 z (20 ) : (21 ) 7.2 : (21 ) (23 ) 8.2 (24 ) 8.3 (24 ) 1 (Microsoft) (excel) (Sun Microsystems) = (open-office calc) /25

2 countif Excel E4:E10E4:E10 OK 2/25

3 5 6 4.E4:E10E4:E10 OK Excel COUNTIF COUNTIF 100 =COUNTIF(,100) 20 =COUNTIF(, >= 20 ) =COUNTIF(, >= 20 ) COUNTIF(, >= 40 ) E3:F /25

4 ( ) /25

5 11. 0 (S) H3:H OK 15. OK /25

6 k = 1 + log 2 n n 100 k 5.6 k = 6 6/25

7 2.2 (tally mark) tally mark A :: 2 B ;;::: 13 C ;:::: 9 D ;;;;:: 22 E ::: 3 F : frequency frequency 1. (max) (min) 2. D13 D17 3. ( E13 E17 4. =frequency 5. FREQUENCY(, ) A2 A10 D13 D17 6. OK CTRL+SHITFT OK / (1) < (2) (3) (4) =sum(a2:a9) 2 countif AND 2 7/25

8 Ctrl, Shift active, nonactive shift+ ctrl+ arrow key [] [] Excel Microsoft Excel [] [] /25

9 2 2 [] : : [ ] [ ] / [] [] : 95% 5% K : k k k 1 K : k k k 1 : 1 2 [] 2 : A1 9/25

10 / = (,,, ) (true) false 3 10/25

11 : [] () () [] : (optional): /25

12 : : : A1 : : : : 4.3 N CORREL PEARSON 2 N 3 CORREL ( PEARSON) ( ) ( ) (0 ) [] : : [ ] [ ] / [] [] 12/25

13 : 2 1 : A1 : 4.4 N COVAR N=2 2 COVAR i i i VARP 2 () () (0 ) [] [ ] [ ] / [] [] 2 A1 13/25

14 4.5 RANK PERCENTRANK RANK RANK RANK [ ] [ ] [ ] / [ ] [] [ ] [] A [ ] [ ] [ ] 1 [] []( ) 0 1 [] 0 1 [] 2 (p ) 14/25

15 [] 2 (p ) [ ]1/ [ ] ( ) []( ) 2 1 [] [ ] [] [] A1 [] (seed) : : A [] : 15/25

16 1 2 : : [ ] [ ] : 1 : : 1 [ ] [ ] : A1 : 5.3 (mid rank) [ ] [ ] [] [ ] [ ] [] [] [ ] [] [ ] [ ] [] [] A1 [] 16/25

17 6 6.1 F F : 2 2 F 2 2 F 2 F ( F ) f 1 f < 1 P(F <= f ) f F F α 1 f > 1 P(F <= f ) f F F α 1 [F : 2 ] α 0 1 I α = 0.01, 0.05, 0.10 A1 6.2 t 2 t t t t Stat t t < 0 P(T <= t) t t t >= 0 P(T <= t) t t 17/25

18 t t t α P(T <= t) t t P P t α t : t t t 2 ( ) S 2 = n 1S n 2S 2 2 n 1 + n 2 2 [t : ] () 0 1 I A1 t : 2 2 t t 2 t 2 t [t : 2 ] (6.1) 18/25

19 0 () 0 1 I A1 t : 2 2 t t 2 t t t t = x y 0 S 1 2 m + S 2 2 n (6.2) df t df Excel TTEST df TTEST df TTEST t d f = ( S 1 2 m + S 2 2 n )2 (S 1 2/m)2 m 1 + (S 2 2/n)2 n 1 [t : 2 ] () (6.3) 19/25

20 0 1 I A1 6.3 z z : 2 2 z 2 ZTEST z P(Z <= z) P(Z >= ABS (z)) z z 0 P(Z <= z) P(Z >= ABS (z) or Z <= ABS (z)) z z 0 2 z 2 0 z 2 [z : 2 ] () 1 () 1 2 () I 20/25

21 A1 7 (Analysis Variance) 7.1 : 2 TTEST 3 TTEST [ : ] : : [ ] [ ] / [] [] α: F α I A1 7.2 : 2 A B C 6 21/25

22 [ ] : 1 : 1 : F I : : A1 : [ ] 2 1 ( 1 ) 1 [ : ] F I 22/25

23 A R-2 1 LINEST [R ] Y : 1 X 16 95% 0 y R-2 7 A1 23/25

24 8.2 F (t+1) = 1 NA t j+1 (8.1) N N A j j F j j [ ] [ ] 2 #N/A [ ] [] a % 30% [ ] j=1 24/25

25 % 30% [ ] 2 #N/A [ ] [] 1 25/25

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

stat-excel-12.tex (2009 12 8 ) 2 -countif Excel 22 http://software.ssri.co.jp/statweb2/ 1. 111 3 2. 4 4 3 3. E4:E10 E4:E10 OK 4. E4:E10 E4:E10 5 6 2/1

stat-excel-12.tex (2009 12 8 ) 2 -countif Excel 22 http://software.ssri.co.jp/statweb2/ 1. 111 3 2. 4 4 3 3. E4:E10 E4:E10 OK 4. E4:E10 E4:E10 5 6 2/1 stat-excel-12.tex (2009 12 8 ) 1 (Microsoft) (excel) (Sun Microsystems) = (open-office calc) 1 2 3 3 1 3 1 2 3 1 2 3 1/12 stat-excel-12.tex (2009 12 8 ) 2 -countif Excel 22 http://software.ssri.co.jp/statweb2/

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

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

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

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

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

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

2 () : ( )GDP () : () : POS STEP 1: STEP 2: STEP 3: STEP 4: 3 2 / //descrptvea1-a.tex 1 1 2 2 3 2 3.1............................................. 3 3.2............................................. 3 4 4 5 9 6 12 7 15 8 19 9 22 1 statstcs statstcum (EBM) 1 2 () : (

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回資料

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

pt % =1 1

pt % =1 1 1 9.4 4.7pt 94.6 8.1% 12 115 11 15 1 95 9 85 8 75 7 65 1 2 3 19.1 7 2.1 7 21.1 7 22.1 7 4 5 6 7 8 9 19.1 7 2.1 7 21.1 7 22.1 7 119.4 124 14 1 6 1 17=1 19.1 7 2.1 7 21.1 7 22.1 7 1194.6-1 -2-3 -4-5 -6-7

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

Excel2000

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

More information

Excel97関数編

Excel97関数編 Excel97 IF Microsoft Excel 97... 1... 1... 1... 2 IF... 3... 4... 4... 4... 4... 4... 5... 5... 5 IFG4C4... 5... 6 10... 6 11... 6 12... 6 13IFG4C4... 7 14... 7 15... 7 16... 7 17... 8 18... 8 19... 8

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

ACCESS入門編

ACCESS入門編 ACCESS () / 255 65535 0 255-32768 32767 15 4 1 Yes/No OLE Yes=-1 NO=0 OK Like AND *[ ]* Like *[ ]* Like >= =40 40 OR 1 OR AND 2000 2 2 AND 2 OK CTRL SHIFT IME 1 IME [1] [2]2

More information

5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. [] [] 10. 11. 12. ID 40

5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. [] [] 10. 11. 12. ID 40 5 PowerPoint PowerPoint 2003 PowerPoint 2007 5.1 - tert- 1. 2. 3. 4. 5.2 PowerPoint 2007 PowerPoint 2007 Word 2007, Excel 2007 39 5.3 1. 2. 3. tert-tert 4. Enter 5. Delete 6. 7. Delete 8. Delete 9. []

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

パソコン接続マニュアル P-01F 日本語

パソコン接続マニュアル P-01F 日本語 P-01F 1 2 3 4 5 1 2 +m1111 1 2 3 4 5 6 6 1 1 111 2 1 3 1 1 1 2 1 7 3 8 1 2 1 111 3 4 5 9 1 m111 m1111 c 2 3 4 5 10 1 1 111 2 1 3 1 1 1 2 1 3 1 m111 m1111 2 3 1 11 12 1 2 3 1 2 3 13 1 2 3 4 5 14 6 7 8 9

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

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

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

Word 2000 Standard

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

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

Plano-POS Ver1

Plano-POS Ver1 1 Quick Version2.0.0 Chapter1 Chapter1-1 Chapter2 Chapter2-1 Quick--------------------------------------------------------------P.7 -----------------------------------------------------------------------P.11

More information

無印良品のスキンケア

無印良品のスキンケア 2 3 4 5 P.22 P.10 P.18 P.14 P.24 Na 6 7 P.10 P.22 P.14 P.18 P.24 8 9 1701172 1,400 1701189 1,000 1081267 1,600 1701257 2,600 1125923 450 1081250 1,800 1125916 650 1081144 1,800 1081229 1,500 Na 1701240

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

(H8) 1,412 (H9) 40,007 (H15) 30,103 851

(H8) 1,412 (H9) 40,007 (H15) 30,103 851 (H8) 1,412 (H9) 40,007 (H15) 30,103 851 (H3) 1,466 (H3) 9,862 (H15) 4,450 704 9,795 1,677 18,488 402 44,175 3,824 8,592 853 7,635 1,695 2,202 179 5,127 841 27,631 452 35,173 177 123,797 186 45,727 1,735

More information

22 25 34 44 10 12 14 15 11 12 16 18 19 20 21 11 12 22 10 23 24 12 25 11 12 2611 27 11 28 10 12 29 10 30 10 31 32 10 11 12 33 10 11 12 34

22 25 34 44 10 12 14 15 11 12 16 18 19 20 21 11 12 22 10 23 24 12 25 11 12 2611 27 11 28 10 12 29 10 30 10 31 32 10 11 12 33 10 11 12 34 22 25 34 44 10 12 14 15 11 12 16 18 19 20 21 11 12 22 10 23 24 12 25 11 12 2611 27 11 28 10 12 29 10 30 10 31 32 10 11 12 33 10 11 12 34 35 10 12 36 10 12 37 10 38 10 11 12 39 10 11 12 40 11 12 41 10 11

More information

- 1 - - 2 - - 3 - - 4 - H19 H18-5 - H19.7H20.3 8,629 11,600-6 - - 7 - - 8 - - 9 - H20.7 20 / - 10 - - 11 - 1 8,000 16,000 4,000 2 50 12 80-12 - 20 3040 50 18a 19a - 13 - - 14 - 1,000-15 - 3,000 4,500 560

More information

17 12 12 13301515 2F1 P2 1 22 P19 160

17 12 12 13301515 2F1 P2 1 22 P19 160 136 17 12 12 13301515 2F1 P2 1 22 P19 160 161 15 87 15 P5 26 4 162 10 3 60 1/3 3 1 163 137 138 139 % %.%. (. ) ( ) 48 32 13 40 43 30 42 50 13 99 140 39 12 12 42 55 35 6 79 2004 16 17 39 37 53 13 1 1.2

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

スライド タイトルなし

スライド タイトルなし 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

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

( 2 / 35

( 2 / 35 Office 1 / 35 ( 2 / 35 3 / 35 ( 4 / 35 ( 5 / 35 6 / 35 =SUMPRODUCT((C$3:C$42>=$A46)(C$3:C$42

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

or57_4_175.dvi

or57_4_175.dvi c Excel Excel Excel Excel Microsoft Excel 1. OR Microsoft Excel Excel 1 Excel Excel Excel or 2007 Excel OR Excel Excel LP Excel LP Excel 112 8551 1 13 27 1 Excel Excel Excel 2010 Excel OpenOffice Calc

More information

Word 2007 Word 2007 Word Word 2003 Word 2007 Excel Web

Word 2007 Word 2007 Word Word 2003 Word 2007 Excel Web Microsoft Office Word 2007 Microsoft Office Word 2007 Microsoft Office Word 2007 Office Professional 2007 1 / / 1 /5 Word 2007 Word 2007 Word 2007 Word Word 2003 Word 2007 Excel Web http://office.microsoft.com/ja-jp/word/ha100744321041.aspx

More information

account4-1.PDF

account4-1.PDF 12 8 23 13 1 1 2 4 13 TEL 1 13 1 12 2 1 12 4 30 13 1 1 2 13 1 1 Office 13 1 1 13 1 1 1 12 2 1 12 4 30 99 3 office 3.1 4 office 426 147 85 3 6 12 2 1 13 1 31 office 5 2 3 4 5 6 7 8 12 2 1 12 4 30 11 8 1

More information

5 5.1 A B mm 0.1mm Nominal Scale 74

5 5.1 A B mm 0.1mm Nominal Scale 74 5 73 5 5.1 A B 2 1 2 1mm 0.1mm 5.1.1 Nominal Scale 74 5.2. Calc 5.1.2 Ordinal Scale (1) (2) (3) (4) (5) 5 1 5 1 5 4 5-2 -1 0 1 2 1 5 15 25 55 1 1 2 3 4 5 1 5.1.3 5.1.3 Interval Scale 100 80 20 80 100 5

More information

1 6-1 6-2 6-3 104

1 6-1 6-2 6-3 104 e-tax 1 6-1...89...93 6-2...96...98 6-3...100...100...101...102 1 6-1 6-2 6-3 104 6-1 102 104 101 7 1. 2. 3. 4. > 7-4 93 > 30 OK 6-2 e-tax 2-4 1. 2. 3. 30 4. OK 1. OK [OK] 2 98 16 OK OK 7 OK 1. 2. 3.

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

( 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

HA TO MARK

HA TO MARK HA TO MARK 02 03 04 2015 75 50 25-3.1pt +0.7pt 24.4% 24.2% 28.6% 18.3% 15.2% 23.0% 21.0% 17.9% 22.6% 23.3% +2.4pt 59.1% 61.5% 52.2% 54.8% 53.5% 0 2009 2010 2011 2012 2013 2009 2010 2011 2012 2013 2009

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

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

Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoi

Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoi Microsoft Office PowerPoint 2007 セミナーテキスト基礎編 講習の手引き Microsoft Office PowerPoint 2007 Office Professional 2007 PowerPoint 2007 PowerPoint 2007 PowerPoint 2007 PowerPoint PowerPoint 2003 PowerPoint 2007

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

橡マニュアル1999.PDF

橡マニュアル1999.PDF 11 11 7 28 7 30 9 30 16 30 2-302 1. (hardware) Microsoft Excel Microsoft Word Windows95/98 OS Windows95/98 MS-DOS 2. 3. 1 1 2 4. Enter CTRL ALT ALT SHIFT ESC BS DEL INS TAB CAPS 5. 1 ID ID 2 ID 3-1 - 6.Windows95/98

More information

1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18

1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18 Power Point 2007 1 3 4 4 6 7 8 9 11 11 12 CD 13 CD 14 15 18 8 15 1 bon_odori OK 2 3 4 OK 5 1 Windows Media Windows Video Microsoft Recorded TV Show Windows Media.asf.avi.mpg mpeg dvr-ms wmv 6 Word Excel

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

URL AdobeReader - 2

URL AdobeReader - 2 URL AdobeReader - 2 ...5...6...7...7...8...8...9...12...14...16...22...24 11.1....24 11.2....24 11.3....25 11.4....26...28...28 GoodNews...29-3 - 4 Office XP Professional - 5 - 6 Access Office XP Professional

More information

「産業上利用することができる発明」の審査の運用指針(案)

「産業上利用することができる発明」の審査の運用指針(案) 1 1.... 2 1.1... 2 2.... 4 2.1... 4 3.... 6 4.... 6 1 1 29 1 29 1 1 1. 2 1 1.1 (1) (2) (3) 1 (4) 2 4 1 2 2 3 4 31 12 5 7 2.2 (5) ( a ) ( b ) 1 3 2 ( c ) (6) 2. 2.1 2.1 (1) 4 ( i ) ( ii ) ( iii ) ( iv)

More information

untitled

untitled 186 17 100160250 1 10.1 55 2 18.5 6.9 100 38 17 3.2 17 8.4 45 3.9 53 1.6 22 7.3 100 2.3 31 3.4 47 OR OR 3 1.20.76 63.4 2.16 4 38,937101,118 17 17 17 5 1,765 1,424 854 794 108 839 628 173 389 339 57 6 18613

More information

untitled

untitled 1. 3 14 2. 1 12 9 7.1 3. 5 10 17 8 5500 4. 6 11 5. 1 12 101977 1 21 45.31982.9.4 79.71996 / 1997 89.21983 41.01902 6. 7 5 10 2004 30 16.8 37.5 3.3 2004 10.0 7.5 37.0 2004 8. 2 7 9. 6 11 46 37 25 55 10.

More information

離散数学 第 1回 論理 (1):命題論理

離散数学 第 1回  論理 (1):命題論理 1 (1) okamotoy@uecacjp 2012 4 10 2012 4 11 10:57 () (1) 2012 4 10 1 / 53 () (1) 2012 4 10 2 / 53 () 1 (1) (4 10 ) () (4 17 ) 2 (1) (4 24 ) 3 (2) (5 1 ) 4 (2) (5 8 ) 5 (3) (5 15 ) 6 (1) (5 22 ) 7 (2) (5

More information

-2- Teen's

-2- Teen's -1-1. 1-1. 1-2. -2- Teen's 1-3. A B / ATOK.2007 Shift CapsLock / ATOK.2007 ATOK A. B.ATOK / / -3- -4- Home Home Ctrl Tab Ctrl Tab Home -5- F4 ATOK -6- 2. SE -7- 2-1. SE SE SE OK -8- 2-2. OK -9- -10- Ctrl.

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

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

untitled

untitled MS-PowerPoint 2007 2009 8 Microsoft Office PowerPoint 2007 Microsoft Office PowerPoint 2007 PowerPoint 1 PowerPoint 1.1 PowerPoint 1.2 PowerPoint PowerPoint 2 . 2.1 PowerPoint 3 2.2 PowerPoint 4 2.3 5

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

31 gh gw

31 gh gw 30 31 gh gw 32 33 1406 1421 640 0 (mm) (mm) MAX1513 MIN349 MIN280 MAX900 gh gw 34 gh gh gw gw gh gh gw gw gh gh gw gw 35 175 176 177 178 179 180 181 195 196 197 198 202 203 2 1 L L L2 L2 L2 L 2 2 1 L L

More information

Keynote 3 ユーザーズガイド

Keynote 3 ユーザーズガイド Keynote3 K AppleComputer,Inc. 2006AppleComputer,Inc.Allrightsreserved. AppleComputer,Inc. Apple Apple Computer,Inc. Apple AppleComputer,Inc. Apple 1InfiniteLoop Cupertino,CA95014-2084 U.S.A. www.apple.com

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

....02.p65

....02.p65 LAN () (ABS) 10 8 6 4 2 0-2 -4 86 88 90 92 94 96 98 2000 30 20 10 0-10 -20-30 86 88 90 92 94 96 98 2000 14000 12291 12000 10000 8000 5737 5968 6000 4226 4000 2000 0 4.5 6.8 5.8 8.5 1.7 13.7 4 0

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

F8302D_1目次_160527.doc

F8302D_1目次_160527.doc N D F 830D.. 3. 4. 4. 4.. 4.. 4..3 4..4 4..5 4..6 3 4..7 3 4..8 3 4..9 3 4..0 3 4. 3 4.. 3 4.. 3 4.3 3 4.4 3 5. 3 5. 3 5. 3 5.3 3 5.4 3 5.5 4 6. 4 7. 4 7. 4 7. 4 8. 4 3. 3. 3. 3. 4.3 7.4 0 3. 3 3. 3 3.

More information