I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future value of that employee's rating given the historical ratings I have available.
My problem is that I am not terribly familiar with complex regression analysis and I'm not quite sure how to set this up in Excel.
The data are laid out as:
EE ID, Rating 1, Rating 2, Rating 3
The problem (as I see it) is that Excel expects a Y value as input and I technically don't have any valid Y values. My Y value equivalent would be the
EE ID, which does not have any relationship to the X values.
Any idea how I can do this?