Question 1026445: Emp 1 : mon: present ,tue: present ,wed:present ,thur: present ,fri :present .sat:week off ,sun: weekoff
Emp 2 : mon: week off ,tue: present ,wed:present ,thur:absent ,fri :present .sat:week off ,sun: weekoff
Emp 3 : mon: absent ,tue: absent ,wed:present ,thur: present ,fri :present .sat:absent ,sun: weekoff
Emp 4 : mon:Week-Off ,tue:present ,wed:present ,thur:absent ,fri :present .sat:present ,sun: present
Emp 5 : mon:absent ,tue:absent ,wed:absent ,thur:absent ,fri :present .sat:present ,sun: present
Emp 6 : mon:Week-Off ,tue:Week-Off ,wed:Week-Off ,thur:presesnt ,fri :present .sat:present ,sun: absent
I have 6 employee in my organization :emp 1 to emp 6 ,
I have their daily attendance record : Present(p) ,Absent(a) ,Week-off (-)
actual working days (AWD) differ for each employee ,some may work for 5 days in a week and some 7 days in a week (week-off not considered part of working day)
Now, I want to calculate average attendance in that week
case 1 : add all the present attendance data :
like : emp 1 present for 5 days
emp 2 present for 3 days , and so on for all 6 emp
the sum of present attendance is 22 ,
now what should i divide this number by , if i divide 22 by 7 working days , then it would not give me a accurate number as emp1 has worked for only 5 days , so it would give me a false average as actual working days (AWD) differ for each employee , so how to get average
Case 2 :
can i calculate percentage :
emp1 Present for 5 days actual working days 5 ,so attendance :100 %
likewise : emp2 attendance: 75%
emp 3 attendance 50%
emp 4: 83% ,emp5=43%, emp 6=75%
so average of all attendance percentage = 71%
so tell me ,does this number provide an accurate deception of attendance
or is there a another solution ,
tip : kindly enter data in excel for understanding , substitute :
present = p
absent =a
week off = "-"
actual working days =AWD
Answer by rothauserc(4718)   (Show Source):
You can put this solution on YOUR website! Case 1) Average attendance in that week
Emp 1 is 5/5
Emp 2 is 3/4
Emp 3 is 3/6
Emp 4 is 5/6
Emp 5 is 3/7
Emp 6 is 3/4
Average attendance in that week is 22/32 = 0.6875
:
Case 2) Attendance using %
Emp 1 is 1.00
Emp 2 is 0.75
Emp 3 is 0.50
Emp 4 is 0.833333333
Emp 5 is 0.428571429
Emp 6 is 0.75
Sum the %'s and divide by 6 is 4.2619 / 6 = 0.7103166
:
Case 2 is on a per employee basis
:
Case 1 tells us that out of 32 employee work days we had 22 employee work days
:
|
|
|
