XLSTAT tutorials
XLSTAT tutorials help you to learn how to set-up the XLSTAT software analyses. They also provide you with examples so that you can apply different statistical methods to data. In addition, they give you an insight which will allow you to correctly interpret the results.
Getting started
- Selecting data with XLSTAT
- Choosing the way the results are displayed
- Setting up an analysis in XLSTAT
- Creating and customizing a plot with XLSTAT
- Memorizing data coordinates in the dialog box
- Save and reuse settings of an analysis, example of Principal Component Analysis
- Automate a routine analysis, example of Principal Component Analysis, in XLSTAT
Installation and settings
- Running XLSTAT the first time (Excel 2007 and 2010)
- Running XLSTAT the first time (Excel 2004, Excel 2003 and earlier versions)
- Installing XLSTAT on Windows
- Installing XLSTAT on Mac OS X
- Updating Microsoft Excel
- Running XLSTAT with admin rights under Windows Vista or Windows 7
- Changing language settings
- Updating XLSTAT
- Closing XLSTAT
- Uninstalling XLSTAT on Windows
- Uninstalling XLSTAT on Mac OS X
XLSTAT-Pro
Preparing data
- Stratified data sampling with XLSTAT
- Coding and recoding data in XLSTAT
- Creating a contingency table in XLSTAT
- Discretizing a continuous variable
- Filtering observations with XLSTAT
- Transforming the data with XLSTAT - Example of a Box-Cox transformation
- Creating a disjunctive table in XLSTAT
- Raking a survey sample using XLSTAT
Describing data
- Sampling data in a distribution and running a Normality test with XLSTAT
- Creating histograms and fitting a distribution with XLSTAT
- Creating dynamic histograms with XLSTAT
- Quantiles or percentiles with XLSTAT
- Generating Bootstrap statistics using Resampling in XLSTAT
- Computing biserial correlations with XLSTAT
Visualizing data
- Creating a scatter plot with XLSTAT
- Generating box plots with XLSTAT
- Creating histograms and fitting a distribution with XLSTAT
- Creating dynamic histograms with XLSTAT
- Creating a Parallel Coordinates Visualization with XLSTAT
- Creating a ternary diagram in XLSTAT
- Chart with error bars with just two clicks
- Add a curve on a Microsoft Excel chart with XLSTAT
- Use XLSTAT functions within an Excel sheet
- Customizing a PCA chart with XLSTAT to make it easier to interpret
- Creating and customizing a plot with XLSTAT
Analyzing data
- Running a Principal Component Analysis (PCA) with XLSTAT
- Running a Factor analysis with XLSTAT
- Running a Discriminant Analysis with XLSTAT
- Running a Correspondence Analysis (CA) from a contingency table with XLSTAT
- Running a Correspondence Analysis (CA) from a raw data table with XLSTAT and plot a 3D representation with XLSTAT-3D Plot
- Running a Multiple Correspondence Analysis (MCA) with XLSTAT
- Multidimensional Scaling (MDS) with XLSTAT
- Running an Agglomerative Hierarchical Clustering (AHC) with XLSTAT
- k-means clustering to group observations
- Clustering big datasets with XLSTAT - Using k-means clustering followed by an AHC
- Running a gaussian mixture model clustering with XLSTAT
Modeling data
- Fitting a distribution to a sample of data in XLSTAT?
- Running a simple linear regression in XLSTAT
- Multiple Linear Regression in XLSTAT
- Running a one-way ANOVA followed by multiple comparisons tests with XLSTAT
- Running a two-way unbalanced ANOVA with interactions
- Running an ANCOVA in XLSTAT
- Running a repeated measures ANOVA in XLSTAT
- Repeated measures ANOVA using the mixed models in XLSTAT
- Running a random components mixed model in XLSTAT
- Logistic regression with XLSTAT
- Running a multinomial logit model with XLSTAT
- Running an ordinal logit model with XLSTAT
- Log-linear regression with XLSTAT (Poisson regression)
- Nonparametric regression (kernel regression) with XLSTAT
- Nonlinear regression with XLSTAT
- Non linear multiple regression with XLSTAT
- Creating a CHAID classification tree with XLSTAT
Testing a hypothesis
Correlation Tests
Parametric tests
- Running a t-test or a z-test to compare the mean of a sample to a value in XLSTAT
- Running a Student's t test on two independent samples
- Running a Fisher's F-test in XLSTAT to assess the equality of variance of 2 samples
- Comparing k > 2 variances using the Levene and Bartlett tests
- Test for comparing one proportion to a value in XLSTAT
- Comparing two proportions in XLSTAT
- Comparing k proportions with XLSTAT
- Running a multinomial goodness of fit test with XLSTAT
- Testing if two samples or more described by several variables are significantly different or not
- Testing equivalence with TOST in XLSTAT
Nonparametric tests
- Running a Kruskal-Wallis test with XLSTAT
- Running a Mann-Whitney test on two independent samples with XLSTAT
- Running a Wilcoxon signed rank test on two paired samples with XLSTAT
- Running a Friedman's test with XLSTAT
- Running a Mood test to compare medians with XLSTAT
- Running a Durbin, Skillings-Mack test with XLSTAT
- Running a Page test with XLSTAT
- Running a Cochran-Mantel-Haenszel test with XLSTAT
XLSTAT-3DPlot
XLSTAT-ADA
XLSTAT-CCR
XLSTAT-Conjoint
XLSTAT-DOE
XLSTAT-Dose
XLSTAT-Life
- Generating a life table with XLSTAT-Life
- Running a Kaplan-Meier analysis with XLSTAT-Life
- Running a Nelson-Aalen analysis with XLSTAT-Life
- Running a Cumulative Incidence analyses with XLSTAT-Life
- Running a parametric survival curves analysis with XLSTAT-Life
- Cox proportional hazards model with XLSTAT-Life
- Running a Weibull model (parametric survival regression) with XLSTAT-Life
- Method comparison with the Bland Altman plot
- Method comparison with the Passing and Bablok regression with XLSTAT-Life
- Method comparison with the Deming regression with XLSTAT-Life
- Sensitivity and specificity analysis with XLSTAT-Life
- Creating an ROC curve and identify the optimal threshold value for a detection method
XLSTAT-MX
- Running a Preference Mapping in XLSTAT
- How to analyze the quality of a sensory panel with XLSTAT-MX?
- Penalty analysis with XLSTAT-MX
- Running a sensory shelf life analysis with XLSTAT-MX
- Running a Bradley-Terry model for pairwise comparisons with XLSTAT-MX
- Multiple Factor Analysis (MFA) with XLSTAT
- Generalized Procrustes Analysis with XLSTAT
- Creating a Semantic Differential Chart with XLSTAT-MX
- Product characterization in sensory analysis using XLSTAT-MX
- Running a TURF analysis with XLSTAT-MX
- Design an experiment for sensory analysis with XLSTAT-MX
XLSTAT-Pivot
XLSTAT-PLS
XLSTAT-PLSPM
XLSTAT-Power
XLSTAT-Sim
XLSTAT-SPC
- Generating an individual chart in XLSTAT-SPC
- Generating a subgroup chart with XLSTAT
- Generating an attribute control chart
- Generating a Pareto plot in XLSTAT
- Generating a time weighted chart
- Control and validate your measurement method and systems, when having several quantitative measures taken by one or more operators on several parts with XLSTAT
XLSTAT-Time
- Using differencing to obtain a stationary time series
- Identifying a trend using Mann-Kendall test with XLSTAT-Time
- Checking if a time series is homogenous with an homogeneity test in XLSTAT-Time
- Fitting a Holt-Winters seasonal multiplicative model to a time series in XLSTAT
- Fitting an ARIMA model to a time series with XLSTAT-Time
- Running a spectral analysis in XLSTAT-Time