Correlation softwere for manpower planning

Document Sample
Correlation softwere for manpower planning Powered By Docstoc
					The use of predictive information to plot future predicted trends: correlation possibilities
Duncan Williamson and Dr Tony Miller

Capital investment (training costs per employee) and performance          This spreadsheet software can be set
Competence and the link with performance                                  calculate the Persson Product MOment Coefficient
Performance and age bands                                                 of correlation for two or more of the kinds of
Absence and seasonal changes (possible link with SAD syndrome)            variables you see on the right of this worksheet.
Mood swings and seasonal changes (possible link with SAD)
Absence and link with weekends/public holidays                            Of course, you can change and add/delete
Appraisal grading and actual performance                                  from that list
Age trends and retirement
                                                                          Move to the example worksheet though to see thi
Personality profile and success in the business
                                                                          model in action ... and use it yourself.
Personality types and staff turnover
Staff turnover and age or sex.
Motivation and leadership style
Training investment and improved performance
Training investment and staff retention
Training and sickness reduction
Corporate culture and staff beliefs
Recruiter and retention of the employee
Recruiter and performance in the job
Recruiter and the cost of additional training
Salary cost and cost of benefits
Cost of benefits and bonus and performance
Consistency of appraisal scoring and performance in the job
Trends of training and employee




Trends of training and department.
Complaints and employee profile

Increments and performance improvement
Right sizing per percentage reduction and productivity
Employment costs by benefits, bonus and basic.
HR costs and added value created
Cost of external course fees and employee expenses while on the course.
Link between psychometric tests and performance in the job
Link between Personality profiles and performance in the job
Link between diet and sickness
 ftware can be set up to
on Product MOment Coefficient
wo or more of the kinds of
n the right of this worksheet.

change and add/delete to or


 le worksheet though to see this
 nd use it yourself.
The use of predictive information to plot future predicted trends: correlation possibilities
Duncan Williamson and Dr Tony Miller

Example
                                                                                The formula we are using is this one: Pe
           Capital Staff turnover and     Training Salary cost           Link
       investment          age or sex.         and and cost of       between
   (training costs                        sickness    benefits       diet and
   per employee)                         reduction                   sickness
 and performance
             2,771                   3         -16      298,288            46       The data on the left are SAMPLE da
             2,239                   5         -29      281,200            44
             2,731                   6         -41      200,232            39       Choose the column headings and en
             2,664                   4         -17      275,500            27       You might want to add more colum
             2,696                   6         -29      247,542            42       You might not want to use all colum
             2,013                   7         -25      223,348            26       You then need to create RANGE NA
             2,681                   3         -10      224,803            23       data (excluding the heading cell) an
             2,051                   4         -34      270,293            24       top left hand corner of the workshe
             2,838                   4         -48      238,613            44
                                                                                    Once you have entered your data sc
             2,079                   6         -43      247,118            34
                                                                                    columns ...)
             2,094                   7         -38      264,026            42
             2,997                   4         -30      254,860            33       All that is left is for you to use or ch
             2,563                   6         -49      273,658            42       will change if you add or delete colu
             2,303                   3         -24      280,932            44
             2,726                   6         -29      257,199            35       In cell G30 you will see the formula
             2,812                   4         -42      244,023            45       range names, 'cap' and 'turn'
             2,671                   3         -47      268,960            50
             2,243                   3         -45      246,998            36       'cap' is the range name for the capit
             2,874                   5         -41      233,904            40       'turn' is the range name for the staf
             2,054                   6         -35      286,405            32
                                                                                    Once you hnamed your ranges and
                                                                                    complete and all you have to do no




                                                                                Correlation Matrix

                                                                                 Capital investment
                                                                                 (training costs per
                                                                                     employee)
                                                                                 Staff turnover and
                                                                                          age or sex.
                                                                                        Training and
                                                                                 sickness reduction
                                                                                Salary cost and cost
                                                                                          of benefits
                                                                                  Link between diet
                                                                                       and sickness
a we are using is this one: Pearson's Product Moment Coefficient




 ta on the left are SAMPLE data only and your own data will be different!

   the column headings and enter your data
ight want to add more columns
ight not want to use all columns shown here
 en need to create RANGE NAMES for your data: do that by selecting each column of
excluding the heading cell) and then typing your range name in the NAME BOX in the
 t hand corner of the worksheet

you have entered your data scroll down to cell F28 (or G28 ... H28 ... if you added


t is left is for you to use or change the formulae in the range G29:K33 ... again, this
ange if you add or delete columns

G30 you will see the formula =CORREL(cap,turn) which tells you that I have used two
names, 'cap' and 'turn'

 the range name for the capital investment column: A7:A26 in this example
s the range name for the staff turnover column: B7:B26 in this example

you hnamed your ranges and edited your formulae, the correlation matrix is
ete and all you have to do now is interpret it!


              Capital investment        Staff turnover and            Training and Salary cost and cost
              (training costs per               age or sex.     sickness reduction          of benefits
                  employee) and
                    performance
                     1.0000

                     -0.3529                  1.0000

                     0.0348                  -0.2147                   1.0000

                     -0.2161                 -0.2390                   0.1809             1.0000

                     0.3126                  -0.1134                  -0.4478             0.2425
Link between diet
     and sickness




    1.0000

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:4/5/2012
language:
pages:5