Weighted averages

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I am not sure if this is possible. I have data that I get monthly and get an
average turn around time which is submitted-received (dates) provides # of
days. I have a spreadsheet that someone has built with macros that tallies
the # of Turn around time days X the number of claims and provides a
weighted average. Is this somthing that can be done in access? I would like
to store the data since currently the way the spreadsheets are there is 1 for
each month and you can't have more than 1 open at a time due to macros.
Please let me know if you need more info to answer this question.
 
macros that tallies the # of Turn around time days X the number of claims
and provides a weighted average.
Your formula here is incomplete. What are you dividing by to result in the
average?

I am used to weighted averages being used to determine annual evaluations
where the individual worked for multiple bosses during the year. They worked
for boss one for 2 months, boss two 3, and boss three 7.
The formula would be --
(([Boss1Score] * (2/12)) + ([Boss2Score] * (3/12)) + ([Boss1Score] *
(7/12)))/3

The score given by a boss was reduced to be weight equal to that part of a
year they supervised the individual.
 
Back
Top