How to use principal component analysis in Microsoft Excel

[$horizon$]

How to perform principal component analysis in Microsoft Excel. If there is any template for this then it will be or great help. Thanks in advance.

[Go!pee]

Initially the array contains information like the year, the temperature, the percentage of voters, a note. All this information has different units and keeping them, as the year value will override the other columns and thus mask their importance. To overcome this problem you can made a centering each column: subtract the value of the average value for each column. The new average of the column will be 0. Then there is a reduction of the column: ie that you will divide each value by the standard deviation of its column.

[JyotiT]

There are certain macros you can found from internet that can help you to perform various kinds of multivariate methods. The main output is a Biplot which is a plot of rows and columns of data obtained from a cross-tab. Biplot coordinates are calculated using singular value decomposition of the data matrix.