Search

CATA Check-All-That-Apply analysis tutorial in Excel

Multiple Factor Analysis (MFA) on frequency tables in Excel

Electre 1 multi-criteria decision analysis in Excel

Electre 3 multi-criteria decision analysis in Excel

Parallel coordinates plots

What is Parallel Coordinates Visualization This visualization method is useful for data analysis when you need to describe groups using variables. For example, this method could be used on groups generated by Agglomerative Hierarchical Clustering. Using this method you are able to visually determine which variables are discriminative. Structure of a Parallel Coordinates plot If you consider N observations...

Missing data

Which are the types of missing values? There are three types of missing values (Allison, 2001): data missing completely at random (MCAR), data missing at random (MAR) and data not missing at random (NMAR). Data is missing completely at random (MCAR) if the event that leads to a missing data is independent of observable variables and of unobservable parameters. It should occur entirely at random. When...

Statistical Power for proportion comparison

Statistical Power analysis for the comparison of proportions in XLSTAT XLSTAT includes parametric tests and nonparametric tests to compare proportions. Thus we can use the z-test (for one or two proportions), chi-square test, the sign test or the McNemar test. XLSTAT can calculate the power or the number of observations necessary for these tests using either exact methods or approximations. When testing...

Univariate plots

Before using advanced analysis methods you must first of all reveal the data in order to identify trends, locate anomalies or simply have available essential information such as the minimum, maximum or mean of a data sample. XLSTAT offers you a large number of descriptive statistics and charts which give you a useful and relevant preview of your data. Although you can select several variables (or...

Statistical Power for logistic regression

Statistical Power for Logistic regression XLSTAT-Base offers a tool to apply logistic regression. XLSTAT-Power estimates the power or calculates the necessary number of observations associated with this model. When testing a hypothesis using a statistical test, there are several decisions to take: The null hypothesis H0 and the alternative hypothesis Ha. The statistical test to use. The type I error...

Preference Mapping (PREFMAP)

What is preference mapping? Preference Mapping allows to build maps which are useful in a variety of domains. A preference map is a decision support tool in analyses where a configuration of objects has been obtained from a first analysis (PCA, MCA, MDS), and where a table with complementary data describing the objects is available (attributes or preference data). There are two types of preference...