Macro for calculating averages of quartiles of groups

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:45 PM GMT

Question

Hi!

I have some problems with ansheet that has multiple groups. Each group varies between 0 and 100. Between each group i have a blank row. i would like to hava a macro that calculates the averages of the first 25% numbers of that group, the second 25% numbers, third and last 25%. And that for all the groups. To be clear I don't need the he calculates 25% worst or best percentages, but i would like to know the averages of the first 25% of numbers.

I have my data of these numbers in column D and E. I would like to have the average of the first 25%, second, third and final 25% of numbers in columns G, H, I, J. The same for column e except that i would like to have that in k,l,m,n.

Thx a lot for the help! If you need sample i can send you some. Bye!

Answer

I can do it, but I need to clarify something first. Suppose the group has 5 rows. How do you want to consider the 1st 25%, 2nd 25%, etc? If the numbers are 1,2,3,4,5, what's the average of the 1st 25%, 2nd 25%, etc? Tell me how you'd like that calculated.

Question

Hi!

I have some problems with ansheet that has multiple groups. Each group varies between 0 and 100. Between each group i have a blank row. i would like to hava a macro that calculates the averages of the first 25% numbers of that group, the second 25% numbers, third and last 25%. And that for all the groups. To be clear I don't need the he calculates 25% worst or best percentages, but i would like to know the averages of the first 25% of numbers.

I have my data of these numbers in column D and E. I would like to have the average of the first 25%, second, third and final 25% of numbers in columns G, H, I, J. The same for column e except that i would like to have that in k,l,m,n.

Thx a lot for the help! If you need sample i can send you some. Bye!

Answer

Advertisement

©2021 eLuminary LLC. All rights reserved.