Biplot and Singular Value Decomposition Macros for Excel©

Ilya A. Lipkovich and Eric P. Smith

Journal of Statistical Software, 2002, vol. 007, issue i05

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.

Date: 2002-06-07
References: View complete reference list from CitEc
Citations: View citations in EconPapers (3)

Downloads: (external link)
https://www.jstatsoft.org/index.php/jss/article/vi ... LOT_paper_6_6_02.pdf
https://www.jstatsoft.org/index.php/jss/article/do ... Biplot_Version_1.zip
https://www.jstatsoft.org/index.php/jss/article/do ... Biplot_Version_2.zip

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jss:jstsof:v:007:i05

DOI: 10.18637/jss.v007.i05

Access Statistics for this article

Journal of Statistical Software is currently edited by Bettina Grün, Edzer Pebesma and Achim Zeileis

More articles in Journal of Statistical Software from Foundation for Open Access Statistics
Bibliographic data for series maintained by Christopher F. Baum ().