LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Calculating the median was sort of covered in this post, but it's deeply embedded as part of a larger calculation. I've created a simplified version here. If the number of records is odd, then the middle value is returned. If the number of records is even, the average of the middle two values is returned.
Attachments:
calculateMedian.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: islandz

Working with this, as well as Gerry from support, I created a group that allows you to find the Median and Average for groups of data. For example, in the file I used, there was SIC and Employee Size. I needed the Median and Average employees grouped by SIC.

Median_Average.brg