OUTSOURCING PAYROLL PROCESSING PERFORMANCE METRICS

$\backslash$table$[[$No$,\backslash$table$[[$Company$],[$Code$]],$Processing Records,$\backslash$table$[[$System Payroll processing$],[($hours$)]],$Error$],[1,$AA$1,125,35,5],[2,$AA$2,399,32,2],[3,$AA$3,405,45,5],[4,$BAW$1,235,27,3],[5,$BCF$2,265,50,2],[6,$XYU$15,56,34,1],[7,$X$701,378,38,0],[8,$TVVY$2,250,45,0],[9,$MHU$1,312,29,12],[10,$MXY$4,345,35,13],[11,$UYT$15,367,22,16],[12,$YET$45,355,26,18],[13,$TTR$23,421,53,5],[14,$SS$45,1202,46,3],[15,$SS$93,21,49,2],[16,$ABC$90,156,23,0],[17,$KXYZ$88,243,39,12],[18,$UYT$56,150,41,9],[19,$TIV$56,80,59,7],[20,$KKH$100,94,62,8],[21,$AHUC$67,150,70,8],[22,$RAT$40,350,35,5],[23,$TIX$667,234,35,2],[24,$AGH$34,200,29,2],[25,$HJU$35,313,35,1],[26,$EDV$45,360,56,0],[27,$HTG$45,50,46,0],[28,$REW$44,38,29,9],[29,$WW$87$X$,10,55,12],[30,$CFG$54,180,45,14]]$

Question $1$

Based on the distribution, compute $($by formula$)$ the average and standard deviation for

$($i$)$ System processing time

$($ii$)$ Error

Repeat the process and study the overall distribution using automated MS Excel function.

$($iii$)$ System processing time

$($iv$)$ Error

Comment on the distribution.

$[30$ Marks$]$