Median for multiple groupings

2 posts / 0 new
Last post
TomRC
Offline
Joined: 10/29/2021 - 06:39
Median for multiple groupings

HI all,
I am new to IDEA and i was hoping someone could assist me. I need to compute the median for multiple grouping. Similar to the summarization tool for the average i also need the median. Hoping someone can help.
Thanks,
RC

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi TomRC,

IDEA doesn't have a median function built into it.  You would need to create an IDEAScript to do it or do it manually.  If you have version 11 of IDEA you could download the Pandas Profiling plugin from the IDEA lab as it will calculate the mean for you on a numeric field.