Published by the Foundation for Open Access Statistics Editors-in-chief: Bettina Grün, Torsten Hothorn, Rebecca Killick, Edzer Pebesma, Achim Zeileis    ISSN 1548-7660; CODEN JSSOBK
Authors: Ilya A. Lipkovich, Eric P. Smith
Title: Biplot and Singular Value Decomposition Macros for Excel©
Abstract: The biplot display is a graph of row and column markers obtained from data that forms a twoway 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.

Page views:: 27070. Submitted: 2001-03-01. Published: 2002-06-07.
Paper: Biplot and Singular Value Decomposition Macros for Excel©     Download PDF (Downloads: 22359)
Supplements: Biplot version 1 Excel macros and help files Download (Downloads: 12747; 467KB) Biplot version 2 Excel macros Download (Downloads: 5905; 294KB)

DOI: 10.18637/jss.v007.i05

This work is licensed under the licenses
Paper: Creative Commons Attribution 3.0 Unported License
Code: GNU General Public License (at least one of version 2 or version 3) or a GPL-compatible license.