用python处理excel数据、求线性回归方程的r值_大师网-Python 线性回归计算r-squared方法...

背景

计算线性回归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拟合结果

相关链接