Converting Test Scores to somewhat of a Linear Transformation
On Feb 11, 2:28 am, "MartinW" wrote:
OK forget the percentage we'll go back to Linear regression.
With E1:-70 F1:-100 E2:- 50 F2:-70
putting this formula in C1 will return B1 adjusted by linear regression.
=SLOPE($E$1:$F$1,$E$2:$F$2)*B1+INTERCEPT($E$1:$F$1 ,$E$2:$F$2)
HTH
Martin
Thanks Martin,
That did the trick. I appreciate the time that you took to review my
post and the time that you put in to get me an answer. Thanks Again!
|