在Excel表中可以使用公式QUARTILE(array,quart)来很方便求得,ÀÙ»Ö|4?#bbs.3c3t.com6VÃ>ÊÊE
例如:=QUARTILE(A3:A30,1)即为Q1,ÀÙ»Ö|4?#bbs.3c3t.com6VÃ>ÊÊE
=QUARTILE(A3:A30,3)即为Q3。ÀÙ»Ö|4?#bbs.3c3t.com6VÃ>ÊÊE
IQR=Q3-Q1 ÀÙ»Ö|4?#bbs.3c3t.com6VÃ>ÊÊE
标准IQR=0.7413*IQRÀÙ»Ö|4?#bbs.3c3t.com6VÃ>ÊÊE