Non classic average calculation

Hello al1981 , 

To calculate a more accurate "average activity per active day" across employees, you should use a weighted average formula:

Weighted Average = Activity*Active Days /Active Days

​

This will account for differences in the number of days employees were active and therefore provide a more balanced view of the average activity.

In your example:

• Employee 1: 7.06×18.00=127.087.06 \times 18.00 = 127.087.06×18.00=127.08
• Employee 2: 7.00×16.00=112.007.00 \times 16.00 = 112.007.00×16.00=112.00
• Employee 3: 6.24×18.75=117.006.24 \times 18.75 = 117.006.24×18.75=117.00

Sum of weighted activities: 127.08+112.00+117.00=356.08

Sum of active days: 18.00+16.00+18.75=52.75

So, the weighted average activity would be= 356.08/52.75 = 6.75

This is closer to the second value you mentioned, and it's more accurate because it takes into account the different active days for each employee.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN