如何在Sqlite中找到两个变量之间的相关性？

SELECT AVG((x - avg_x) * (y - avg_y)) / (stddev_x * stddev_y) AS correlation
FROM (
    SELECT x, y,
           (SELECT AVG(x) FROM your_table) AS avg_x,
           (SELECT AVG(y) FROM your_table) AS avg_y,
           (SELECT STDDEV(x) FROM your_table) AS stddev_x,
           (SELECT STDDEV(y) FROM your_table) AS stddev_y
    FROM your_table
) t;

SELECT 1 - (6 * SUM(d * d) / (n * (n * n - 1))) AS correlation
FROM (
    SELECT x, y,
           (SELECT COUNT(*) FROM your_table) AS n,
           (RANK() OVER (ORDER BY x) - RANK() OVER (ORDER BY y)) AS d
    FROM your_table
) t;