Thank you for replying my message. About this example, I standardized the values as follows:
xi - mean x for the ith variable]/standard deviation
If I use this equation I do not get the PC scores that you showed in your example:
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.