倒産件数: x | 有効求人倍率: y | x - xの平均: x' | x'の2乗 | y - yの平均: y' | y'の2乗 | x' * y' | a+bx | y-(a+bx):残差 | 残差の2乗 | ||||
5 | 399 | 0.60 | -102 | 10404 | 0.12875 | 0.016577 | -13.1325 | 0.551656 | 0.048343502 | 0.002337 | |||
6 | 396 | 0.49 | -105 | 11025 | 0.01875 | 0.000352 | -1.96875 | 0.554021 | -0.064021395 | 0.004099 | |||
7 | 518 | 0.49 | 17 | 289 | 0.01875 | 0.000352 | 0.31875 | 0.457849 | 0.032151083 | 0.001034 | |||
8 | 428 | 0.53 | -73 | 5329 | 0.05875 | 0.003452 | -4.28875 | 0.528796 | 0.001204173 | 1.45E-06 | |||
9 | 495 | 0.48 | -6 | 36 | 0.00875 | 7.66E-05 | -0.0525 | 0.47598 | 0.004020206 | 1.62E-05 | |||
10 | 638 | 0.35 | 137 | 18769 | -0.12125 | 0.014702 | -16.6113 | 0.363253 | -0.013253037 | 0.000176 | |||
12 | 560 | 0.41 | 59 | 3481 | -0.06125 | 0.003752 | -3.61375 | 0.42474 | -0.014740359 | 0.000217 | |||
13 | 574 | 0.42 | 73 | 5329 | -0.05125 | 0.002627 | -3.74125 | 0.413704 | 0.006295827 | 3.96E-05 | |||
平均 | 501 | 0.47125 | 6832.75 | 0.005236 | -5.38625 | 0.47125 | |||||||
標準偏差 | 82.66045 | 0.07236 | 残差の2乗和 | 0.00792 | |||||||||
(1)相関係数 | = (x'*y'の平均)/xの標準偏差/yの標準偏差 | -0.90052 | (4)決定係数R^2 | =1-(残差の2乗和)/(y' の2乗和) | |||||||||
(2)回帰係数b | = x'*y'の和/x'の2乗和 | -0.00079 | 0.810929 | ||||||||||
(3)定数項a | = yの平均 - b*xの平均 | 0.866188 |