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?