在Excel表中可以使用公式QUARTILE(array,quart)来很方便求得,êGÃýã&ãObbs.3c3t.comR3ô]tl(:
例如:=QUARTILE(A3:A30,1)即为Q1,êGÃýã&ãObbs.3c3t.comR3ô]tl(:
=QUARTILE(A3:A30,3)即为Q3。êGÃýã&ãObbs.3c3t.comR3ô]tl(:
IQR=Q3-Q1 êGÃýã&ãObbs.3c3t.comR3ô]tl(:
标准IQR=0.7413*IQRêGÃýã&ãObbs.3c3t.comR3ô]tl(: