Mba Marketing - Survey on Company's Employees
Essay by souravsaharoy • November 14, 2015 • Case Study • 562 Words (3 Pages) • 1,195 Views
Description of the working data:
In this study, the survey has to be done on a particular company’s employee’s age-group 26 to 35 about gender, working experience, designation and salary. This survey took approximately 5 minutes to complete. There are 78 respondents assumed there has no wrong answer.
The purpose of this study is to capture
- Gender distribution in designation in management level.
- Existence of gender and salary relationship.
- Salary distribution about the designation.
- Existence of the relationship between experience and salary.
- Structure of Gender with Experience
Data Analysis:
Table 1. Gender Distribution in Level | ||||||
| Level | Total | ||||
Jr. Mgt | Mid. Mgt | Sr. Mgt | ||||
Gender | Female | Count | 13 | 3 | 0 | 16 |
% of Total | 16.7% | 3.8% | 0.0% | 20.5% | ||
Male | Count | 45 | 16 | 1 | 62 | |
% of Total | 57.7% | 20.5% | 1.3% | 79.5% | ||
Total | Count | 58 | 19 | 1 | 78 | |
% of Total | 74.4% | 24.4% | 1.3% | 100.0% |
In this study the above table interpreted as the company has 20.5 % female employee of which majority is in Junior Management level i.e. 81.25 % (=16.7x100/20.5) of female employee are in Junior level whereas 72.58 % (=57.7x100/79.5) of male are in Junior level. 24.4% of the employee belonging to the age group 26- 35 is in mid level.
To test the dependency between two attribute Gender (G) and Designation (D), Karl Pearson’s measure of association (C GD ) is used. If two attributes are independent C GD =0.
χ 2 GD =[132 /(58 x 16) +32/(19x16)+452/(58x62)+162/(19x62)+12/(1x62) -1]x78
=0.64658 (approx)
C GD = sqrt (χ 2 GD /n + χ 2 GD ) = 0.09067 (approx.)
i.e. There exists very poor degree of association between Gender and Designation.
Next Table suggests that most of the employee’s (=80.8% + 5.1%) salary are below 1000000/- of which 67.9 % are Male employees and among female employees 87.8% are drawn salary less than equal to 9 lacs . Only one person draw salary more than 20 lacs .
To test the existence of Gender (G) and Salary (S) relationship here also Karl Pearson’s measure of association (C GS ) is used. If two attributes are independent C GS =0.
Table 2. Gender distribution in Salary | |||||||
| Salary | Total | |||||
10 - 19 Lks | 20 -30 Lks | 3 - 9 Lks | 3 Lks | ||||
Gender | Female | Count | 2 | 0 | 13 | 1 | 16 |
% of Total | 2.6% | 0.0% | 16.7% | 1.3% | 20.5% | ||
Male | Count | 8 | 1 | 50 | 3 | 62 | |
% of Total | 10.3% | 1.3% | 64.1% | 3.8% | 79.5% | ||
Total | Count | 10 | 1 | 63 | 4 | 78 | |
% of Total | 12.8% | 1.3% | 80.8% | 5.1% | 100.0% |
χ 2 GS =[22 /(10x16)+132 /(16x63) + 12/(4x16)+82/(10x62)+12/(1x62)+502/(63x62)+32/(4x62)-1]x78
= 0.3096 (approx.)
C GS = sqrt (χ 2 GS /n + χ 2 GS ) = 0.06288 (approx.)
i.e. There exists very poor degree of association between Gender and Salary.
Following table indicate that majority of the employee those are in Junior & Mid level drawn salary between 3 lacs to 9 lacs. Only 6.897% of junior management employees are drawn salary more than 10 lacs whereas 31.578 % get salary more than 10 lacs.
...
...