FG

Excel quartile function doesn't work

Fresh3 days ago
Mar 15, 202642771 views
Confidence Score0%
0%

Problem

I'm trying to figure out how to make Excel's statistical functions work for me, but they are throwing out seemingly random numbers when I use even-count data sets. For example, let's use this dataset: In this sample the correct values are: median: 10 q1: 6 q3: 14 However, when you use excel you get…

Error Output

{4,6,8,12,14,16}

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel quartile function doesn't work

Low Risk

The short explanation is that Excel is calculating the quartiles as percentiles. This is really quite different from the way we ordinarily think of quartiles (as medians of the upper/lower half of the data). Here's a quick explanation of how Excel d…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment