logistic曲线的excel的实现方法

1、持续天数干物重g/株KXYX2(K-Y)/YYY2418.68236010.31360039.609906553.67907925213.53562414418.68238037.80640010.075640352.3101206645.336657481418.68239057.7281006.2532754241.8331053943.360275386418.682310097.3110000 3.302604691.1947114571.427335466418.6823110 151.74121001.7591503890.5648309590.319034012418.68231

2、20 275.20144000.521387162-0.6512624010.424142715X2XY2YXY54600560 24.4031 8.930585673.9849568SSxSSySPyxX均均Y均均bLn a15400 14.433648.844701.116323166-0.0031716870.894305056SSySSx3.799164 124.097Rxy拐拐点点y=k/(1+ae-bx)0.103601 -281.973X1X2Y1Y21.732051 133.258 -697.19 88.47798 330.204303X2-X1Y2-Y1-830.45 241

3、.726回回归归系系数数 相相关关系系数数最最大大增增长长速速率率g/d/株株最最大大增增长长速速率率出出现现天天数数线线性性增增长长期期持持续续天天数数处处理理kabRCK1260.0766 767.297 0.11258 -0.973737.3259.023.4N337.6499 890.223 0.11017 -0.976999.3061.623.9NK347.2036 814.872 0.10925 -0.978239.4861.424.1NPK370.4353 1014.02 0.11276 -0.9731410.4461.423.4NKZn402.2425 880.371 0.10

4、848 -0.9729210.9162.524.3原k(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)X*Y现k(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)220.7447551184.8096531164.9794855119.471145762.13140551-78.15148811a2.44563562线线性性增增长长期期干干物物质质积积累累量量g最最大大干干物物量量K线性增长期干物质积累占最大干物量的150.16260.0857.74194.94337.6557.74200.46347.2057.

5、74213.87370.4457.74232.23402.2457.74X122637506479(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)X21446761369250040966241持续天数干物重g/株KXYX2(K-Y)/YYY2402.2425120.67144602.06219546.40036075540.96461779402.24252611.2167634.8718033.55167856612.61442063402.24253754.

6、6613696.3587672841.8498345353.421887808402.242550 120.2525002.3450518450.852307510.726428092402.242564 193.0840961.0833159880.0800266970.006404272402.242579 304.9962410.318849726-1.1430353651.306529845402.242594 366.3088360.098125079-2.3215122985.38941935402.2425103 400.55106090.004219551-5.46802654

7、829.89931433X2XY2YXY3447146594.329 3.801634-586.399751SSxSSySPyxX均均Y均均bLn a7442.87592.52246963 -807.3758.1250.4752042320.1084755186.780343693SSySSx9.6188686.27209862Rxy相相关关系系数数拐拐点点最最大大增增长长速速率率出出现现天天数数y=k/(1+ae-bx)-0.9729262.505750993X1X2Y1Y21.73205150.36515074 74.6464 85.00384317.2386455X2-X1线线性性增增长

8、长期期持持续续天天数数Y2-Y1线线性性增增长长期期干干物物质质积积累累量量g24.28120051 232.235回回归归系系数数 相相关关系系数数最最大大增增长长速速率率g/d/株株最最大大增增长长速速率率出出现现天天数数线线性性增增长长期期持持续续天天数数处处理理kabRCK1260.0766767.2972046 0.11258 -0.973737.3259.023.4N337.6499890.2229918 0.11017 -0.976999.3061.623.9NK347.2036814.8717095 0.10925 -0.978239.4861.424.1NPK370.4353

9、1014.015028 0.11276 -0.9731410.4461.423.4NKZn402.2425880.3712499 0.10848 -0.9729210.9162.524.3原k(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)X*Y现k(D3*D10*(D6+D7)-D6*D7*(D3+D10)/(D3*D10-D6*D7)76.8043290692.3436427168.443877842.615375525.121708578-90.29979381-218.222156-563.2067344a880.3712499线线性性增增长长期期干干物物质质积积累累量量g最最大大干干物物量量K线性增长期干物质积累占最大干物量的150.16260.0857.74194.94337.6557.74200.46347.2057.74213.87370.4457.74232.23402.