FREQUENCY(data_array,bins_array)
说明语法
求某个区域中数据的频率分布。
=FREQUENCY(L6:L115,M6:M17){}LARGE(array,k)
求样本数据中第k 个最大值。
MAX(number1,number2,...)
求样本数据中的最大数值。
MAXA(value1,value2,...)
求样本数据中的最大数值。
MIN
(number1,numbe求样本数据中的r2, ...)
最小值。
MINA(value1,value2,...)
求样本数据中的最小值。
=LARGE(L6:L115,2)=MAX(L6:L115)=MAXA(L6:L115)=MIN(L6:L115)=MINA(L6:L115)=MINA(L6:L115)示例实际应用：
某市1982年110名7岁男童的身高（CM）资料如下，试编制频数表。
频数229915182114104330
132.5
132.5
身高（CM）组段112.4109.9123.5111.9119.7113.9119.8115.9120.2117.9124.4119.9112.3121.9117.9123.9123.8125.9116.3127.9116.8129.9117.2134
118.3116.8122.9120.8116.4114.9120.1119.1125.1125.6122.7120.3119.8128126.6119124.4118.4122.8120.5123.2118.2114.8114.3124.1121.5
频数229915182114104330
6:M17)}130.8
108.2
108.2
118.4125.8118.5122.1110.3120.6123116.2122.5121.5120117.1112.2122.8120.7114.3119.5118.1120122.5112.7117.2120.4121.2114.8120.7111.5130.8113114.7119.7126.1130.5114.9125.2120.1117.4123.1120.5118.9113.2117121.8
124.1116115.4120.8118125116108.2119.7120.7117.7120129.1116.3112.4126.2122.4127.1108.2119.6122129.3114.3113.2121113125.2119.3132.5
因篇幅问题不能全部显示，请点此查看更多更全内容