_MICROSOFT EXCEL 5

Excel’s definition for the third quartile will always be 0.5 less than the first definition. Again after rounding the result will either be the same or will differ by at the most one item. Excel’s definition of the second quartile, the median, is [(n + 1) / 2]th as is usually presented in statistics textbooks. ................
................