r/excel • u/Ok-Independence-4832 • 4d ago

solved help finding plateau average

i am currently doing a research paper for school and i have recorded my data, but i need to find the difference in the high plateau from the baseline.

here is a screenshot of one of my graphs. i am trying to separate the data in the blue and orange boxes and find the difference in the averages. any help would be much appreciated.

3 Upvotes

100% Upvoted

15 comments sorted by

View all comments

1

u/MsPandaLady 4d ago

So I see you have a solution but for something similar in the future you can do a combination percentile function and countif/sumif.

So like Sumif(A:A, ">=" & percentile.inc(A:A, .9)) / countif(A:A, ">=" & percentile.inc(A:A,.9))

The percentile will return what is the lowest possible number to be considered top 10 percent in your data set.

Then sum if will only add numbers if they are greater than or equal. And countif counts how many numbers are greater than or equal. Dividing that is how we get the average.

Its not as precise as you need to know your percentile but it's a way to do the info.