Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Weighted Avg

Posted on 2011-03-10
6
Medium Priority
?
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 provides a brief introduction to tissue engineering, the process by which organs can be grown artificially. It covers the problems with organ transplants, the tissue engineering process, and the current successes and problems of the tec…
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Suggested Courses

636 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