Dear Researchers,

Anyone can indicate me how to calculate root mean squared error of cross-validation (leave-one-out) for interpolated data (RMSECVi), root mean squared error of cross-validation (leave-one-out) (RMSECV) and root mean squared error of calibration (RMSEC), using Microsoft office Excel, even if there are some formulas but still need some clarification and interpretation of them.

I am using HPLC retention time for prediction of toxicity LD50 by quantitative retention activity relationship method , From a qualitative point of view, it is said large differences between RMSEC, RMSECV and RMSECVi indicate a lack of robustness of the QRAR models obtained and the need for greater cautions in future predictions.

thanks for your help,

Serge