MAD formula for excel
What are the set excel formula fo开发者_运维问答r calculating 1) Median Absolute Difference MAD
For interquartile range
If your data range is a1:a10 then the interquantile range equation is =percentile(a1:a10,0.75)-percentile(a1:a10,0.25)
精彩评论