Current Volume | Browse | Search | RSSHome | Instructions for Authors | LaTeX Style Files | Editorial Board

Authors: Ilya A. Lipkovich, Eric P. Smith
Title: [download]
(7893)
Biplot and Singular Value Decomposition Macros for Excel©
Reference: Vol. 7, Issue 5, Jun 2002
Submitted 2001-03-01, Accepted 2002-06-07
Type: Article
Abstract:

The biplot display is a graph of row and column markers obtained from data that forms a two-way table. The markers are calculated from the singular value decomposition of the data matrix. The biplot display may be used with many multivariate methods to display relationships between variables and objects. It is commonly used in ecological applications to plot relationships between species and sites. This paper describes a set of Excel© macros that may be used to draw a biplot display based on results from principal components analysis, correspondence analysis, canonical discriminant analysis, metric multidimensional scaling, redundancy analysis, canonical correlation analysis or canonical correspondence analysis. The macros allow for a variety of transformations of the data prior to the singular value decomposition and scaling of the markers following the decomposition.

Paper: [download]
(7893)
Biplot and Singular Value Decomposition Macros for Excel©
(application/pdf, 455.6 KB)
Supplements: [download]
(3721)
Biplot_Version_1.zip: Biplot version 1 Excel macros and help files
(application/zip, 467.2 KB)
[download]
(1366)
Biplot_Version_2.zip: Biplot version 2 Excel macros
(application/zip, 294.9 KB)
Resources: BibTeX | OAI
Creative Commons License
This work is licensed under the licenses
Paper: Creative Commons Attribution 3.0 Unported License
Code: Commons GNU General Public License License
Current Volume | Browse | Search | RSSHome | Instructions for Authors | LaTeX Style Files | Editorial Board