メモ：メモ一覧
更新

-- 最小二乗法 SELECT S.YMD ,S.TIME ,S.TIME_NUM_MAIN AS TIME_NUM ,TRUNCATE(((S.a * 45) + S.b) / 140000, 2) AS f FROM ( SELECT A.YMD ,A.TIME ,A.TIME_NUM_MAIN ,((COUNT(*) * SUM(A.TIME_NUM * A.END_AMT)) - (SUM(A.TIME_NUM) * SUM(A.END_AMT))) / ((COUNT(*) * SUM(A.TIME_NUM * A.TIME_NUM)) - SUM(A.TIME_NUM) * SUM(A.TIME_NUM)) AS a ,(SUM(A.TIME_NUM * A.TIME_NUM) * SUM(A.END_AMT)) - (SUM(A.TIME_NUM * A.END_AMT) * SUM(A.TIME_NUM)) / ((COUNT(*) * SUM(A.TIME_NUM * A.TIME_NUM)) - SUM(A.TIME_NUM)) AS b FROM ( SELECT Z.YMD ,Z.TIME ,X.END_AMT ,(25 - (Z.TIME_NUM - X.TIME_NUM)) AS TIME_NUM ,Z.TIME_NUM AS TIME_NUM_MAIN FROM EveryDay5mData Z INNER JOIN EveryDay5mData X ON X.TIME_NUM BETWEEN Z.TIME_NUM - 24 AND Z.TIME_NUM WHERE Z.TIME_NUM BETWEEN '45' AND '70' ) A GROUP BY A.YMD ,A.TIME ,A.TIME_NUM_MAIN ) S