最小二乘法 相关系数 excel

n X

Y XY X^2Y^21 2.00 5.0010.00 4.0025.00=2

3.00 6.0018.009.0036.003

4.007.0028.0016.0049.00=4

5.008.0040.0025.0064.005

6.009.0054.0036.0081.00=6

7.0010.0070.0049.00100.007

8.0011.0088.0064.00121.00=8

9.0012.00108.0081.00144.009

10.0013.00130.00100.00169.00=10

11.0014.00154.00121.00196.0011

12.0015.00180.00144.00225.00n=12

13.0016.00208.00169.00256.001314.0017.00238.00196.00289.00a=

b=X ∑Y ∑XY ∑2X ∑2

Y ∑