调查不同水稻品种百丛中稻纵卷叶螟幼虫的虫口数量

1、水 稻 品 种重复ABCDE141333837312393735393434035353834调查不同水稻品种百丛中稻纵卷叶螟幼虫的虫口数量，分析水稻品种对稻纵卷叶螟幼虫抗虫性是否存在显著性差异处理名称ABCDE平均数40.0035.0036.0038.0033.00处理离差的平方12.961.960.162.5611.56处理水平数(k)5重复数（n）3方差分析表 ANOVA方差变异来源平方和自由度均方F统计量PF0.05分布值F0.01分布值处理间87.60421.90009.1250.00233.485.99误差24.00102.4000总变异111.6014处理名称平均数A40.00D

2、38.00C36.00B35.00E33.00多多重重比比较较最小显著差数法LSDSx1-x20.98t(0.05,v)2.23Sx1-x2*t(0.05,n)LSD(0.05,n)2.18处理名称ADCBE字母表示法处理名称平均数40.0038.0036.0035.0033.00A40.00不显著显著显著显著aD38.00不显著不显著显著显著abC36.00显著不显著不显著显著bB35.00显著显著不显著不显著bcE33.00显著显著显著不显著c最小显著极差数法新复极差SSRSE= 0.6928SSRLSRp0.050.0523.152.1833.302.2943.372.33方差方差分析核

3、实处理数和样本数与数据表（data）中的数据是否一致！在数据工作表（data）中添加或修改了处理数和样本数，应该从新计算各处理的平均数和处理离差值。清除出错单元格的显示。求总的平方和DEVSQ(数据区)本本例例: :=DEVSQ(data!B4:I20)求处理平方和SUM(处理离差的平方数据区)*COUNT(处理重复数)如果更改了分析数据，请核实引用的单元格区域是否和数据一致。本本例例: : =SUM(B5:F5)*B753.432.38新复极差SSR检验比较表处理名称ADCBE字母表示法处理名称平均数40.0038.0036.0035.0033.00A40.00不显著显著显著显著aD38.0

4、0不显著不显著显著显著abC36.00显著不显著不显著显著bB35.00显著显著不显著不显著bcE33.00显著显著显著不显著c标记字母aa，直至某一个与之相差显著的平均数则标以字母b。再以该标有bb；再以标有bb，直至某一个与之相差显著的平均数则标以字母c。A.B.C表示 =0.01显著水平，以小写字母标记字母aa，直至某一个与之相差显著的平均数则标以字母b。再以该标有bb；再以标有bb，直至某一个与之相差显著的平均数则标以字母c。A.B.C表示 =0.01显著水平，以小写字母a.b.c表示=0.05显著水平。在数据工作表（data）中添加或修改了处理数和样本数，应该从新计算各处理的平均数和

5、处理离差值。清除出错单元格的显示。求处理平方和SUM(处理离差的平方数据区)*COUNT(处理重复数)如果更改了分析数据，请核实引用的单元格区域是否和数据一致。本本例例: : =SUM(B5:F5)*B7标记字母aa，直至某一个与之相差显著的平均数则标以字母b。再以该标有bb；再以标有bb，直至某一个与之相差显著的平均数则标以字母c。A.B.C表示 =0.01显著水平，以小写字母a.b.c表示=0.05显著水平。具有n个观察值的k组样本的符号表组别12ikx11x21xi1xk1x12x22xi2xk2:x1jx2jxijxkjx1nx2nxinxkn和T1T2TiTk均数X1X2XiXk总变

6、异自由度：nk-1组间变异自由度：k-1组内变异自由度：k(n-1)方差分析表方差变异来源平方和自由度均方F统计量P处理间SStk-1StSt/SeFDIST(F,k-1,k(n-1)误差SSek(n-1)Se总变异SSTnk-1SST/(nk-1)其中：St= SSt/(k-1)Se= Sse/(k(n-1)多重比较最小显著差数法LSDSe2为方差分析时的误差均方n 样本容量(从复数)a t检验临界值v nk-121)(-=n kijTxxS S21)(-=kitxxnS StTeSSSSSS-=nSSexx2212=-),(21vaxxtSLSDa-=最小显著极差法LSRerr若两个平均的

7、差值LSDa，则在a水平上显著。（a=0.05,或0.01）nSSEe2=使用自定义函数ssra获得SSRa值。平均数按大小排列。用各个P的LSRa值检验各平均数两级差的显著性，当两级差大于或等于LSRa，则两级差在a水平上显著。aaSSRSEL SR=函数ssra使用说明：返回SSR数值。语法：ssra(v,P,a)参数：v误差均方的自由度；P两均数差间所包含的平均数个数，a临界值)。例如：ssra(12,3,0.05)，返回自由度为12、两均数差间包含3个平均数和临界值为0.05的SSR值。TX显著性概率0.05函数ssra使用说明：返回SSR数值。语法：ssra(v,P,a)参数：v误差

8、均方的自由度；P两均数差间所包含的平均数个数，a临界值)。例如：ssra(12,3,0.05)，返回自由度为12、两均数差间包含3个平均数和临界值为0.05的SSR值。0.0523456789118.0018.0018.0018.0018.0018.0018.0018.0026.096.096.096.096.096.096.096.0934.504.504.504.504.504.504.504.5043.934.014.024.024.024.024.024.0253.643.743.793.833.833.833.833.8363.463.583.643.683.683.683.683.

9、6873.353.473.543.583.603.613.613.6183.263.393.473.523.553.563.563.5693.203.343.413.473.503.523.523.52103.153.303.373.433.463.473.473.47113.113.273.353.393.433.443.453.46123.083.233.333.363.403.423.443.44133.063.213.303.353.383.413.423.44143.033.183.273.333.373.393.413.42153.013.163.253.313.363.383.4

10、03.42163.003.153.233.303.343.373.393.41172.983.133.223.283.333.363.383.40182.973.123.213.273.323.353.373.39192.963.113.193.263.313.353.373.39202.953.103.183.253.303.343.363.38222.933.083.173.243.293.323.353.37242.923.073.153.223.283.313.343.37262.913.063.143.213.273.303.343.36282.903.043.133.203.263

11、.303.333.35302.893.043.123.203.253.293.323.35402.863.013.103.173.223.273.303.33602.832.983.083.143.203.243.283.311002.802.953.053.123.183.223.263.29100002.772.923.023.093.153.193.233.2610121416182018.0018.0018.0018.0018.0018.006.096.096.096.096.096.094.504.504.504.504.504.504.024.024.024.024.024.023

12、.833.833.833.833.833.833.683.683.683.683.683.683.613.613.613.613.613.613.563.563.563.563.563.563.523.523.523.523.523.523.473.473.473.473.473.483.463.463.463.463.473.483.463.463.463.463.473.483.453.453.463.463.473.473.443.453.463.463.473.473.433.443.453.463.473.473.433.443.453.463.473.473.423.443.453

13、.463.473.473.413.433.453.463.473.473.413.433.443.463.473.473.403.433.443.463.463.473.393.423.443.453.463.473.383.413.443.453.463.473.383.413.433.453.463.473.373.403.433.453.463.473.373.403.433.443.463.473.353.393.423.443.463.473.333.373.403.433.453.473.323.363.403.423.453.478.293.343.383.413.443.470

14、.0123456789190.0090.0090.0090.0090.0090.0090.0090.00214.0014.0014.0014.0014.0014.0014.0014.0038.268.508.608.708.808.908.909.0046.516.806.907.007.107.107.207.2055.705.966.116.186.266.336.406.4465.245.515.655.735.8l5.885.956.0074.955.225.375.455.535.615.695.7384.745.005.145.235.325.405.475.5194.604.86

15、4.995.085.175.255.325.36104.484.734.884.965.065.135.205.24114.394.634.774.864.945.015.065.12124.324.554.684.764.844.924.965.02134.264.484.624.694.744.844.884.94144.214.424.554.634.704.784.834.87154.174.374.504.584.644.724.774.81164.134.344.454.544.604.674.724.76174.104.304.414.504.564.634.684.72184.

16、074.274.384.464.534.594.644.68194.054.244.354.434.504.564.614.64204.024.224.334.404.474.534.584.61223.994.174.284.364.424.484.534.57243.964.144.244.334.394.444.494.53263.934.114.214.304.364.414.464.50283.914.084.184.284.344.394.434.47303.894.064.164.224.324.364.414.45403.823.994.104.174.244.304.344.

17、37603.763.924.034.124.174.234.274.311003.713.863.984.064.114.174.214.25100003.643.803.903.984.044.094.144.1710121416182090.0090.0090.0090.0090.0090.0014.0014.0014.0014.0014.0014.009.009.009.109.209.309.307.307.307.407.407.507.506.506.606.606.706.706.806.006.106.206.206.306.305.805.805.905.906.006.005.505.605.705.705.805.805.405.505.505.605.705.705.285.365.425.485.545.555.155.245.285.345.385.395.075.135.175.225.245.264.985.045.085.135.145.154.914.965.005.045.065.074.844.904.944.974.995.004.794.844.884.9l4.934.944.754.804.834.864.884.894.714.7