1. The document contains various questions and data related to employee performance, costs, and hiring.
2. It analyzes the correlation between years of service and performance rating, finding a positive correlation of 0.82.
3. A comparison of costs for two workers, Hari and Om, finds that Om can move more boxes per hour, working the minimum hours results in a total minimum cost of 575.
4. Further questions and data tables analyze hiring rates by channel, employee experience levels by qualification, a comparison of two employee groups before and after training, and a t-test finding a difference in employee performance after training.
1. The document contains various questions and data related to employee performance, costs, and hiring.
2. It analyzes the correlation between years of service and performance rating, finding a positive correlation of 0.82.
3. A comparison of costs for two workers, Hari and Om, finds that Om can move more boxes per hour, working the minimum hours results in a total minimum cost of 575.
4. Further questions and data tables analyze hiring rates by channel, employee experience levels by qualification, a comparison of two employee groups before and after training, and a t-test finding a difference in employee performance after training.
1. The document contains various questions and data related to employee performance, costs, and hiring.
2. It analyzes the correlation between years of service and performance rating, finding a positive correlation of 0.82.
3. A comparison of costs for two workers, Hari and Om, finds that Om can move more boxes per hour, working the minimum hours results in a total minimum cost of 575.
4. Further questions and data tables analyze hiring rates by channel, employee experience levels by qualification, a comparison of two employee groups before and after training, and a t-test finding a difference in employee performance after training.
1. The document contains various questions and data related to employee performance, costs, and hiring.
2. It analyzes the correlation between years of service and performance rating, finding a positive correlation of 0.82.
3. A comparison of costs for two workers, Hari and Om, finds that Om can move more boxes per hour, working the minimum hours results in a total minimum cost of 575.
4. Further questions and data tables analyze hiring rates by channel, employee experience levels by qualification, a comparison of two employee groups before and after training, and a t-test finding a difference in employee performance after training.
Q2. 7 A B profit 50 70 Inv capacity 0 0 #VALUE! 6 material 2 3 #VALUE! 19 packaging 1 1 2 8
qty 0 6
max 420 Q2. 8 Channel no of app no of eligible no of hired Amount spent Rate of hiring Amount spent for each 1 online job boards 21 18 7 15 33.33333333 2.142857 2 social media 25 15 8 20 32 2.5 3 company websites 32 30 10 10 31.25 1 4 internal recriutment 5 3 1 2 20 2 5 employee referrals 10 10 1 2.5 10 2.5 6 email campign 10 6 1 5 10 5 7 events 15 10 0 20 0 0
- The best rate of hiring is done by online job boards and the least is done by events. - The channels are ranked according to their best rate of hiring. - The least amount of money spent for the most number of candidates hired is 1 per candidate and that channel is through company websites.
Q9 sl no Highest qualification Years of service Total experienceName 1 MS 7 12 meena kd 2 BE 5 10 arun milind 3 MBA 3 5 Sonali jain 4 MBA 2 4 pratham desai 5 BE 4 8 saleem m Total Experinece and highest qualification 14
12 8 10 12
8 4 6 5 4 10 2
0 0 1 2 3 4 5 6 7 8 MS BE MBA MBA BE
Sum of sl no by Highest qualification
8 7 6 5 4 3 2 1 0 BE MBA MS 5 4 3 2 1 0 BE MBA MS
As seen in charts above experinece and years of service are directly proportional. Employees who have the most experinece are MBA graduates and BE graduates. 11 part - c
Group A Group B 67 64 62 83 50 86 46 77 72 88 76 68 56 77 69 77 86 85 72 71 49 71 77 81 66 70
Group A Group B
Mean 65.23077 Mean 76.76923
Standard Error 3.355351 Standard Error 2.100531 Median 67 Median 77 Mode 72 Mode 77 Standard Deviation 12.09789 Standard Deviation 7.573571 Sample Variance 146.359 Sample Variance 57.35897 Kurtosis -0.77029 Kurtosis -1.14454 Skewness -0.17927 Skewness -0.08441 Range 40 Range 24 Minimum 46 Minimum 64 Maximum 86 Maximum 88 Sum 848 Sum 998 Count 13 Count 13 Here Group A Mean is > Than Group B Mean , this provides details that training give impct in performance
Ho: There is no diffffrence in Employee post training
H1: There is diffrence in Employee post tining
t-Test: Two-Sample Assuming Equal Variances
Group A Group B Mean 65.23077 76.76923 Variance 146.359 57.35897 Observations 13 13 Pooled Variance 101.859 Hypothesized Mean Difference 0 df 24 t Stat -2.91477 P(T<=t) one-tail 0.003796 t Critical one-tail 1.710882 P(T<=t) two-tail 0.007592 t Critical two-tail 2.063899 From T-test we can infer that , P value is <0.05, hence null hypothesis is rejected
Based on Mean and T test we can say that
there is diffrence in employee performance post training
