title: Using QUARTILE in an Excel pivot table to summarise data by sub-populations
body: <p>I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection of values for individuals identified as belonging to various subpopulations:</p>
  
  <pre><code>  IndivID   SubPopID  Value
       1          A       33.56
       2          E       42.31
       3          D       16.35
       4          A       50.59
       5          F       80.63
       ...
  </code></pre>
  
  <p>There are over 10,000 individuals in this table, and over 50 subpopulations.</p>
  
  <p>I would like to calculate the 5-number summary (Min, Q1, Median, Q3, Max) for each of the subpopulations.</p>
  
  <p>Min and Max are easy in a pivot table.  But Q1, Q2 (median), and Q3 don't seem to be possible.</p>
  
  <p><strong>Question</strong></p>
  
  <p><strong>Is there any way to calculate the quartiles for each subpopulation in a pivot table in Excel?</strong></p>
  
  <p>The answer should look like this:</p>
  
  <pre><code>SubPopID      Min     Q1     Q2        Q3      Max
     A         3.23    12.06   20.35   28.29     50.59
     B 
     C
     ...
  </code></pre>