Problem: Trying to reproduce the output from GEMPAK for the laplacian calculation. MetPy has a different implementation of calculating the Laplacian by using the sum of the second derivative of the values. With MPCalc Plugin, create a multi-precision RPN calculator of your own design. It can handle numbers with up to 30,000 decimal digits. It can also handle numbers whose absolute values lie between.
Principal Component Analysis in Excel
Principal Component Analysis (PCA) is a powerful and popular multivariate analysis method that lets you investigate multidimensional datasets with quantitative variables. It is widely used in biostatistics, marketing, sociology, and many other fields.
XLSTAT provides a complete and flexible PCA feature to explore your data directly in Excel. XLSTAT proposes several standard and advanced options that will let you gain a deep insight into your data. You can run your PCA on raw data or on dissimilarity matrices, add supplementary variables or observations, filter out variables or observations according to different criteria to optimize PCA map readability. Also, you can perform rotations such as VARIMAX. Feel free to customize your correlation circle, your observations plot or your biplots as standard Excel charts. Copy your PCA coordinates from the results report to use them in further analyses.
We also provide many free learning resources on the web, such as a tutorial on how to run PCA in XLSTAT as well as a guide to choose an appropriate data mining or multivariate data analysis method.
What is Principal Component Analysis?
Principal Component Analysis is one of the most frequently used multivariate data analysis methods.
It is a projection method as it projects observations from a p-dimensional space with p variables to a k-dimensional space (where k < p) so as to conserve the maximum amount of information (information is measured here through the total variance of the dataset) from the initial dimensions. PCA dimensions are also called axes or Factors. If the information associated with the first 2 or 3 axes represents a sufficient percentage of the total variability of the scatter plot, the observations could be represented on a 2 or 3-dimensional chart, thus making interpretation much easier.
The Principal Component Analysis, a Data Mining tool
PCA can thus be considered as a Data Mining method as it allows to easily extract information from large datasets. There are several uses for it, including:
- The study and visualization of the correlations between variables to hopefully be able to limit the number of variables to be measured afterwards;
- Obtaining non-correlated factors which are linear combinations of the initial variables so as to use these factors in modeling methods such as linear regression, logistic regression or discriminant analysis.
- Visualizing observations in a 2- or 3-dimensional space in order to identify uniform or atypical groups of observations.
Options for Principal Component Analysis in Excel using the XLSTAT software
Pearson or Covariance?
XLSTAT offers several data treatments to be used on the input data prior to Principal Component Analysis computations:
- Pearson, the classic PCA, that automatically standardizes the data prior to computations to avoid inflating the impact of variables with high variances on the result.
- Covariance, that works on unstandardized variances and covariances (variables with high variances will play stronger roles in the outputs.
- Polychoric, for ordinal data.
Supplementary variables and observations
XLSTAT lets you add variables (qualitative or quantitative) or observations to the PCA after it has been computed. Those variables or observations are called supplementary. Flash 9.0 download mac. This can be used in several contexts. Here are two examples:
Mpcalc Plugin Free
- If the user wants to investigate roughly how a set of dependent variables relates to the others. The set of dependent variables should be used here as a set of supplementary variables and the others (i.e. independent variables) should be used to build the PCA.
- If the user simply wants to see how different categories of observations behave in the PCA space (Males vs Females for example). In this case, a qualitative supplementary variable (sex) may be used to color observations according to the sex they belong to. It is also possible to display the category centroids as well as confidence ellipses around categories.
Rotations: Varimax and others
Rotations can be applied on the factors. Several methods are available including Varimax, Quartimax, Equamax, Parsimax, Quartimin and Oblimin and Promax.
Results for Principal Component Analysis in XLSTAT
The XLSTAT PCA feature provides results relative to variables and to observations.
What are the Correlation/Covariance matrices?
This table shows the data to be used afterwards in the calculations. The type of correlation depends on the option chosen in the General tab in the dialog box. For correlations, significant correlations are displayed in bold. Brookstone scanner mouse software download for mac.
What is Bartlett's sphericity test in PCA?
Mpcalc Plugin Chrome
The results of the Bartlett sphericity test are displayed. They are used to reject or not the hypothesis according to which the variables are not correlated.
XLSTAT also proposes the Kaiser-Meyer-Olkin (KMO) test.
What are Eigenvalues and inertia?
Eigenvalues are the amount of information (inertia) summarized in every dimension. The first dimension contains the highest amount of inertia, followed by the second, then the third, and so on. XLSTAT displays eigenvalues in a table and in a chart (scree plot). The number of eigenvalues is equal to the number of non-null eigenvalues.
What are contributions?
Contributions (also called absolute contributions) represent the extent to which each variable contributed to building the corresponding PCA axis. They help in the interpretation.
How to interpret Squared cosines for the variables
Squared cosines reflect the representationquality of a variable on a PCA axis. As in other factor methods, squared cosine analysis is used to avoid interpretation errors due to projection effects. If the squared cosines of a variable associated to an axis is low, the position of the variable on this axis should not be interpreted.
What are factor scores?
Factor scores are the observations coordinates on the PCA dimensions. They are displayed in a table XLSTAT. If supplementary data have been selected, these are displayed at the end of the table.
As for the results related to variables, XLSTAT displays observations contributions (i.e. their contribution in building the PCA axes) as well as squared cosines (i.e. their representation quality on the different axes).
Results with rotations
Where a rotation has been requested, the results of the rotation are displayed with the rotation matrix first applied to the factor loadings. This is followed by the modified variability percentages associated with each of the axes involved in the rotation. The coordinates, contributions and cosines of the variables and observations after rotation are displayed in the following tables.
XLSTAT charts for Principal Component Analysis in Excel
The correlation circle or variables chart
The correlation circle (or variables chart) shows the correlations between the components and the initial variables. Supplementary variables can also be displayed in the shape of vectors.
The Observations charts
The observations charts represent the observations in the PCA space.
The Biplots
The biplots represent the observations and variables simultaneously in the new space. Here as well the supplementary variables can be plotted in the form of vectors. There are different types of biplots:
- Correlation biplot
- Distance biplot
- Symmetric biplot
XLSTAT allows to choose the coefficient whose square root is to be multiplied by the coordinates of the variables. This coefficient lets you adjust the position of the variable points in the biplot in order to make it more readable. If set to other than 1, the length of the variable vectors can no longer be interpreted as standard deviation (correlation biplot) or contribution (distance biplot).
Tutorials on how to run PCA in Excel using the XLSTAT software
This tutorial will help you run a Principal Component Analysis within Excel using the XLSTAT software.
Mpcalc Plugin Download
Physics for Mac OS X is a set of SuperCard projects to accompany a General Physics with Calculus course. A SuperCard Player installer is included.
Click here for download page and more information.
MPCalcRB is a multi-precision RPN scientific calculator for Mac OS, Linux, and Windows. It was made with Xojo.
Click here for download page and more information.
PrimeGen is a Universal Cocoa application which uses the Miller-Rabin Test as implemented by Victor Shoup's NTL to generate probable primes. The length of the primes is only limited by available memory.
Click here for download page and more information.
MPCalc Plugin is a Xojo plugin which makes available the functionality
of my multi-precision RPN scientific calculator to Xojo programmers.
Click here for download page and more information.
Complex Plugin is a plugin for Real Studio which, because of operator and function overloading, allows complex numbers to be used much like doubles and integers in REALbasic programs.
Click here for download page and more information.
Fraction Plugin is a plugin for Xojo which, because of operator and function overloading, allows fractions to be used much like doubles and integers in REALbasic programs.
Click here for download page and more information.
Matrix Plugin is a plugin for REALbasic 2008 and higher which, because of operator and function overloading, allows real matrices to be used much like doubles and integers in REALbasic programs.
Click here for download page and more information.
ComplexMatrix Plugin is a plugin for Xojo which, because of operator and function overloading, allows complex numbers and real and complex matrices to be used much like doubles and integers in REALbasic programs. You should remove my Complex and Matrix plugins.
Click here for download page and more information.
MMrng Plugin is a Real Studio plugin which provides a pseudo-random number generator which can be reseeded.
Click here for download page and more information.
Newton's Method enables you to find the real solutions of f(x) = 0 for a real function f(x).
Click here for download page and more information.
Quantum Mechanics Utilities contain applications for an undergraduate course using either Macs or Wintel computers.
Click here for download page and more information.
MKS Plugin for Real Studio allows you to construct programs which can handle numbers with units much like doubles and integers are handled. The basic MKS units are Meters, Kilograms, Seconds, Coulombs, Kelvin, and Dollars.
Click here for download page and more information.
Base Converter for Mac, Windows, or Linux is an application which converts an integer or non-integer string, including floating point strings, expressed in one base to an expression in another base.
Click here for download page and more information.
OMMs stands for 'One Million Monkeys'. That's from 'One million monkeys typing on one million typewriters..'. OMMs simulates this, one monkey at a time.
Click here for download page and more information.
PolyRootsRB is an application which finds the roots of a polynomial to any chosen accuracy using Laguerre's Method. The coefficients of the polynomial can be real or complex.
Click here for download page and more information.
PolyFactors is a Universal Cocoa application which factors univariate polynomials over the integers.
Click here for download page and more information.
Decimal Plugin is a plugin for Xojo which adds a new number type, Decimal, to REALbasic. Decimal can handle big numbers whose size is only limited by available memory.
Click here for download page and more information.
EnergyRB is an application for finding the energy eigenfunctions and eigenvalues of the one-dimensional time-independent Schroedinger equation. Almost any potential energy function can be entered by the user.
Click here for download page and more information.
MMrng Module is a REALbasic module which provides a pseudo-random generator of doubles which can be reseeded.
Click here for download page and more information.
fp Plugin is a Xojo plugin which adds eight new data types to Xojo. They are:
BigInteger, integer with length limited only by available memory
BigFloat, floating point with length limited only by available memory
BigComplex, composed of two BigFloats.
BigFraction, representing num/den where num and den are BigIntegers.
BigPoly, representing a polynomial with BigFraction coefficients.
BigFloatMatrix, representing a matrix with BigFloat elements.
BigComplexMatrix, representing a matrix with BigComplex elements.
BigFractionMatrix, representing a matrix with BigFraction elements. This replaces BigMatrix.
I am releasing fp Plugin without a restrictive license. It is unconditionally available for any use, but is without warranty.
Click here for download page and more information.
fp is an Xcode C++ project which implements unlimited length integers, multi-precision floating point numbers, multi-precision complex numbers, fractions with unlimited length integers for num/den, rational polynomials, and integer, rational, floating point, and complex matrices. It can calculate the usual transcendental functions, including the Gamma function and other special functions.
I am releasing fp without a restrictive license. It is unconditionally available for any use, but is without warranty.
Click here for download page and more information.
fp64 is an Xcode 10 C++ Command Line Tool project which implements unlimited length integers and multi-precision floating point numbers.
fp64 is the successor to fp, which used 32-bit unsigned integers for base 2^32 representation of unlimited length integers. fp64 uses 64-bit unsigned integers for base 2^64 representation of unlimited length integers. It also redefines the class mb so that the number zero does not have the unique status that it had in fp.
I am releasing fp64 as freeware with no license. It is unconditionally available for any use, but is without warranty.
Click here for download page and more information.
SolveDiffEq allows you to numerically solve differential equations and evaluate definite integrals of your choosing.
Click here for download page and more information.
CrypterRB is a freeware application made with Real Studio which implements the RSA algorithm for public-key encryption.
Click here for download page and more information.
findPrimeFactors finds the prime factors of an integer.
Click here for download page and more information.
solveLinEqs calculates the exact solution, if it exists, to a set of linear equations belonging to the Rationals. It does this by doing the calculation with the type num/den, where num and den are unlimited length integers. There is no limit to the number of linear equations which are to be solved.
Click here for download page and more information.
solveNonLinEqs uses the generalized Newton-Raphson Method to solve a set of linear or non-linear equations over the Reals.
Click here for download page and more information.
polyTool handles rational polynomials with fraction or integer coefficients of unlimited length. Both regular and modular arithmetic can be done. Primitive polynomials and their accompanying polynomial finite fields can be generated. And the roots of a rational polynomial can be found.
Click here for download page and more information.
Mpcalc Plugin Windows
Bob Delaney taught physics at Saint Louis University for 44 years.
He chaired the Department of Physics for ten years.
Now retired, one of his pastimes is writing scientific software.
You can email him at