Solved

Weighted Avg

Posted on 2011-03-10
6
345 Views
Last Modified: 2012-05-11
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
Comment
Question by:error_prone
  • 5
6 Comments
 
LVL 37

Expert Comment

by:TommySzalapski
Comment Utility
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
 
LVL 37

Expert Comment

by:TommySzalapski
Comment Utility
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
 
LVL 37

Expert Comment

by:TommySzalapski
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 37

Expert Comment

by:TommySzalapski
Comment Utility
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
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 500 total points
Comment Utility
Here's the spreadsheet I used for calculations in case you find it useful.
weighted-average.xls
0
 

Author Closing Comment

by:error_prone
Comment Utility
Thanks
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now