Average two numbers from separate columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to average two numbers from separate columns to create a new final rank column. I'm sure there is an easy way to do this but I can't come up with it for some reason. See sample data below
Miles Volume Final Rank
100 1,200 650
50 500 275
600 75 337.5
I am also wondering if I can use a weighted average to weight miles more heavily (70%) than volume (30%).
Any assistance is greatly appreciated.
Thanks!
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @nwatzlaf
You can use the formula: Average([Miles],[Volume])
To get to a weighted average, you can add in a calculation to to the above formula. Something like the below:
If this solves your issue please mark the answer as correct, if not let me know!
Thanks!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Maskell_Rascal ,
Thank you!! I think I just made a syntax error. I did not know the comma was the separator.
Thanks again!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You want to use this for weighted average. The formula in the solution doesn't look like it's correct. You don't need to average after you apply the weights, just add the results together.
[miles] * .7 + [volume] *.3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Greg_Murray is correct. My head was thinking in terms of weighted indexes.
