资源描述：
《2生物统计学作业》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、第一次上机作业例2.42、利用EXCEL:总和8735样本容量150平均值58.23333众数58标准差9.107425最大值85最小值37中位数58峰度0.417596利用SPSS：偏度0.383624DescriptiveStatisticsNMinimumMaximumSumMeanStd.DeviationSkewnessKurtosisStatisticStatisticStatisticStatisticStatisticStd.ErrorStatisticStatisticStd.ErrorStatisticStd.Error体长ValidN(listwise)1
2、501503885874358.29.7118.710.409.198.472.3943、Stem-and-leafPlotFrequencyStem&Leaf3.003.7894.004.012317.004.556666778888888992&005.011122222222222233334444444440.005.555556666666667777788888888888888889999925.006.000111122222222333333444417.006.555555566667788996.007.0022237.007.55667883-00Ext
3、remes0=82)Stemwidth:10Eachleaf:1case(s)4、例题2-4组数FrequencVaiidCumulativeyPercentPercentPercent132.02.02.0Valid242.72.74.731711.311.316.04281&71&734.754026.726.761.362516.716.778.071711.311.389.3864.04.093.3974.74.798.01021.31.399.3111.7.7100.0Total150100.0100.0AouenbeiIIIIII345678例冷2«4III9101
4、1例題24纽数(1)barcharts柱状图：(步骤：analyze-->descriptivestatistics-->frenquencies-->导入体长-->charts-->barcharts)(2)piecharts饼图：(步骤：analyze-->descriptivestatistics-->frenquencies-->导入体长-->charts-->piechart)BiD3Ds口7口9On../、、口2・4・6口8・10(2)HistogramsM方图：不选withnormalcurve白勺：(步骤：analyze一一＞descriptivestatist
5、ics一一＞frenquencies一一＞导入体一一＞charts一一＞histograms)40-HistogramMean=5.23Std.Dev.=1.862N-1503020Aou・nb・iizIIII681012例题24纽数(4)scatterchart散点图:90-^80-70-5CT40-您眄I■II9II20406080100120140第二次上机习题3.8⑴纯合正常抗绣植株的株数0概率0.486752310.350461620.126166230.030279940.005450450.0007849(2)1279.214=LOG10(0.01)/(-0.00
6、36*LOGlO(EXP(1)))习题3.9习题3.10(1)(2)0.0937980.95790.0455003=BINOMDIST(4,5,0.425,0)=NORMDIST(20,16,2,1)・NORMDIST(10,16,2,1)=1-(NORMDIST(20,16,2,1)-NORMDIST(l2J6,2,1))例题4.4(1)假设Ho：u=u0=4.5mg/L,即该次测定的水中含氧量与多年平均值没有显著差别;Ha:UHPo(2)选取显著水平a二0.05T-TestOne-SampleStatisticsNMeanStd.DeviationStd.ErrorMean
7、水中含氧量104.4210.26698.08443One-SampleTestTestValue=4.5tdfSig.(2-tailed)MeanDifference95%ConfidenceIntervaloftheDifferenceLowerUpper水中含氧量-.9369.374-.07900-.2700.1120(3)由图可得,t=-0.936(4)推断：df=9,查表得，to.o5=2.262,ItI0.05,故接受Ho，否定Ha，即认为该次测定的水屮含氧量与多
