[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

Weighted Avg

I'm having a senior moment.  If I have a table like this, what's the formula for a weighted average?  Is the value I have on the right correct?
TYPE      COUNT      SR RATE      WEIGHTED AVG
APPLE      24      8%      1%
BANANA      36      40%      9%
ORANGE      1      0%      0%
CHERRY      15      21%      2%
GRAPE      27      33%      5%
LIME      2      0%      0%
LEMON      10      18%      1%
STRAWBERRY      41      16%      4%
BLUEBERRY      10      28%      2%
Grand Total      166      25%      24%
0
error_prone
Asked:
error_prone
  • 5
1 Solution
 
TommySzalapskiCommented:
It's hard to see exactly what you are doing. Are you trying to get the average SR Rate?
In that case, multiply each count*sr_rate and divide the total by the total count. I get a little over 26%.
0
 
TommySzalapskiCommented:
Oh, yes I see what you did. The way you did it works just fine except you round too much.
Do it without rounding and you'll get close to 26.48
0
 
TommySzalapskiCommented:
Oops. I typed a number wrong. You actually would get around 23.518.
I would still do the calcutations without rounding and then round at the end if desired, but you are correct and have done it a correct way.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
TommySzalapskiCommented:
For example: If you change the 33% on Grape to 34%, then the actual weighted average is around 23.68 but you get 25 if you round each number first.
0
 
TommySzalapskiCommented:
Here's the spreadsheet I used for calculations in case you find it useful.
weighted-average.xls
0
 
error_proneAuthor Commented:
Thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now