! L02(2013-10-02 Wed) 1 (median),, 2 (mode),, 3 (mean),, http://hig3net () L02!(2013) 1 / 24
: 1 : 2 Excel and more () L02!(2013) 2 / 24
: () L02!(2013) 3 / 24
: L01-Q5 Quiz : 1 Q2= (60 + 70)/2 = 65 Q1 30 50 55 55 60 55 Q3 70 70 70 75 100 70 Q3 Q1 = 15 15 15 = 225 ( ) 55 225, 75 + 225 V1 0 20 40 60 80 100 () L02!(2013) 4 / 24
: 2 : ( ), 30 40 1 01 40 50 3 03 50 60 1 01 60 70 4 04 70 80 0 00 80 90 0 00 90 100 0 00 100 110 1 01 10 100 Histogram of d frequency 0 1 2 3 4 3 20 40 60 80 100 120 d () L02!(2013) 5 / 24
: Q1 Quiz( )? frequency 0 5 10 15 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 () L02!(2013) 6 / 24
: Q2 Quiz( )? frequency 0 5 10 15 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 0 2 4 6 8 10 () L02!(2013) 7 / 24
: Q3 Quiz( )? 0 2 4 6 8 10 Frequency 0 1 2 3 4 0 2 4 6 8 10 Frequency 0 1 2 3 4 0 2 4 6 8 10 Frequency 0 1 2 3 4 0 2 4 6 8 10 Frequency 0 1 2 3 4 0 2 4 6 8 10 () L02!(2013) 8 / 24
1 : 2 Excel and more () L02!(2013) 9 / 24
1! 150cm? 170cm 180cm? (Quiz : 30 50 55 55 60 70 70 70 75 100) () 145 150 7 150 155 17 155 160 29 160 165 19 165 170 4 170 175 1 frequency 0 5 10 15 20 25 30 77 Dataset$V1 145 150 155 160 165 170 175 () L02!(2013) 10 / 24
1 : 2 Excel and more () L02!(2013) 11 / 24
(median)=q2 ( ),, 2 /2 Quiz (30 50 55 55 60 70 70 70 75 100) () L02!(2013) 12 / 24
( ), = 145 150 1475 7 150 155 17 155 160 29 160 165 19 165 170 4 170 175 1 77 frequency 0 5 10 15 20 25 30 145 150 155 () 160 165 170 L02!(2013) 13 / 24 175
1 : 2 Excel and more () L02!(2013) 14 / 24
=mode Quiz (30 50 55 55 60 70 70 70 75 100) ( ) 145 150 7 150 155 17 155 160 29 160 165 19 165 170 4 170 175 1 77 () L02!(2013) 15 / 24
frequency 0 5 10 15 20 25 30 145 150 155 160 165 170 175 Dataset$V1 () L02!(2013) 16 / 24
1 : 2 Excel and more () L02!(2013) 17 / 24
=mean? Quiz (30 50 55 55 60 70 70 70 75 100) ( ), 145 150 7 10325 150 155 17 25925 155 160 29 45675 160 165 19 30875 165 170 4 6700 170 175 1 1725 77 125075 =121225/77 = 1554 () L02!(2013) 18 / 24
frequency 0 5 10 15 20 25 30 145 150 155 160 165 170 175 Dataset$V1 () L02!(2013) 19 / 24
Quiz() 1 2 3 frequency 00 05 10 15 20 25 30 10 15 20 25 Dataset$V1 () L02!(2013) 20 / 24
Excel and more 1 : 2 Excel and more () L02!(2013) 21 / 24
Excel and more Excel (,, ),, >Excel 2007 > Excel > > > Excel > >, avarage(), median(), mode() e Moodle https://moodlemediaryukokuacjp/ Excel https: //moodlemediaryukokuacjp/course/viewphp?id=950 http: //wwwsetamediaryukokuacjp/literacy/literacyhtml () L02!(2013) 22 / 24
Excel and more Quiz e https://moodlemediaryukokuacjp/, Excel Quiz e https://moodlemediaryukokuacjp/ Quiz L02 ( ) e https://moodlemediaryukokuacjp/course/viewphp?id=1140 1-1, 4-3, 4 () L02!(2013) 23 / 24
Excel and more e + Quiz e https://moodlemediaryukokuacjp/ > > () () L02!(2013) 24 / 24