可以去我上传的资源内下载。链接见文章底部
https://download.csdn.net/download/anlog/10745385
Y | x | x平方 | x立方 | 常数项不为0时误差 满量程 | 常数项不为0时误差 满量程 | ||||
0 | 0 | 0 | 0 | 0.914% | 0.000% | ||||
1 | 10 | 100 | 1000 | -0.558% | 常数项不为0时的系数 | -1.043% | 常数项为0时的系数 | ||
2 | 21 | 441 | 9261 | -0.971% | -1.59013E-06 | 系数1 =INDEX(LINEST(A2:A12,B2:D12,TRUE,TRUE),1,1) | -1.129% | -1.29101E-06 | 系数1 =INDEX(LINEST(A2:A12,B2:D12,FALSE,TRUE),1,1) |
3 | 33 | 1089 | 35937 | -0.412% | 1.38366E-04 | 系数2 =INDEX(LINEST(A2:A12,B2:D12,TRUE,TRUE),1,2) | -0.358% | 6.66166E-05 | 系数2 =INDEX(LINEST(A2:A12,B2:D12,FALSE,TRUE),1,2) |
4 | 45 | 2025 | 91125 | 0.092% | 8.40577E-02 | 系数3 =INDEX(LINEST(A2:A12,B2:D12,TRUE,TRUE),1,3) | 0.237% | 8.90321E-02 | 系数3 =INDEX(LINEST(A2:A12,B2:D12,FALSE,TRUE),1,3) |
5 | 58 | 3364 | 195112 | 1.219% | 9.13514E-02 | 系数4 =INDEX(LINEST(A2:A12,B2:D12,TRUE,TRUE),1,4) | 1.361% | 0.00000E+00 | 系数4 =INDEX(LINEST(A2:A12,B2:D12,FALSE,TRUE),1,4) |
6 | 69 | 4761 | 328509 | 0.277% | 0.363% | ||||
7 | 82 | 6724 | 551368 | 0.377% | 0.367% | ||||
8 | 95 | 9025 | 857375 | -0.378% | -0.476% | ||||
9 | 110 | 12100 | 1331000 | -1.045% | -1.187% | ||||
10 | 135 | 18225 | 2460375 | 0.485% | 0.571% |
详细见上传的资源