Project Management, Client Engagement, Revenue
Student - Mba (hr)
Open ended is definitely more work but richer info gathered.
Just a suggestion.
8th June 2005 From Malaysia, Kajang
8th June 2005 From India,
8th June 2005 From India, Mumbai
Don't know if its valid but its what we do! Good luck!
9th June 2005 From Malaysia, Kajang
The 'Scale' you are using is a 'Likert' Rating system : e.g. Highly Satisfied, Satisfied etc .. to Highly Dissatisfied which can be further scaled. I am just sharing my experience and stating the relevant portions which you can correlate .. though my perspective was on 'Suggesting a better system' rather than analysis, I think you may proceed as under ..
:idea: As per Likert Rating Scale 5 possible answers (Responses) are there: Highly Satisfied, Satisfied, Neutral, Dissatisfied, Highly Dissatisfied., this you can change into 3, 4 or 7 point rating scale. To do this (I did it), assign Scores to 5 point responses, e.g. 0 for Highly Dissatisfied and similarly .. 4 for Highly Satisfied .. its useful to have a quantitative measure to switch or to further scale another rating system. Once you do it, use Attriburte Measure : Total Score obtained by all Ex-employees / Total possible Score .. to keep it simple - higher the score, better the rating. Now, if you have marginal scores like 0.57 or say 0.48 or 0.6, just compliment the analysis with your qualitative data. As these are Human Perceptions, strict quality control or cross sectional analysis is not possible. If you are switching from 5 point to 2 point scale, it would be easier. Vice versa you will have to depend more on qualitative data to translate 2 point scale to 5 point scale ..
:arrow: That is to say .. I think .. if you concentrate on End Product of that Analysis I hope you will be able to find a good solution. If you are unsure, make these seperate lists: What is to be done/ improved, What Data is required, From which data analysis is to be made .. and you can identify certain Areas in which you can take individual Attribute scores, e.g. Quality of Work Life, Communication, Decision Taking and Leadership, Internal Customer Focus, Compensation & benefits, Ethical values etc .. this will give a more comprehensive picture of exit scenario and may suggest certain areas in which improvement are necessary to retain talents !
:idea: My work was a bit different from yours in which Exit Process improvement was a small area .. also it was for Managemet Cadre in an Iron & Steel Industry .. I hope this work to be of some use !
8) You can do a synthesis of various alternate methods, take the best elements and prepare your own reasoning system ..
Wishing you a very best of luck .. :D
9th June 2005 From India, Pune
i have divided the entire lot of 75 questionnaires into 7 departments.
now i analysed 1 departmant of abt 20 ex-employees and was successful in finding out a common factor for attrition in that department .
now the problem is that in another dept consisting of only 16 people who left last year ,wen i went to analyse , each person has a different reason for leaving the org. for eg some hv personal probs, some carer , some compensation , etc. due to this i would be able to say that attrition here is due to a specific prob.
so it is better that i dont do department wise at all and do it a one org as a whole .
9th June 2005 From India,
10th June 2005 From India, Hyderabad
Unfortunately SPSS cannot be legally downloaded from ANY website (you need to purchase a license) ..
What I suggest is use the 'Data Analysis' Solver packs in Microsoft Excel. Hopefully you won't require complex multivariate models, most Parametric stats can be tackled by Excel .. it needs to be installed seperately if you cannot see it in Excel now ...
The Solver is usually found in the same Installation CD from which the MS Office is installed .. just discuss it with your system admin .. if you are using version 2000 or higher it should be no prob for Installation.
Alternately there is MSTAT Package .. only prob is that its a very old DOS based application that reads data from Floppy Drive directly .. this is a pretty common utility which is handy to use. I have used SPSS 2 years ago .. lost touch a bit. There are Statistica / STATCAT, but in my opinion they are to be used only if you are planing to use Mathematical prog./ Opsearch tech.'s in your project ..
Best of luck ! :D
13th June 2005 From India, Pune
i am also doing my summer training presently n i too have to analyse the questionnaires...its always better to have close ended questions as it is much more simpler to analyse them...not only this, you may get prompt replies by employing this method as people dont find it to b a wastage of much time.
13th June 2005 From India, Jaipur
13th June 2005 From United States, Chelsea
you can convert and try to fit all the questions on a five scale rating. Instead of leaving a blank space below each Q, u can put those responses on ur scale.
At the end of the questionnaire, you can provide blank space for making suggestions.
I think u will get the right info. from this.
14th June 2005
Dear Bob, you are right .. in many Indian Corporations (except for a few one), people hardly care about Exit as there is always excessive supply of manpower than demand .. and its more like a Ritual than genuine effort for process improvement ..
To keep anonymity and encourage true feedback, can one be given access to anonymous organizational Email (to keep Identity undisclosed) .. this may work. In my project, I suggested to provide the departing employee a postage-paid envelop with a small form which he / she can fill in and drop in after joining in the new organization .. points of comparison were : (The theme) I joined for More - Salary / Freedom / Autonomy / Growth Prospects / etc.
Second part was informal Grievance counselling, so that departing employee keeps a good name of the corporation ... so in my opinion there are few more things that should be done simultaneously with data based research for process improvements ..
Fortunately there are growing concern in Indian Organizations regarding Exit Interviews, and it is gradually being taken seriously for Retention of talents.
14th June 2005 From India, Pune
You can use the attached simple tool in your Exit Interview benchmarking process. If you get the Comparative Scores of two Organizations, you may know the Areas in which your Organization needs improvement ..
The data may be obtained either by Email or Pre-paid Envelop Mailer ..
Prerequistie : Data Format Numeric only - in the range 1 to 5.
Data for both the Organization is required for valid Results ..
:D Just a suggestion .. let me know if it could be of help,
14th June 2005 From India, Pune
>Dear Bob, you are right<
>in many Indian Corporations...people hardly care about Exit as there is always excessive supply of manpower than demand .. and its more like a Ritual than genuine effort for process improvement ..<
It is the same in the US, executives seldom know what to do with the contradictory information they receive from departing employees.
>To keep anonymity and encourage true feedback, can one be given access to anonymous organizational Email (to keep Identity undisclosed) .. this may work.<
If I were a former employee, I would respond to survey from a company email address.
>In my project, I suggested to provide the departing employee a postage-paid envelop with a small form which he / she can fill in and drop in after joining in the new organization .. points of comparison were : (The theme) I joined for More - Salary / Freedom / Autonomy / Growth Prospects / etc. <
A smart former employee will say nothing but nice things about their former employer.
>Second part was informal Grievance counselling, so that departing employee keeps a good name of the corporation ... so in my opinion there are few more things that should be done simultaneously with data based research for process improvements .. <
If employers actually cared about their employees, they would not need to ask former employees about their experiences, they would already know.
>Fortunately there are growing concern in Indian Organizations regarding Exit Interviews, and it is gradually being taken seriously for Retention of talents.<
Exit interviews collect data from people who are not being retained. Be very careful, since that data can lead the employer in the wrong direction.
14th June 2005 From United States, Chelsea
15th June 2005 From India, Mumbai
It is better u convert open end question into close end question and then lay out likert scale to prepare graph on excel but when converting open ended question into close ended question includes uncertain values and hence result obtained may not give you accurate picture which need to specified in your project.
As well you can keep question open ended it self and then draw graph which gives you the details what employee mean to say where as again it is difficult prepare result column.
15th June 2005 From India, Bangalore
Those were my experiences with an Iron and Steel Company (Its ISO 14001 Co.) which was doing Entire Corporate Restructuring in terms of HRD .. in that connection I was told to analyze 156 strategic level managers' Exit data .. HR Dept. was almost convinced that Exit Data was nothing but a box of garbage .. The Exit Process Analysis was actually frindge area of my project (Core project was on Organizational Health Analysis, (not exactly a climate survey)) ..
I happened to read something about Model based Estimation and Forecasting, and worked on a Statistical model for them, It worked .. I got a list of around 40 issues that needed immediate action from the HR .. By "Retention" I meant to say "Not to repeat the mistakes because of which we lost employees" ..
And, there are certain issues which may hold true in India and may not in the US (and Vice versa) because of cultural impacts on employee psychology .. The idea worked in the Indian organization, however I know its difficult to generalize all the cases ..
However .. what I truly believe is .. Employee do not leave organization, they tend to leave their immediate superior .. (i.e., they do not change profession, they change their bosses. This is just my experience, not verified using any survey data ... ) :D
Thank you for the reply ..
15th June 2005 From India, Pune
Boss is part of package that comes with job, but his share in staying isn't much.' I like my boss so I am in the job' doesn't sound convincing
15th June 2005 From India, Mumbai