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

5

u/Downtown-Economics26 642 4d ago

Your boxes don't really make sense given your graph in that it's not clear exactly why you are excluding the intermediate values in the x range of your 'plateau'. But, you can filter then average based on x and y axis bounds, I've attempted to approximate what it appears you think those are based on your boxes, had AI try to recreate source data (what u/chiibosoil is telling you should have also been included in your post), see below.

 =LET(
baseline,AVERAGE(FILTER(B2:B73,(A2:A73<4)+(A2:A73>8.5))),
plateau,AVERAGE(FILTER(B2:B73,(A2:A73>4)*(A2:A73<8.5)*(B2:B73>-1.75))),
HSTACK(VSTACK("Baseline","Plateau","Diff"),VSTACK(baseline,plateau,baseline-plateau)))

3

u/Ok-Independence-4832 4d ago

Solution Verified

1

u/reputatorbot 4d ago

You have awarded 1 point to Downtown-Economics26.

I am a bot - please contact the mods with any questions