Microsoft Word - 文書1

Size: px
Start display at page:

Download "Microsoft Word - 文書1"

Transcription

1 5. Excel Excel Excel Excel Excel Excel A1 =MAX(B2:B31) =MIN(B2:B31) B2:B31 A1 C31 Excel 10

2 Excel COUNTIF FREQUENCY COUNTIF C2 C31 80 =COUNTIF(C2:C31, 80) 80 COUNTIF(C2:C31, =80) Excel COUNTIF(C2:C31, >= &80) = =COUNTIF(C2:C31, >= &80) - COUNTIF(C2:C31, >= &90) E F2 =COUNTIF(C$2:C$31, >= &E2) Excel >= &E2 100 =COUNTIF(C$2:C$31,100) 100 F3 =COUNTIF(C$2:C$31, >= &E3) - COUNTIF(C$2:C$31, >= &E2)

3 F12 C G G14 G14 F14 G15 G14 =SUMPRODUCT(E2:E12,F2:F12) H H H16 C32,C33 10mm 10mm mm A B C C N P N P! N(P)

4 0 x x+ x f(x) x f(x) f(x) x f x dx x=x x x f(x) x!"!!"!"!!"!!!" N0!! =!!!!!"!! =!!!!!!"!"!!!!!!!!"!"!! 18 N Excel 1!!!! S 1!! (wi) wi 1!!! 1/2.3 2 =0.435 S 3.64 w PHi*wi 236.3mV (PHi PHave) 2 wi 4.4mV 236.0mV 4.6mV wi 90 5/30=1/ /30

5 19 " " [ - ]

6 -- COUNTIF FREQUENCY COUNTIF = COUNTIF(, ) =COUNTIF(C2:C31,60) C2 C =COUNTIF(C2:C31,>=50) Excel >= 50 >=50 >= 50 >= 50 >= + 50 >= &50 E2 E12 F2 =COUNTIF(C2:C31, >= &E2) 100 F2 F3 F3 =COUNTIF(C3:C32, >= &E3) F12 F2 =COUNTIF($C$2:$C$31, >= &E2) C $ C $ F F3

7 =COUNTIF($C$2:$C$31, >= &E3) - COUNTIF($C$2:$C$31, >= &E2) F12 F2 F12 Frequency Distribution FREQUENCY Excel Control+U +Z+Return Mac

8 F2 =FREQUENCY(C2:C31,E2) (1) F =FREQUENCY(C3:C32,E3) 28 C3 C31 C $ (1) (2) H2 (2) E2 E2:E12 H3 =FREQUENCY(C$2:C$31,E3:E13) E13 (3) (3) G2 H FREQUENCY H2 =FREQUENCY(C$2:C$31,E2:E3) FREQUENCY FREQUENCY COUNTIF

9 Excel Excel Excel de Asobo

●70974_100_AC009160_KAPヘ<3099>ーシス自動車約款(11.10).indb

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

76

76 ! # % & % & %& %& " $ 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 % & &! & $ & " & $ & # & ' 91 92 $ % $'%! %(% " %(% # &)% & 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 !$!$ "% "%

More information

†ı25”Y„o-PDF.ren

†ı25”Y„o-PDF.ren 12,000 10,000 8,000 6,000 4,000 2,000 0 1998 1999 2000 2001 2002 2003 2004 1,200 1,000 800 600 400 200 0 1998 1999 2000 2001 2002 2003 2004 $ "! ''" '' ''$ ''% ''& '''! " ' & % $ "! ''" ' '$ '% '& ''!

More information

- 1 - - 2 - 320 421 928 1115 12 8 116 124 2 7 4 5 428 515 530 624 921 1115 1-3 - 100 250-4 - - 5 - - 6 - - 7 - - 8 - - 9 - & & - 11 - - 12 - GT GT - 13 - GT - 14 - - 15 - - 16 - - 17 - - 18 - - 19 - -

More information

PX-047A Series

PX-047A Series B K L & L & A B C D E F A B A B C A B C A B A B A B C D E F G P BB H I y y & & K L L & & K L L L L & & & & L d L & & & & L L & & & L & & & & L & & & & & & & & L L L L L L & & & A B C D E F G

More information

... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2

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

財政金融統計月報第720号

財政金融統計月報第720号 ! # " $ % &! # % " $ &! # % " $ &! # %! # % " $ & " $ &! # % " $ & !!!!!!! !!!!!!! ! # " $ ! # " $ ! " # $! " # $ ! # " $ ! # $& %" !

More information

2

2 2 6 7 9 4 6 7 2 3 4 5 6 7 8-0 - G G G G G G f f 9 e f - e f 0 5 e fe e c c cc B FD F 5 2 5 D F C e e e b 3 f f 5 ff ff f f f f b b bb b b b c c c ee ee e ee ee e f f 4 e e 7 5 5 e bb 6 7 f GE 8 f 9 5 F

More information

-----------------------------------------------------------------------------------------1 --------------------------------------------------------------------------------------1 -------------------------------------------------------------------------------------1

More information

›¼’à”v“lŠÍ1−ª

›¼’à”v“lŠÍ1−ª 3 1 1 2 3 4 5 6 7 8 8 10 12 14 16 18 20 22 24 2 1 2 3 4 5 6 7 8 9 10 11 12 26 28 30 32 34 36 38 40 42 44 46 48 50 4 3 1 2 3 4 5 52 54 56 58 60 6 62 7 8 9 10 64 66 68 70 72 5 1 1 4 2 5 6 6 7 1 8 1 9 2 10

More information

1 2 3 4 1 2 3 4 1 2 3 4 12 3 4

1 2 3 4 1 2 3 4 1 2 3 4 12 3 4 1 2 3 4 5 6 1 2 3 4 5 6 1 2 1 2 1 2 1 2 1 2 3 4 12 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 12 3 4 1 2 3 4 5 6 7 8 1 2 3 46 7 1 2 3 4 5 6 7 1 2 3 4 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 16 7 8 92 3 46 7 :

More information

- 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 2-12 - 1 - 2 - 3 - 4 - 5 - 6 - 7 - 1 - 2 - 3 6 1 1-4 - 5 - 6 - 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 130 3 130 5 2 50 1.5 48 59 62 63-9 - 1 - 2 - 3 () - 4 - 5 -

More information

S1460...........\1.E4

S1460...........\1.E4 3 4 3 4 5 3 4 5 3 4 3 4 3 3 3 3 4 3 4 3 3 4 4 3 3 3 3 4 3 4 3 3 3 3 3 3 4 3 4 3 4 5 4 3 5 4 3 3 4 5 3 4 5 4 3 4 3 3 4 3 4 3 3 3 3 3 4 3 3 4! "! " " 0 6 ! " 3 4 3 3 4 3 ! " 3 3 4 5 4 5 6 3 3

More information

FX ) 2

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

More information

EP760取扱説明書

EP760取扱説明書 D D D # % ' ) * +, B - B / 1 Q&A B 2 B 5 B 6 Q & A 7 8 $ % & ' B B B ( B B B B B B B B B B B ) B B B A # $ A B B * 1 2 # $ % # B B % $ # $ % + B B 1 B 2 B B B B B B B B B B , B B B - 1 3 2 2 B B B B B

More information

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 5 2 5 24 () () () () () 1 1 150 50 50 1 1 ( 15,000 ) 150 ( 15,000 ) 100 50 50 1 1 ( 6,000 ) 150 ( 6,000 ) 100 50 50 1 1 150 1 1 150 100 0.25

More information

Microsoft Word - 触ってみよう、Maximaに2.doc

Microsoft Word - 触ってみよう、Maximaに2.doc i i e! ( x +1) 2 3 ( 2x + 3)! ( x + 1) 3 ( a + b) 5 2 2 2 2! 3! 5! 7 2 x! 3x! 1 = 0 ",! " >!!! # 2x + 4y = 30 "! x + y = 12 sin x lim x!0 x x n! # $ & 1 lim 1 + ('% " n 1 1 lim lim x!+0 x x"!0 x log x

More information

c c & % c 0 c N r l % *# 5 c c% c c % c c c % % c % % % c j % % % % % % % % &% &% % a % a &% c % cc % & s& cc c c & c & % c & c c & % % %c c %c & c % & % %c c %c & c % % % % % c c c a 28 % c% 13 5 6

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

untitled

untitled . 23 3 2 1 2 3 21 21 22 9 1 23 18 4 5 6 5 40 20 7 1 1 8 9 10 11 12 50cm 13 10 11 14 2011 3 11 15 16 ml mm tel 079-557-0039 & fax 079-557-1888 17 248-240- 98-48- 170-98- 98- ml 85-1,085-18 19 20 21 22 23

More information

アナウンスマニュアル

アナウンスマニュアル (1). (2). a. b. c. a. c. c. (3). 1 ( ) ( ) 2 (1). (2). (3). 3 () """" 4 ( ) ( ) ( ) ( ) 5 ( ) 6 () () () () () () () () () () () () () () () () () () () 7 () () () () () () () () () () () () () () () ()

More information

דוח דירקטוריון - חברה 012010 - גר 9 - 300510

דוח דירקטוריון - חברה 012010 - גר 9 - 300510 13060608060408 0704 0609030606 060705 050607 040007030501 0606070804060708 0300''6 1 6 1''06''6 1 0606050706010708 31.03.10 04010705 030902010105 0507090708 13050607 060705 060608060408 0704 0609030606

More information

™…

™… 2/10 15 2010. No1362 1 1 216315 91430 Q A & 0.23% 1 1.4% 04-7120-2020 050-5540-2023 Q A & 1 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 1 1 2 3 4 5 6 7 8 9 10

More information

bumon_pro.indd

bumon_pro.indd q w e r t y u i o!0 !1!2!3 !4!5!6 !7!8!9 @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 #0 #1 #2 #3 #4 #5 #6 #7 #8 #0 $0 $1 $2 $3 $4 $5 $6 $7 $8 $9 %0 %1 %2 %3 %4 %5 %6 %7 %8 %9 ^0 ^1 ^2 ^3 ^4 ^5 ^6 ^7 ^8 ^9 &0 &1 &2

More information

EPSON

EPSON B K L & & & & & & & & L & & & & & & & K & & & & & L L L & & & K L L L & & L L L & & & & & & & & & & & & & & & & & & & & & & & & & & & L & K L K & & & & & & & L L & & L & & L L & & & & &

More information

2.8% 2.0% 2.4% 2.4% 0.4% 0.1% 0.3% 0.5% 3.8% 5.6% 25.6% 29.3% 64.6% 60.0% 1

2.8% 2.0% 2.4% 2.4% 0.4% 0.1% 0.3% 0.5% 3.8% 5.6% 25.6% 29.3% 64.6% 60.0% 1 2.8% 2.0% 2.4% 2.4% 0.4% 0.1% 0.3% 0.5% 3.8% 5.6% 25.6% 29.3% 64.6% 60.0% 1 16 24 21 20 20 23 10 11 9 10 3 3 3 2 3 1 3 4 6 8 2 0 1 2 3 4 5 6 0 1 2 3 4 5 6 0 1 2 3 4 5 6 3 4 Q & A Q1 A1 Q2 A2 Q3 A3 7

More information

Q&A最低資本金特例030131.PDF

Q&A最低資本金特例030131.PDF & 1 2 2 3 2 2 3 2 2 3 10 11 10 90 12 13 14 15 16 17 18 19 20 2 2 3 21 2 2 3 22 23 24 25 20 10 26 27 28 10 8 1 29 30 10 8 2 31 32 2 2 3 33 10 8 3 10 11 2 34 10 8 3 10 12 2 35 36 20 10 37 38 39 40 41 42

More information

2012_10_A_cover.indd

2012_10_A_cover.indd c %& r Z \ W n % & & % % & % & & % % % & % & % & & % & % %& % & % & % % % & & & W W W W A

More information

‡o‡P†C‡P‡Q”R„û†^‡P†C‡P‡Q

‡o‡P†C‡P‡Q”R„û†^‡P†C‡P‡Q ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Q & A ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

More information

2012_05_GLK_cover.indd

2012_05_GLK_cover.indd c %& r Z \ W W n q & F % % & & % & & % % % & % & % & % & % & % & F F % % % & & & & % & A

More information

EP-808A Series

EP-808A Series & B K L & L & A B C A B C D E A B C D E A B C D E A B C D E L A B C ud D E F G & A B lr C & & & & & & & & & & & udlr & & & L K K L K L & & & L L K L K L & & & K x L L x & & K L L & K K L &

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

......1201-P1.`5

......1201-P1.`5 2009. No356 2/ 5 6 a b b 7 d d 6 ca b dd a c b b d d c c a c b - a b G A bb - c a - d b c b c c d b F F G & 7 B C C E D B C F C B E B a ca b b c c d d c c d b c c d b c c d b d d d d - d d d b b c c b

More information

QW-3414

QW-3414 MA1312-C P 1 2 3 A E L D E D A A E D A D D D D D E A C A C E D A A A C A C A C E E E D D D A C A C A A A A C A C A C E E C C E D D C C C E C E C C E C C C E D A C A C A C E L B B

More information

#"

# !" #" !!! $" x %" 2011.3.11 3.12 3.1 4.02 4.17 4.24 4.28 4.29 5.8 5.14 6.4 7.3 8.1 8.10 8.23 8.28 9.10 9.30 11.13 11.21 12.23 12.28 2012.2.24 3.18 3.20 3.24 &" ! '" (" )" *" !+" !!" !#" !$" !%" !& !'"

More information

橡matufw

橡matufw 3 10 25 3 18 42 1 2 6 2001 8 22 3 03 36 3 4 A 2002 2001 1 1 2014 28 26 5 9 1990 2000 2000 12 2000 12 12 12 1999 88 5 2014 60 57 1996 30 25 205 0 4 120 1,5 A 1995 3 1990 30 6 2000 2004 2000 6 7 2001 5 2002

More information

O

O 11 2 1 2 1 1 2 1 80 2 160 3 4 17 257 1 2 1 2 3 3 1 2 138 1 1 170 O 3 5 1 5 6 139 1 A 5 2.5 A 1 A 1 1 3 20 5 A 81 87 67 A 140 11 12 2 1 1 1 12 22 1 10 1 13 A 2 3 2 6 1 B 2 B B B 1 2 B 100 B 10 B 3 3 B 1

More information