一元线性回归 excel

发布网友发布时间：2022-04-24 09:34

共2个回答

热心网友时间：2022-06-18 12:53

我用origin给你拟合了一下，不是一次的，是二次的。以下是拟合结果：

[2006-6-12 09:15 "/Graph1" (2453898)]
Polynomial Regression for Data1_B:
Y = A + B1*X + B2*X^2

Parameter Value Error t-Value Prob>|t|
---------------------------------------------------------------------------
A 5.2404E9 6.04228E8 8.67289 <0.0001
B1 -5.2696E6 605440.63824 -8.70375 <0.0001
B2 1324.74716 151.66342 8.73478 <0.0001
---------------------------------------------------------------------------

R-Square(COD) Adj. R-Square Root-MSE(SD) N
---------------------------------------------------------------------------
0.98938 0.98761 9741.15285 15
---------------------------------------------------------------------------

Parameter LCI UCI
---------------------------------------------------------------------------
A 3.9239E9 6.5569E9
B1 -6.58874E6 -3.95046E6
B2 994.30092 1655.19339
---------------------------------------------------------------------------

ANOVA Table:
---------------------------------------------------------------------------
Degrees of Sum of Mean
Item Freedom Squares Square F Statistic
---------------------------------------------------------------------------
Model 2 1.06089E11 5.30444E10 559.00876
Error 12 1.13868E9 9.48901E7
Total 14 1.07227E11
---------------------------------------------------------------------------

Prob>F
---------------------------------------------------------------------------
<0.0001
---------------------------------------------------------------------------

热心网友时间：2022-06-18 12:54

【1】xy做散点图
【2】图表菜单－添加趋势线，“类型”由你选，“选项”，核中“显示公式”，确定。
一元线性：y = 18789x - 4E+07 R2 = 0.9219
二次多项式：y = 1324.7x2 - 5E+06x + 5E+09
R2 = 0.9894