Weighted Average for Indirect Cost also variance

[Allison]

I have four data column with over 5000(rows of grants),
I'm trying to compute the weighted average for indirect
cost.


Column Headings are:

Column A Column B Column C Column D

EIN(employer id #)Activity Code Indirect Cost Direct Cost

First,is there a logical formula or statistical formula
for Weighted Average.And second is there a variance feature
as well. Please display how to use feature for each.
Urgent Help!!!!

 

[Guest]

Allison
What, and where, are the weighting factors

Regards
Mark Graesse
(e-mail address removed)

----- Allison wrote: ----

I have four data column with over 5000(rows of grants),
I'm trying to compute the weighted average for indirect
cost


Column Headings are

Column A Column B Column C Column

EIN(employer id #)Activity Code Indirect Cost Direct Cos

First,is there a logical formula or statistical formula
for Weighted Average.And second is there a variance featur
as well. Please display how to use feature for each
Urgent Help!!!

 

[allison]

I need the weighted average over a five year period for
indirect cost related to all 5000 of our grants.

Please provide any formula examples of weighted average or
variances.

 

[Jerry W. Lewis]

We understant the concept of a weighted average. We don't know what you
are using for weights, and so cannot give you an explicit formula.

You would generally use SUMPRODUCT for a weighted average and a weighted
variance.

http://groups.google.com/groups?selm=3FFC11D7.3060403@no_e-mail.com

gives a general example.

Jerry