thanks Alan, that helped a lot, but I am still not quite with it.
I am assuming an SVD: A = U.S.V' with S the matrix of singular values and V the eigenvector matrix.
When I normalise the data as you say, and post-multiply it by the Eigenvector maâ€¦
statistiXL is a powerful, feature rich data analysis package that runs as an add-in to Microsoft Excel. It has been designed and written by scientists in order to meet the demanding needs of anyone requiring access to a robust, versatile statistical analysis package that is quick to learn and easy to use.