Mba Marketing - Survey on Company's Employees

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:

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.

χ 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.

...