对于一组数据，请问系数的SE(标准误)到底是怎么求出来的啊？？回归系数俺知道可以通过excel求出来。俺是在公司打工的，领导催的急啊

如下：

[data]Following are results of the linearity study:

Dilution Replicate #1 Replicate #2 Mean

1 26.5 26.2 26.35

2 139 138 138.5

3 269 273 271.0

4 337 343 340.0

5 409 404 406.5[/data]

可以通过一阶回归，两阶回归，三阶回归得到他们的回归方程系数。

[data] 系数系数值系数SE t检验自由度回归标准误

b0 -52.07 16.92 3.1

b1 96.18 5.10 18.8 8 22.8

b0 -129.47 15.62 8.3

b1 162.52 11.91 13.6

b2 -11.06 1.95 5.7 7 10.3

b0 -97.48 35.88 -2.7

b1 117.58 46.91 2.5

b2 6.08 17.41 0.3

b3 -1.90 1.92 -1.0 6 10.3

Results of Regression Analysis

Order Coef.Symbol CoefficientCoefficient SE t-test Degrees freedom Std Error

Regression Value

First b0 -52.07 16.92 3.1

First b1 96.18 5.10 18.8 8 22.8

Second b0 -129.47 15.62 8.3

Second b1 162.52 11.91 13.6

Second b2 -11.06 1.95 5.7 (*) 7 10.3

Third b0 -97.48 35.88 -2.7

Third b1 117.58 46.91 2.5

Third b2 6.08 17.41 0.3

Third b3 -1.90 1.92 -1.0 6 10.[/data]