trippypenguin
New Member
- Joined
- Feb 5, 2021
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hello dear community,
This is my first time posting a question on any online forum - I'm incredibly relieved to have come across a website like this.
I'm trying to find the weighted average(W.A) of fees by different categories (different columns) across rows, by specific range of values within the column.
I figured out how to get the W.A throughout the entire column (pretty straightforward) - I simply had to use sumproduct(column D, column A/B/C) / sum(column A/B/C) *A/B/C as in colulmns A or B or C - different categories
But, within the specific categories (columns A/B/C), I want to model scenarios for different range of values within each category (columns A/B/C).
E.g) Within column A/B/C (e.g. Height/Weight/etc), there would be 1,000 random values ranging from 150 to 210 - now I wish to find the weighted average fees for each category by a specific range of height
--> such as, weighted average fees for people that are between 150 and 160 cm tall.
How should I approach this? It was incredibly difficult for me to word this particular question concisely enough to post on google to get meaningful searches...
*Below is an example data range - I scraped this from my excel and it shows now but I'm not sure if you guys would be able to see it after I post it. I hope my question is clear!
This is my first time posting a question on any online forum - I'm incredibly relieved to have come across a website like this.
I'm trying to find the weighted average(W.A) of fees by different categories (different columns) across rows, by specific range of values within the column.
I figured out how to get the W.A throughout the entire column (pretty straightforward) - I simply had to use sumproduct(column D, column A/B/C) / sum(column A/B/C) *A/B/C as in colulmns A or B or C - different categories
But, within the specific categories (columns A/B/C), I want to model scenarios for different range of values within each category (columns A/B/C).
E.g) Within column A/B/C (e.g. Height/Weight/etc), there would be 1,000 random values ranging from 150 to 210 - now I wish to find the weighted average fees for each category by a specific range of height
--> such as, weighted average fees for people that are between 150 and 160 cm tall.
How should I approach this? It was incredibly difficult for me to word this particular question concisely enough to post on google to get meaningful searches...
*Below is an example data range - I scraped this from my excel and it shows now but I'm not sure if you guys would be able to see it after I post it. I hope my question is clear!