top of page

Median values with DigDB


I was surprised today to find that while you can use a pivot table to calculate the maximum, minimum and average of values in an array of data, there's no option to determine the median values. On the DigDB site you download an add-in for Excel that will allow you to calculate median values in an array of data in a way that mimics the function of a pivot table.

Download and unzip the .xla file, then go to File . . . Options . . . Add-ins - select Manage 'Excel Add-ins' and click go. Select the .xla file. Under the add-ins tab you should now see a DigDB menu.

So when we have data like this on a worksheet:

We can select to and go to DigDB . . . Get Median . . . in Column By Roll by up . . .

In the Calculation(s) menu you can select Median, and then choose the column whose median values you want to calculate. In this example we want to know the median number of hits each player got per season. Next select in the Group by menu select Player ID.

We get results like these:


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page