玻尔兹曼实验数据处理(excel)

0.097287972 7.5899E-05 0.151906049 2.5948E-05 0.23408938 3.6505E-06 0.356292211 0.00010593 0.535980282 0.00048313 0.797415496 0.00125426 1.173998648 0.00722477 1.711321919 0.00908627 2.4711183 0.00520105 3.536337448 0.00034829 5.017628072 0.06218636 7.061566808 0.53061492 23.14494259 0.61661047 1454865.506 14.65867924 0.226680846
-2.24432 -1.85151 -1.44392 -1.06132 -0.66553 -0.27181 0.08526 0.479954 0.875052 1.268355 1.661461 2.052841 -1.11548
-1.237526 1.80506115 -0.651354 0.65343669 -0.065183 0.09071119 0.5209883 0.03062092 1.1071597 0.3518384 1.693331 0.86737744 2.2795023 1.4172958 2.8656737 1.56168426 3.451845 1.10848257 4.0380163 0.23330476 4.6241876 0.41320772 5.210359 6.65454782 23.837 15.1875687 58.61713287 -20.22947669 1.125002545
线性回归
乘幂回归
1
指数回归
U
2
T=25℃
序号 1 2 3 4 5 6 7 8 9 10 11 12 求和
U
1
U
2
aU
b
* 2
U
2
aU
b 1
b exp aU
* 2
1

U
2
ln U 1
ln U
2
U
* 2
(U
2
U2)
U
* 2
(U
2
U2)
*
2
U
0.324 0.334 0.344 0.354 0.364 0.374 0.384 0.394 0.404 0.414 0.424 0.434 4.548
0.106 0.157 0.236 0.346 0.514 0.762 1.089 1.616 2.399 3.555 5.267 7.79 23.837
-1.12701 -1.09661 -1.06711 -1.03846 -1.0106 -0.9835 -0.95711 -0.9314 -0.90634 -0.88189 -0.85802 -0.83471 -11.6928 a b δ
0.107074 0.158039 0.233262 0.344291 0.508168 0.750047 1.107057 1.633997 2.411752 3.559705 5.254063 7.754908 23.82236 38.93244053 3.55998E-07 0.014209935
指数回归
U
2
b exp aU
1

* 2
(U
ຫໍສະໝຸດ Baidu
2
U2)
1.1524E-06 1.0788E-06 7.4946E-06 2.9198E-06 3.4012E-05 0.00014287 0.00032606 0.0003239 0.00016261 2.2134E-05 0.00016736 0.00123148 0.00242307 38.93244053 3.55998E-07 0.014209935