资源描述
单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,*,用,Excel,制作,次数分布表,(,图,),实验一,9/30/2024,1,1.,学会利用,Excel,制作次数分布表,2.,学会,利用,Excel,制作次数分布图,实验目的与意义,9/30/2024,2,以,150,尾鲢鱼的体长数据为例,用,Excel,制作次数分布表,56,49,62,78,41,47,65,45,58,55,52,52,60,51,62,78,66,45,58,58,56,46,58,70,72,76,77,56,66,58,63,57,65,85,59,58,54,62,48,63,58,52,54,55,66,52,48,56,75,55,63,75,65,48,52,55,54,62,61,62,54,53,65,42,83,66,48,53,58,57,60,54,58,49,52,56,82,63,61,48,70,69,40,56,58,61,54,53,52,43,58,52,56,61,59,54,59,64,68,51,55,47,56,58,64,67,72,58,54,52,46,57,38,39,64,62,63,67,65,52,59,60,58,46,53,57,37,62,52,59,65,62,57,51,50,48,46,58,64,68,69,73,52,48,65,72,76,56,58,63,9/30/2024,3,1,将数据按以下格式输入到,Excel,中,9/30/2024,4,2,排序,9/30/2024,5,3,求最大值、最小值、极差、组距、组中值,9/30/2024,6,4,组限、组中值,9/30/2024,7,5,次数,9/30/2024,8,COUNTIF,(,range,criteria,),Range,为需要计算其中满足条件的单元格数目的单元格区域。,(,本例为,A1,:,A150,),Criteria,为确定哪些单元格将被计算在内的条件,其形式可以为数字、表达式或文本。例如,条件可以表示为,32,、,“32”,、,“32”,或,“apples”,。,(,本例,“40”,、,“45”,等,),9/30/2024,9,6,频率、累积频率,9/30/2024,10,用,Excel,制作次数分布图,9/30/2024,11,9/30/2024,12,9/30/2024,13,9/30/2024,14,9/30/2024,15,9/30/2024,16,9/30/2024,17,9/30/2024,18,9/30/2024,19,9/30/2024,20,9/30/2024,21,9/30/2024,22,9/30/2024,23,9/30/2024,24,9/30/2024,25,9/30/2024,26,9/30/2024,27,9/30/2024,28,
展开阅读全文