I am working on creating a job evaluation system (for compensation purposes) using Job Component, which is a statistical method. This method requires for several factors to be evaluated for each job (which eventually become the x values), along with the estimated market pay rate for each job (which become the y values).

I have chosen several factors to use (in order to determine which will be the best ones to stick with when I am finished), and gathered the data for each job in my "test" group (which consists of about 30 jobs). It seems that no matter what combination of the factors I use, or even if I use all of them that I cannot seem to get an r square value of above about .76 or so.

I have been doing the multiple regression in Excel, but I also have Minitab (which I have only used a couple of times, so I am not very familiar with the processes).

Has anyone else tried something similar, or possibly have any advice on what I can do to get this to work? Do I need a larger sample size (more than 30)?

Any pointers or advice would be greatly appreciated.