导读 数据区域为A1:A100中位数:=MEDIAN(A1:A100)众数=MODE(A1:A100)极差=MAX(A1:A100)-MIN(A1:A100)方差:=VAR(A1:A100)这只是基于样本的方法,而...
数据区域为A1:A100中位数:=MEDIAN(A1:A100)众数=MODE(A1:A100)极差=MAX(A1:A100)-MIN(A1:A100)方差:=VAR(A1:A100)这只是基于样本的方法,而其它方差,可以参考EXCEL的VARA,VARP,VARPA。