邨ｱ險医→遉ｾ莨�

Excel遲峨�蛻ｩ逕ｨ邨碁ｨ薙′縺ゅｊ, 陦ｨ險育ｮ励た繝輔ヨ縺ｫ縺ｪ繧後※縺�ｋ莠ｺ縺ｯ, 譚画ｵｦ蜈育函縺ｮ縲檎ｵｱ險医→遉ｾ莨壹阪〒邏ｹ莉九＆繧後ｋ蜀�ｮｹ,

http://www.math.u-ryukyu.ac.jp/~sugiura/2010/calc2010a.html

繧偵ｄ縺｣縺ｦ縺ｿ縺ｦ荳九＆縺�.

2縺､縺ｮ螟蛾㍼繧呈戟縺､蛟九�繝��繧ｿ $(x_1, y_1), (x_2, y_2),\ldots, (x_N, y_N)$ 縺御ｸ弱∴繧峨ｌ縺溘→縺�, $\overline{x}=\frac1{N}\sum_{i=1}^N x_i$ , $\overline{y}=\frac1{N}\sum_{i=1}^N y_i$ 繧偵◎繧後◇繧後�蟷ｳ蝮�､縺ｨ縺吶ｋ縺ｨ, $s_{xy} = \frac1{N} \sum_{i=1}^N (x_i-\overline{x})(y_i-\overline{y})$ 繧貞�蛻�淵縺ｨ險縺�∪縺�. $s_x=\sqrt{\frac1{N}\sum_{i=1}^N (x_i-\overline{x})^2}$ $s_y=\sqrt{\frac1{N}\sum_{i=1}^N (y_i-\overline{y})^2}$ 繧�, 縺昴ｌ縺槭ｌ繝��繧ｿ縺ｮ讓呎ｺ門￥蟾ｮ縺ｨ險縺�∪縺�. 縺薙�縺ｨ縺咲嶌髢｢菫よ焚縺ｯ $r=\frac{s_{xy}}{s_x x_y}$ 縺ｧ螳夂ｾｩ縺輔ｌ縺ｾ縺�. $-1\leq r \leq 1$ 縺瑚ｨｼ譏弱＆繧�, 繝��繧ｿ縺ｫ髢｢菫ゅ′縺ゅｊ縺昴≧縺句凄縺九�謨ｰ蛟､逧�↑謖�ｨ吶↓縺ｪ繧翫∪縺�.

縺薙ｌ繧峨�蜀�ｮｹ縺ｯ, 逧�＆繧薙�謨呵ご隱ｲ遞九〒縺ｯ, 謨ｰ蟄ｦ B 縺ｮ謨咏ｧ第嶌(驕ｸ謚樣�伜沺縺ｪ縺ｮ縺ｧ縺ｻ縺ｨ繧薙←縺ｮ莠ｺ縺ｯ蜍牙ｼｷ縺励※縺�↑縺�)縺ｫ譖ｸ縺九ｌ縺ｦ縺�∪縺励◆縺�, 莉雁ｹｴ縺九ｉ蟋九∪縺｣縺� 譁ｰ隱ｲ遞九〒縺ｯ(迴ｾ鬮俶�｡ 1蟷ｴ逕溘〒縺ｯ), 謨ｰ蟄ｦ I 縺ｫ遘ｻ蜍輔＠, 蜈ｨ蜩｡蠢�ｿｮ縺ｫ縺ｪ繧翫∪縺励◆. 謨吝藤繧堤岼謖�☆莠ｺ縺ｯ,縲檎ｵｱ險医→遉ｾ莨壹阪ｄ 3蟷ｴ谺｡縺ｮ縲檎｢ｺ邇�ｵｱ險亥ｭｦ縲阪〒, 縺薙ｌ繧峨�謨ｰ蟄励�諢丞袖繧偵＠縺｣縺九ｊ蜍牙ｼｷ縺励※荳九＆縺�.

student
2012-06-22