Weighted Average for Indirect Cost also variance

A

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!!!!
 
M

Mark Graesser

Allison
What, and where, are the weighting factors

Regards
Mark Graesse
[email protected]

----- 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!!!
 
A

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.
 
Top