BUS1001-Week-6-Workshop-Solution.xlsx - Employee Alan Beth...

Company 1 Company 2
Employee Aptitude z-score Employee Aptitude z-score
Alan 59 -0.190 Lachlan 72 0.218
Beth 69 1.220 Benedict 81 1.182
Edward 67 0.938 Edwin 79 0.968
Charles 65 0.656 Carney 68 -0.211
Jane 56 -0.613 Jame 74 0.432
Sandy 45 -2.165 Shana 50 -2.138
Nancy 49 -1.601 Sandra 69 -0.103
Brian 46 -2.024 Bill 54 -1.710
Helen 64 0.515 Tom 68 -0.211
Rob 70 1.361 Rayon 73 0.325
Bobby 51 -1.319 Bob 53 -1.817
William 56 -0.613 Wilson 62 -0.853
Walter 56 -0.613 Christy 72 0.218
Fred 56 -0.613 Frank 62 -0.853
Steve 59 -0.190 Taylor 72 0.218
Ray 66 0.797 Jamie 73 0.325
Harry 63 0.374 Harison 76 0.646
John 65 0.656 Kate 69 -0.103
Abe 65 0.656 Debbie 66 -0.425
Bernie 59 -0.190 Isabel 75 0.539
Larry 62 0.233 Lork 66 -0.425
Derek 59 -0.190 Monica 62 -0.853
Trina 53 -1.037 Eric 57 -1.389
Paul 55 -0.754 Sam 72 0.218
Marian 69 1.220 Mary 87 1.824
Jim 60 -0.049 Kathy 70 0.004
Timmy 68 1.079 Kim 79 0.968
Vincent 61 0.092 Dorothy 81 1.182
Jerry 68 1.079 Heather 87 1.824
Peter 55 -0.754
Donna 71 1.502
Terry 70 1.361
Alex 64 0.515
Viola 54 -0.895
Sam 67 0.938
Ingrid 64 0.515
Alice 66 0.797
Hannah 47 -1.883
Evan 53 -1.037
Jackie 62 0.233

Q 1.1.
Company 1 Company 2
Mean 60.35 69.97 =AVERAGE(B3:B42) =AVERAGE(G3:G31)
Standard deviation 7.09 9.34 =STDEV.S(B3:B42) =STDEV.S(G3:G31)
Q 1.2
Alex aptitude score is likely to be higher than
0.70 =NORM.S.DIST(C35,1)
Q 1.3
Tom aptitude score is likely to be higher than
0.42 =NORM.S.DIST(H11,1)
Q 1.4
z-score of 60 in Company 1
-0.05 =STANDARDIZE( 60, L3, L4)
The probability of having an employee’s score below 60 in company 1 48.03%
z-score of 60 in Company 2 -1.07 =STANDARDIZE( 60, M3, M4)
The probability of having an employee’s score below 60 in company 2 14.29%
Q 1.5
z-score of 70 in Company 1
1.36 =STANDARDIZE( 70, L3, L4)
The probability of having an employee’s score below 70 in company 1 91.32%
The probability of having an employee’s score above 70 in company 1 8.68%
z-score of 70 in Company 2
0.00 =STANDARDIZE( 70, M3, M4)
The probability of having an employee’s score below 70 in company 2 50.15%
The probability of having an employee’s score above 70 in company 2 49.85%
Q 1.6
The probability of having an employee’s score below 70 in company 1 91.32%
The probability of having an employee’s score below 60 in company 1 48.03%
The probability of having an employee’s score from 60 to 70 in company 1 43.29%
The probability of having an employee’s score below 70 in company 2 50.15%
The probability of having an employee’s score below 60 in company 2 14.29%
The probability of having an employee’s score from 60 to 70 in company 2 35.86%