一元线性回归 excel
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/08/17 15:55:59
一元线性回归 excel
y x
1989 16401.6
1990 19205.4
1991 24708.7
1992 33764.6
1993 47019.6
1994 62637.1
1995 78252.3
1996 92488.7
1997 109758.7
1998 127897
1999 146314.2
2000 173236
2001 201819.9
2002 240367.5
2003 306492.6
球y与x的关系,一元线性回归的,用excel怎么算啊?
y x
1989 16401.6
1990 19205.4
1991 24708.7
1992 33764.6
1993 47019.6
1994 62637.1
1995 78252.3
1996 92488.7
1997 109758.7
1998 127897
1999 146314.2
2000 173236
2001 201819.9
2002 240367.5
2003 306492.6
球y与x的关系,一元线性回归的,用excel怎么算啊?
![一元线性回归 excel](/uploads/image/z/5018002-34-2.jpg?t=%E4%B8%80%E5%85%83%E7%BA%BF%E6%80%A7%E5%9B%9E%E5%BD%92+excel)
我用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
[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