View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Converting Test Scores to somewhat of a Linear Transformation

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