Interquartile Range & Percentiles Of Data Sets

Interactive macro-enabled MS-Excel spreadsheet. Contents: Find lower quartile Q₁ median Q₂ upper quartile Q₃ & IQR (odd n). Find lower quartile Q₁ median Q₂ upper quartile Q₃ & IQR (even n). Find 10ᵗʰ percentile position P₁₀ & value V₁₀ from a set of lengths. Find 25ᵗʰ percentile position P₂₅ & value V₂₅ from a set of times. Find 50ᵗʰ percentile position P₅₀ & value V₅₀ from a set of temp’s. Find 75ᵗʰ percentile position P₇₅ & value V₇₅ from a set of points. Find 90ᵗʰ percentile position P₉₀ & value V₉₀ from a set of weights. Find 95ᵗʰ percentile position P₉₅ & value V₉₅ from a set of marks. Find the percentile position a girl’s result in points occupies. Find the percentile position a runner’s time in h & m occupies. Find the percentile position a temperature in °C to 1 d.p. occupies.