I have a data set of values for a particular measured metric for employees for the year 2013, and a set of values for the same measured metric for the year 2014.
I am looking to assess the repeatability of this metric from year to year for these raw numbers, and then I hope to adjust these values using other measured metrics from the corresponding year in order to improve the repeatability, in order to be able to better predict this year's values for the metric from the data I already have available.
The first thing I have tried is plotting the 2013 values on the x-axis vs the 2014 values on the y-axis and calculating the R-squared coefficient for this plot, which comes out at about 0.4.
The second thing I have tried is plotting the 2013 values on the x-axis and the difference between the 2013 and 2014 values on the y-axis and calculating the R-squared coefficient for this plot, which comes out at much lower than the above method.
My questions are: (1) is there a reason that the R-squared value in the second method is so much lower than in the first method, and (2) is there a better way for me to measure this repeatability and better predict future years' values?
Thanks in advance!