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 = 2. z = (87 90)/2 = 1.5. w = ( 1.5) 10 + 50 = 35. x = 90, ( ) L04 2 I(2017) 2 / 24
2 2 1 2 2 2 2 Excel ( ) L04 2 I(2017) 3 / 24
2 2 2 1. 2. (x, y). x, y. x y ( ) z J Div1. 2014 34. n = 18( ). ( ) x y z 9 347 50 18 512 39. http://www.j-league.or.jp/data/... (x, y) =( (cm), (kg)), ( ( ), (m 2 ), (, ), (, ).... ( ) L04 2 I(2017) 4 / 24
2 2 = 5.2.2? ( ) L04 2 I(2017) 5 / 24
2 2 x:, y ( ) 2 18. y \x 0 5 10 15 20 200 250 1 1 250 300 1 1 300 350 2 3 1 6 350 400 1 4 3 8 400 450 1 1 450 500 0 0 500 550 1 1 1 4 7 6 18 ( ) L04 2 I(2017) 6 / 24
2 2 1 2 2 2 2 Excel ( ) L04 2 I(2017) 7 / 24
Y 0 2 4 6 8 10 X 2 2 Y 0 2 4 6 8 10 X Y 0 2 4 6 8 10 X Y 0 2 4 6 8 10 X Y 0 2 4 6 8 10 X 5.2.3 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 r = 0.99 r = 0.55 r = 0 r = 0.55 r = 0.99 : x y : x y / : / r: r xy.. ( ) L04 2 I(2017) 8 / 24
2 2 I 5.2.3 x x = 1 N x Sx 2 = 1 N y, Sy 2. N i=1 x i N (x i x) 2 = 1 N i=1 N (x i x)(x i x) i=1 (covariance) x, y C xy = 1 N N (x i x) (y i y) i=1 : C xy = S xy, x S 2 x = S xx, y S 2 y = S yy. ( ) L04 2 I(2017) 9 / 24
2 2 p.110 Y (,+) (+,+) Y の平均値 (, ) (+, ) X Xの平均値 (+, ) = (x i x, y i y ). / / (?) ( ) ( ) L04 2 I(2017) 10 / 24
2 2 I p.111 x, y 1 5.4(p.112),,. (correlation coefficient) x, y r = C xy S x S y ( ) L04 2 I(2017) 11 / 24
2 2 1 r +1 5.5(p.114) r = 0 ( ) r = ±1 / y x 1. 5.7(p.115) r x, y 1 5.6(p.114) ( ) L04 2 I(2017) 12 / 24
2 2 L04-Q1 Quiz( ( )) (xg, ycm) 1 x, y 2 x, y., y 122 = 5 = 4.94(cm). x(g) y(cm) 1 5 3 15 4 14 5 11 7 20 ( ) L04 2 I(2017) 13 / 24
2 1 2 2 2 2 Excel ( ) L04 2 I(2017) 14 / 24
2 5.2.4 (regression), = =1 2 (x, y) r = ±1 (x, y) ( ) y = ax + b! a, b. shoot.received 250 300 350 400 450 400 420 440 460 480 500 520 FK y: ( ) x: ( )? x y ( ) L04 2 I(2017) 15 / 24
2 1 2 2. 2 2 d 2 n n L(a, b) = d 2 i = (y i (ax i + b)) 2 L Y a = L b i=1 i=1 = 0 a, b. I X ( ) L04 2 I(2017) 16 / 24
2 L(a, b) = N(1 r 2 )Sy. 2 ( ) L04 2 I(2017) 17 / 24 5.8, (5.11) x i, y i (i = 1,..., n) x, y, S x, S y, r., y = r S y S x (x x) + y = ax + b. a = r Sy S x = Cxy, b = ( (x, y) ) Sx 2 a: (x 1 y ) r 2 : ( ) 5.2.4
2 I, 2S x, 2S y Sy S x?,, 0, r. (x, y) (m,kg). r.. y (kg). r Sy(kg) S x(m) x(m) + b(kg), S x /S y. ( ) L04 2 I(2017) 18 / 24
2 L04-Q2 Quiz( ) 2 (x, y). x x 9 y y 4 x s 2 x 49 y s 2 y 36 x, y s xy 25 (x, y) n 16,, x, y.. ( ) L04 2 I(2017) 19 / 24
2 Excel 1 2 2 2 2 Excel ( ) L04 2 I(2017) 20 / 24
2 Excel R... SPSS. Excel,. Office365. Excel. >Excel 2016 > > > Excel > > OK. ( ) L04 2 I(2017) 21 / 24
2 Excel (Excel) I,,, > > average, > > var.p, stdev.p, mode > > > median, quartile, > > frequency + > > = > >, > > >, covar=covariance.p, correl > > linest > > >, =, n 1 n, var.p. ( ) L04 2 I(2017) 22 / 24
2 Excel Excel, 1 ( ).,,. 2 (n ), S xy r xy S xx S yx S xy S yy, r xx r xy r yx r yy. S yy r yy, y = x S xy, r., S yy = Sy, 2 r yy = 1. n 3 n n. R = r R2 = r 2 = b X 1 = a n 3 (x1, x 2,..., x n 1, y), X 2,. ( ) L04 2 I(2017) 23 / 24
2 Excel 2017-10-18 2017-10-25, trial. Excel. 2017-10-25 23:59 2017-10-25,,, ( ) trial. 1-503, http://hig3.net. ( )... 3.5(1-539) 4(1-502), Math - (1-614) 1.4, 2.1, 2.2, 2.3. ( ) L04 2 I(2017) 24 / 24