?
Solved

Weighted Avg

Posted on 2011-03-10
6
Medium Priority
?
354 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
ID: 35099408
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
ID: 35099438
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
ID: 35099457
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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
LVL 37

Expert Comment

by:TommySzalapski
ID: 35099480
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 2000 total points
ID: 35099503
Here's the spreadsheet I used for calculations in case you find it useful.
weighted-average.xls
0
 

Author Closing Comment

by:error_prone
ID: 35104355
Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
This article covers the basics of data encryption, what it is, how it works, and why it's important. If you've ever wondered what goes on when you "encrypt" data, you can look here to build a good foundation for your personal learning.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses
Course of the Month6 days, 8 hours left to enroll

593 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