背景

计算线性回归a、b值后，希望计算r-squared，对比是否为最佳拟合

Excel拟合

数据源

拟合结果

Python拟合

import math
import numpy as np
from scipy import stats

testX = [174.5,171.2,172.9,161.6,123.6,112.1,107.1,98.6,98.7,97.5,95.8,93.5,91.1,85.2,75.6,72.7,68.6,69.1,63.8,60.1,65.2,71,75.8,77.8]
testY = [88.3,87.1,88.7,85.8,89.4,88,83.7,73.2,71.6,71,71.2,70.5,69.2,65.1,54.8,56.7,62,68.2,71.1,76.1,79.8,80.9,83.7,85.8]
 
def computeCorrelation(X, Y):
    xBar = np.mean(X)
    yBar = np.mean(Y)
    SSR = 0
    varX = 0
    varY = 0
    for i in range(0 , len(X)):
        diffXXBar = X[i] - xBar
        diffYYBar = Y[i] - yBar
        SSR += (diffXXBar * diffYYBar)
        varX +=  diffXXBar**2
        varY += diffYYBar**2
    
    SST = math.sqrt(varX * varY)
    print ("使用math库：r：", SSR / SST,"r-squared：", (SSR / SST)**2)
    return 
 
computeCorrelation(testX, testY)

x = np.array(testX)
y = np.array(testY)
#拟合 y = ax + b
poly = np.polyfit(x, y, deg=1)
print("使用numpy库：a：" + str(poly[0]) + "，b：" + str(poly[1]))


def rsquared(x, y): 
    slope, intercept, r_value, p_value, std_err = stats.linregress(x, y) 
    #a、b、r
    print("使用scipy库：a：",slope,"b：", intercept,"r：", r_value,"r-squared：", r_value**2)

rsquared(testX, testY)

Python拟合结果