All software presented in this section is written by Mark van de Wiel, Department of Mathematics and Computing Science, Eindhoven University of Technology, Eindhoven, The Netherlands.

The software corresponds to the paper: M.A. van de Wiel (2004), Significance analysis of microarrays using rank scores, Kwantitatieve Methoden (The Netherlands Electronic Journal of Quantitative Methods), 71, 25-37

The Mathematica notebook can be used with hardly any knowledge of Mathematica. Evaluate the cells by clicking on them and pressing "Shift+Return". Confirm the initialization question when evaluating for the first time.

Please, send any questions or remarks to: markvdw@win.tue.nl.

The purpose of this notebook is to convert Excel data to rank score data, which can be imported by Excel again. Please NOTE that it is also possible to convert the data to rank scores within Excel!!! The following Excel functions are useful to do so: 'ABS(A1)', computes absolutes value of A1; 'RANK(A1;A1:A3,1)', computes rank of A1 within values A1, A2, A3; 'NORMSINV(A1)', computes quantile of standard normal CDF, f.e. 'NORMSINV(1/2 + A1/(2*(N+1))' computes normal signed-rank score corresponding to rank A1; SIGN(A1), returns the sign of A1. These rank score data can then be used within SAM.