document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=1026445>Question 1026445</A>: <I><SPAN STYLE=\"word-break: break-all;\"> Emp 1  : mon:     present ,tue: present ,wed:present ,thur: present ,fri :present .sat:week off  ,sun: weekoff\r<BR>\n" );
document.write( "\n" );
document.write( "Emp 2  : mon: week off ,tue: present ,wed:present ,thur:absent ,fri :present .sat:week off  ,sun: weekoff\r<BR>\n" );
document.write( "\n" );
document.write( "Emp 3  : mon: absent ,tue: absent ,wed:present ,thur: present ,fri :present .sat:absent  ,sun: weekoff\r<BR>\n" );
document.write( "\n" );
document.write( "Emp 4  : mon:Week-Off ,tue:present ,wed:present ,thur:absent ,fri :present .sat:present   ,sun: present \r<BR>\n" );
document.write( "\n" );
document.write( "Emp 5  : mon:absent ,tue:absent ,wed:absent ,thur:absent ,fri :present .sat:present   ,sun: present \r<BR>\n" );
document.write( "\n" );
document.write( "Emp 6  : mon:Week-Off ,tue:Week-Off ,wed:Week-Off ,thur:presesnt ,fri :present .sat:present   ,sun: absent\r<BR>\n" );
document.write( "\n" );
document.write( "I have 6 employee in my organization :emp 1 to emp 6 ,\r<BR>\n" );
document.write( "\n" );
document.write( "I have their daily attendance record : Present(p) ,Absent(a) ,Week-off (-)\r<BR>\n" );
document.write( "\n" );
document.write( "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)\r<BR>\n" );
document.write( "\n" );
document.write( "Now, I want to calculate average attendance in that week \r<BR>\n" );
document.write( "\n" );
document.write( "case 1 : add all the present attendance data :\r<BR>\n" );
document.write( "\n" );
document.write( "        like : emp 1 present for 5 days \r<BR>\n" );
document.write( "\n" );
document.write( "emp 2 present for 3 days , and so on for all 6 emp \r<BR>\n" );
document.write( "\n" );
document.write( "the sum of present attendance is 22 ,\r<BR>\n" );
document.write( "\n" );
document.write( "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\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Case 2 :\r<BR>\n" );
document.write( "\n" );
document.write( "can i calculate percentage :\r<BR>\n" );
document.write( "\n" );
document.write( "emp1 Present for 5 days actual working days 5 ,so attendance :100 %\r<BR>\n" );
document.write( "\n" );
document.write( "likewise : emp2 attendance: 75% <BR>\n" );
document.write( "emp 3 attendance 50%<BR>\n" );
document.write( "emp 4: 83%  ,emp5=43%, emp 6=75%\r<BR>\n" );
document.write( "\n" );
document.write( "so average of all attendance percentage = 71%  \r<BR>\n" );
document.write( "\n" );
document.write( "so tell me ,does  this number provide an  accurate deception of attendance \r<BR>\n" );
document.write( "\n" );
document.write( "or is there a another solution , \r<BR>\n" );
document.write( "\n" );
document.write( "tip : kindly enter data in excel for understanding , substitute :<BR>\n" );
document.write( "present = p<BR>\n" );
document.write( "absent =a <BR>\n" );
document.write( "week off = \"-\"<BR>\n" );
document.write( "actual working days =AWD\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "	 </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #641705 by </B><A HREF=/tutors/aboutme.mpl?userid=rothauserc><B>rothauserc(4718)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=rothauserc><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/cgi-bin/show-face.mpl?user=rothauserc><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=641705\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> Case 1) Average attendance in that week<BR>\n" );
document.write( "Emp 1 is 5/5<BR>\n" );
document.write( "Emp 2 is 3/4<BR>\n" );
document.write( "Emp 3 is 3/6<BR>\n" );
document.write( "Emp 4 is 5/6<BR>\n" );
document.write( "Emp 5 is 3/7<BR>\n" );
document.write( "Emp 6 is 3/4<BR>\n" );
document.write( "Average attendance in that week is 22/32 = 0.6875<BR>\n" );
document.write( ":<BR>\n" );
document.write( "Case 2) Attendance using %<BR>\n" );
document.write( "Emp 1 is 1.00<BR>\n" );
document.write( "Emp 2 is 0.75<BR>\n" );
document.write( "Emp 3 is 0.50<BR>\n" );
document.write( "Emp 4 is 0.833333333<BR>\n" );
document.write( "Emp 5 is 0.428571429<BR>\n" );
document.write( "Emp 6 is 0.75<BR>\n" );
document.write( "Sum the %'s and divide by 6 is 4.2619 / 6 = 0.7103166<BR>\n" );
document.write( ":<BR>\n" );
document.write( "Case 2 is on a per employee basis<BR>\n" );
document.write( ":<BR>\n" );
document.write( "Case 1 tells us that out of 32 employee work days we had 22 employee work days<BR>\n" );
document.write( ":<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );