Log in

View Full Version : Microsoft Excel-How do you calculate the Interquatile range and semi-interquatile Rng


DerBear
February 27th, 2012, 02:50 PM
Sorry title ran out of room

The end word is range.

So on excel what is a forumla for calculating the interquatile range and semi interquatile range.

I would like to know this because I am doing a little rather annoying admin work and for the life of me cannot remember the formula.

I know the formula for quartiles but do not know it for interquartile and semi interquartile range.

I am assuming there is one. I am a little confused.

Any help would be most welcome