LG25DT 有意思吧

来源：蜘蛛抓取(WebSpider) 时间：2011-10-18 02:20 标签： 黑木耳是什么意思
Weighted Average in Excel [Formulas]
Today we will learn how to calculate weighted averages in excel using formulas.
What is weighted average ?
Weighted average or weighted mean is defined as [],
The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.
If all the weights are equal, then the weighted mean is the same as the arithmetic mean.
Why should you calculate weighted average?
or in other words, why you should
not calculate normal average?
Well, it is because, in some situations normal averages give in-correct picture. For eg. assume you are the CEO of ACME Widgets co.. Now you are looking annual salary report and being the numbers-gal you are, you wanted to find-out the average salary of your employees. You asked each department head to give you the average salary of that department to you. Here are the numbers,
Now, the average salary seems to be $ 330,000 [total all of all salaries by 5, (++ ].
You are a happy boss to find that your employees are making $330k per year.
Except, you are wrong. You have not considered the number of employees in each department before calculating the average. So, the correct average would be $76k as shown above.
How to calculate weighted average in Excel?
There is no built-in formula in Excel to calculate weighted averages. However, there is an easy fix to that. You can use SUMPRODUCT formula. By definition, SUMPRODUCT formula takes 2 or more lists of numbers and returns the sum of product of corresponding values. [related: ]
So, if you have values in A1:A10 and the corresponding weights in B1:B10, you can use SUMPRODUCT like this to get weighted average.
=SUMPRODUCT(A1:A10,B1:B10)
However, the above method works only if B1:B10 contains weights in %s totaling to 100%.
In the above average salary example, we dont have weights. But we have count of values. This is when you can use a variation of SUMPRODUCT Formula like this:
=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)
Download Weighted Average Calculation Example Workbook:
In this workbook, you can find 3 examples on how to to calculate weighted average in excel.
to understand the formulas better.
Do you use Weighted Mean / Weighted Average?
What do you use it for? What kind of challenges you face? Do you apply any tweaks to weighted average calculations? Please share your ideas / tips using comments.
More examples on Averages and Formulas:
Share this tip with your friends
Written by Chandoo
Tags: , , , , , , ,
Leave a Reply
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 450+ articles and tutorials on using excel, making better charts. .
Advanced Excel Tricks
Topics & Archives
Latest & best from Chandoo.org podcast
Send to Email Address
Your Email Address
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email. 上传我的文档
 下载
 收藏
该文档贡献者很忙，什么也没留下。
 下载此文档
正在努力加载中...
LONKING龙工LG20D(T) LG25D(T) LG30D(T)
LG35D(T) LG40D(T)内燃平衡重式叉车零件目录
下载积分：0
内容提示：LONKING龙工LG20D(T) LG25D(T) LG30D(T)
LG35D(T) LG40D(T)内燃平衡重式叉车零件目录
文档格式：PDF|
浏览次数：57|
上传日期： 22:51:28|
文档星级：
该用户还上传了这些文档
LONKING龙工LG20D(T) LG25D(T) LG30D(T)
LG35D(T) LG
官方公共微信2011年LG空调价格表(正式版)11.01_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
2011年LG空调价格表(正式版)11.01
上传于||暂无简介
阅读已结束，如果下载本文需要使用0下载券
想免费下载更多文档？
定制HR最喜欢的简历
你可能喜欢IMPORTANT MESSAGES
Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

我要回帖

更多关于 黑木耳是什么意思 的文章

 

随机推荐