Softpedia >Mac >Math/Scientific >XLSTAT >  Changelog

XLSTAT Changelog

What's new in XLSTAT 2018.3

May 7, 2018
  • New statistical features and options:
  • Feature extraction: Transform a collection of text documents into feature vectors based on the Bag-Of-Words model. The output can be used to compare corpus in the Word Cloud tool or to run a classification. Available in XLSTAT-Marketing under the Text mining menu.
  • Probability Plot: This new graphical feature allows you to visually control if a sample comes from a population that follows a given distribution. Available in all XLSTAT solutions under the Visualizing data menu.
  • Correlation tests: It is now possible to compute the lower and upper bound confidence intervals for Pearson, Spearman and Kendall correlation coefficients. Available in all XLSTAT solutions under the Correlations/Associations tests menu.
  • ANOVA: Lower and upper confidence intervals can now be reported for multiple comparisons tests when running a one-way or multi-way ANOVA. Available in all XLSTAT solutions under the Modeling data menu.

New in XLSTAT 2018.1 (Mar 4, 2018)

  • What's new:
  • Random Forests: This powerful machine learning algorithm allows you to make predictions based on multiple decision trees. It works for both classification and regression tasks. The method implements CART binary decision trees. Available in all XLSTAT solutions under the Machine Learning menu.
  • Proportional Hazards Model with interval censored data: A regression approach for modeling survival times using interval-censored data. Both quantitative and qualitative explanatory variables can be taken into account. This new feature is available in our XLSTAT-Biomed, XLSTAT-Ecology and XLSTAT-Premium solutions.
  • Correlation tests: New options are available for sorting (BEA or FPC method) and filtering (using R2) variables, and a more ergonomic way to display correlation matrices as an image.The above options can be accessed in all XLSTAT solutions in the Correlation tests dialog box.
  • XLSTAT Designer: Design your own customized statistical applications in Excel based on XLSTAT features. Ideal for those who want to create tailored applications which precisely match their teaching program or business needs and hand them over to their students or colleagues. Available in all XLSTAT solutions, the XLSTAT Designer can be found in XLSTAT’s main menu (PC only).

New in XLSTAT 2017.5 (Oct 19, 2017)

  • A new feature:
  • Time-Intensity
  • And many exciting new options:
  • Methods to account for autocorrelation & heteroscedasticity in Linear Regression
  • Intraclass Correlation Coefficient & other new options in Reliability Analysis
  • New options in Principal Component Analysis

New in XLSTAT 2016.4 (Jul 11, 2016)

  • A new button is displayed so that users can rerun an analysis in just one click. Available in all XLSTAT solutions.
  • Panel analysis now runs a lot faster thanks to our unique linear modeling algorithm. Available in XLSTAT-Sensory, XLSTAT-Marketing and XLSTAT-Premium.

New in XLSTAT 2016.3 (Jun 11, 2016)

  • Version 2016.3 includes two highly anticipated features:
  • Support Vector Machine (SVM): This supervised machine learning algorithm strengthens the list of algorithms that are already available in XLSTAT. SVM’s are adapted to a wide number of situations, including situations of non-linearity. It is available in all XLSTAT solutions (under the Machine Learning tab).
  • Temporal Dominance of Sensations (TDS): This feature allows to easily visualize temporal evolution of the dominance of attributes perceived by assessors. It is available in XLSTAT-Sensory, XLSTAT-Marketing and XLSTAT-Premium (under the Sensory data analysis tab).
  • In addition:
  • We have given a fresh new look to our menus.
  • Box plots can now be colored by group (all XLSTAT solutions).

New in XLSTAT 2016.2 (Apr 1, 2016)

  • Furthermore, we have worked hard on making linear regression run faster than several of our competitors, including R.
  • Motion charts and Excel 2016 compatibility are the two major surprises that come with this version:
  • Motion charts are an original way to visualize a third dimension on a 2D-scatter plot. Motion charts are included in all XLSTAT solutions (visualizing data menu).
  • XLSTAT is now compatible with Excel 2016 for Mac.

New in XLSTAT 2016.1 (Feb 17, 2016)

  • New customization features in the options tab: XLSTAT now offers 3 graphical output styles: classic, similar to what you have enjoyed until now, modern with a different set of colors, and scientific with grayscale colors. Want a style of your own? Just let us know! In the next version, we'll make it possible for you to define your own styles...
  • Data selection from variable labels in normality tests. Help us improve our future versions by sharing your feedback with us and letting us know how data selection types should be implemented in other XLSTAT features.

New in XLSTAT 2015.4.1 (Jul 11, 2015)

  • A shiny new interface for XLSTAT-3DPlot, a new feature and again, many new options adapted to your requests.
  • XLSTAT-3DPlot: enjoy perspective in your data with a renewed, fresh and modern interface.
  • XLSTAT-Time: The new cointegration of time series feature will help you test the similarity of trends on the long run according to Johansen’s approach.
  • XLSTAT-Pro:
  • Analyzing data-Correspondence analysis: draw confidence circles around row and column categories to identify those that contribute to the hypothesis of independence.
  • Modeling data-ANOVA: the Games-Howell procedure will let you run multiple pairwise comparisons without having to worry about unequal variances.
  • XLSTAT-MX: the CATA feature now includes a plot summarizing comparisons of elicitation rates for each product and the ideal product.

New in XLSTAT 2015.2.03 (Jun 22, 2015)

  • Enhanced quality and new options in response to your needs
  • XLSTAT-Pro:
  • Mixed models: computational speed has been significantly improved.
  • K Nearest Neighbors: enjoy broader machine learning possibilities by studying quantitative dependent variables.
  • ANOVA: it is now possible to automatically select the same set of factors for multiple comparisons if several dependent variables are selected in multi-factor models.
  • Ternary diagrams: a new option allows to update the diagram automatically when you change the input values.
  • RV coefficient: an easy way to evaluate the similarity between two data matrices.
  • XLSTAT-Time:
  • A new feature allows to produce elegant time series charts in a few clicks and manipulate them in real time.
  • Time series transformation: decompose your time series into three parts: trend, seasonal and random
  • XLSTAT-Life:
  • Deming regression: the computation of confidence intervals now match the EP09-A3 CLSI standard.
  • XLSTAT-MX:
  • The CATA feature now displays mean drops charts that allow an easier identification of attributes to withdraw or to include in your products, as well as those that are nice to have.
  • XLSTAT-Conjoint:
  • MaxDiff designs may now be generated in a new format (combinations in columns and respondents in rows).
  • MaxDiff analysis can now be done using the very common multinomial logit model.

New in XLSTAT 2015.2 (Feb 20, 2015)

  • XLSTAT-3D Plot: you may now intuitively filter out data on the plots to enjoy deeper and more precise data mining processes.
  • XLSTAT-PRO (ANOVA): the Benjamini-Hochberg False Discovery Rate penalization method is now available among the multiple pairwise comparisons options.
  • XLSTAT-OMICs: comparing heatmaps of different datasets is now possible thanks to the user-defined min and max color calibration option.
  • XLSTAT-MX:
  • the CATA feature has been considerably improved. It now includes a test of independence associated to the correspondence analysis and an option to filter out assessors or attributes.
  • several exciting options have been added to the TURF feature, including outputs summarizing contributions to the REACH.

New in XLSTAT 2015.1 (Jan 23, 2015)

  • New functions added in data analysis, time series, conjoint analysis and sensory analysis, machine learning, latent class cluster & regression models, heatmaps, omics data analysis, CATA data analysis, K-Nearest-Neighbors clustering, Cochran exact and Monte Carlo methods

New in XLSTAT 2014.6 (Nov 27, 2014)

  • New functions added in data analysis, time series, conjoint analysis and sensory analysis

New in XLSTAT 2014.5 (Oct 16, 2014)

  • Includes a new module, XLSTAT-OMICs (for genomic data analysis), confirming Addinsoft is committed to make available user friendly tools based on the most recent techniques.
  • The Pro module includes also a "Variables characterization" tool, a new option for sampling data, usefull for descriptive analysis of categorical data.
  • XLSTAT-MX now includes a feature for CATA (check-all-that-apply) data analysis.

New in XLSTAT 2014.4 (Jul 29, 2014)

  • Quantile regression has been developed as part of the XLSTAT-Pro module which is the core module of the XLSTAT suite, used by tens of thousands of users all around the world. Heteroscedasticity tests (White and Breusch-Pagan tests) are now available in the XLSTAT-Time module.

New in XLSTAT 2014.3 (Jun 5, 2014)

  • Brings more power for market research and customer insights:
  • XLSTAT version 2014.3 adds major features for market research with:
  • The Max-Diff analysis technique in XLSTAT-Conjoint.
  • The GSCA method (Generalized Structured Component Analysis) added to the XLSTAT-PLSPM module.
  • The new Association rules feature, capable of analyzing gigabites of data within Excel or from flat files, is a key functionality for market basket analysis. It has also several medical applications.
  • XLSTAT-Time has also been enriched with a function to test series for stationarity and unit roots.

New in XLSTAT 2014.2 (Apr 17, 2014)

  • Updates and new features:
  • Running the ANOVA:
  • An increase in speed: In order to improve the processing speed of your data treatment and large volumes of data, the analysis of variance (ANOVA) is now much faster.
  • New feature: When fitting an ANOVA model, you can now test contrasts and their significance.
  • New output in regression analysis: Studentized residuals are now available to help you validate the hypothesis on your observations.
  • Using Box Plots:
  • XLSTAT allows you to group your box plot by using various methods (by categories or by variables).
  • New descriptive statistics are available for qualitative variables(including proportions, confidence intervals around the proportions and confidence intervals around the frequencies).

New in XLSTAT 2014.1 (Feb 11, 2014)

  • Brings new features to the XLSTAT-Pro core module and to XLSTAT-DOE.
  • A new tool to manage and impute missing data is available in the Preparing data menu.
  • New results and charts have been added to our ANOVA feature, known as one of the best ANOVA tools on the market.
  • The DOE (design of experiments) module now includes a mixture designs feature.

New in XLSTAT 2013.6 (Dec 17, 2013)

  • Several procedures have been improved to handle some datasets that would have been inconceivable a few years back.

New in XLSTAT 2013.5 (Oct 19, 2013)

  • The following features have been added to the XLSTAT suite:
  • XLSTAT-Pro: Stack/Unstack option in the Data management tool (in Preparing data)
  • XLSTAT-Pro: Cubic splines (in Modeling data)
  • XLSTAT-Pro: Comparison of logistic curves for different groups on a single chart
  • XLSTAT-MX : Group constraints can be included in a TURF analysis
  • XLSTAT-Conjoint: Hierarchical Bayes approach for CBC
  • XLSTAT-Time: Durbin-Watson test and Cochrane-Orcutt model for time series
  • XLSTAT-ADA: Canonical Correspondence Analysis can now be used on large datasets
  • XLSTAT-Dose: Comparison of dose analysis curves on a single chart, and probability scale plot

New in XLSTAT 2013.2 (Mar 22, 2013)

  • This version's most notable addition is the log-linear model that includes the Poisson regression, the Gamma regression and the Exponential regression.
  • The correlation tests have been complemented with an option to sort the variables in the correlation matrix, so that variables that are highly correlated are grouped.

New in XLSTAT 2013.1 (Mar 22, 2013)

  • XLSTAT-Pro:
  • Histograms: Possibility to display dynamic histograms that allow to highlight a specific sub-sample
  • Histograms: Possibility to look for the distribution that best fits a given sample
  • Distribution fitting: Possibility to look for the distribution that best fits a given sample
  • Box plots: New option to add a legend
  • ANOVA and ANCOVA: Computations are faster for unbalanced ANOVA designs with interaction(s)
  • ANOVA with random factors: The Satterwaite approximation for the degrees of freedom of the error terms has been added
  • Nonparametric tests: The Mood test for the comparison of medians
  • Nonparametric tests: Option to compute the p-value of a Wilcoxon-Mann-Whitney test using Monte-Carlo resamplings
  • XLSTAT-MX:
  • Sensory shelf life analysis: New tool to model when a product should be removed from a shelf
  • Generalized Bradley-Terry model: New tool to analyze surveys where assessors do pairwise comparisons of products
  • Panel analysis: New results and possibility to weigh data
  • Penalty analysis: New results and possibility to weigh data
  • Product characterisation: Possibility to weigh data
  • XLSTAT-Life:
  • Parametric survival regression: Added the log-normal and extreme values models
  • XLSTAT-Power:
  • Clinical trials: Compute the sample size and power for clinical trials

New in XLSTAT 2012.4 (Jun 15, 2012)

  • Offers many improvements.
  • XLSTAT-Pro now includes a tool and a spreadsheet function to compute the biserial correlation, the PCA feature includes the possibility to display confidence ellipses if a supplementary qualitative variable is included, the Welch and Brown-Forsythe tests are available for one-way ANOVA, and profile plots are displayed after a clustering.
  • XLSTAT-Life includes a new plot after Kaplan-Meier analyses.
  • XLSTAT-MX includes new results for panel analysis and product characterization.
  • XLSTAT-PLSPM includes a new RGCCA option, a feature that confirms XLSTAT is the most complete and advanced solution for PLS path modeling.

New in XLSTAT 2012.3 (Apr 18, 2012)

  • XLSTAT-MX now includes a panel analysis tool so that you can very quickly evaluate the reliability of your panelists, and analyze if they can differentiate products or not.
  • XLSTAT-Life has been enhanced with the single and weighted Deming regressions, a complement to the Passing Bablok regression.
  • RRX analysis in XLSTAT-SPC has been improved to allow to handle simultaneously several dependent variables.
  • XLSTAT-Pro has been complemented with a "Group-by" feature based on the range.

New in XLSTAT 2012.1 (Jan 24, 2012)

  • Adds a new feature (TOST test) and various improvements including the possibility to calculate the correlation matrices and the corresponding tests by group (or sub-sample), the ability to take into account the autocorrelation in the Mann-Kendall trend test, to do pairwise comparisons after the Cochran's Q test, or to obtain bootstrap validation indices with Cox proportional hazards model.

New in XLSTAT 2011.4 (Sep 26, 2011)

  • The XLSTAT-CCR module, co-developed with Statistical Innovations Inc, adds Correlated Component Regression to the modeling techniques made available to XLSTAT users. CCR allows to build linear models based on correlated predictors.
  • New functions have been added to XLSTAT-Pro (2D plots for cross-tabs, Hosmer-Lemeshow test in logistic regression, repeated measures ANCOVA), XLSTAT-Conjoint (market generation tool) and XLSTAT-MX (Internal Preference Mapping).

New in XLSTAT 2011.3 (Jul 29, 2011)

  • The KMO (Kaiser-Meyer-Olkin) statistic has been added to complement the Factor
  • analysis and PCA tools (XLSTAT-Pro) to allow measuring the sampling adequacy.
  • A new map that automatically superimposes the preference map and a contour plot has
  • been added to the External preference mapping feature of XLSTAT-MX.
  • XLSTAT-Dose now includes a five parameter parallel lines logistic regression
  • function.

New in XLSTAT 2011.2 (Mar 23, 2011)

  • New features include new charts displayed after simple linear regressions with multiple dependent variables and after ANCOVA analyses with 1 quantitative and 1 qualitative variable.
  • The ARIMA function has been improved with the possibility to search for the best set of orders.
  • Interactions can now be used in PLS regression, where you can also now control the centering or the standardization of the explanatory variables.

New in XLSTAT 2010.6 (Dec 6, 2010)

  • XLSTAT-Pro now includes a tool that allows to quickly filter in or out data from a table.
  • The ARIMA of XLSTAT-Time allows to add explanatory variables to the model
  • With XLSTAT-Power, it is now possible to compute the sample size or the power for linear regression, ANOVA, ANCOVA, logistic regression and the Cox model.

New in XLSTAT 2010.4 (Jul 22, 2010)

  • A major upgrade with new features for XLSTAT-Pro, XLSTAT-MX, XLSTAT-Time, XLSTAT-Sim, and XLSTAT-PLSPM.
  • In XLSTAT-Pro, the multiple comparisons performed after fitting mixed models can now be computed using adjusted p-values.
  • A design of experiment feature has been added to XLSTAT-MX to allow quickly building efficient designs to collect data for sensory expirements.
  • Homogeneity tests have been added to XLSTAT-Time to allow detecting a change-point in a time series (Pettitt, SNHT, Buishand and von Neumann tests).
  • The interface of XLSTAT-Sim has been improved to make it easier to build and run Monte Carlo models.
  • XLSTAT-PLSPM now includes the REBUS algorithm to cluster observations while fitting the models.

New in XLSTAT 2010.3 (Mar 31, 2010)

  • New options for the computation of the p-values and mutliple comparisons of the Kruskal-Wallis test have been added to XLSTAT-Pro.
  • The Cochran-Mantel-Haenszel test has also been added.
  • New results are available in the XLSTAT-PLSPM module.

New in XLSTAT 2010.2 (Jan 26, 2010)

  • Two new tools. The first concerns XLSTAT-MX with the addition of a function for the characterization of products. In four clicks, you have a thorough and rigorous analysis to help you identify the descriptors that discriminate the most the products, and the most important characteristics for each product studied.
  • The Mann-Kendall trend tests have been added to XLSTAT-Time.

New in XLSTAT 2010.1 (Jan 26, 2010)

  • Includes a survey raking feature.

New in XLSTAT 2009.6 (Dec 29, 2009)

  • The PLSPM module is now fully compatible with Excel 2007.
  • XLSTAT is the only commercial software offering this very powerful and highly successful feature.
  • Excel 2007 users can enjoy a new ribbon.
  • New options are available in XLSTAT-Pro including for repeated measures ANOVA, variable transformations.
  • XLSTAT-SPC is augmented with new features allowing compatibility with SAP.

New in XLSTAT 2009.4 (Oct 27, 2009)

  • Brings the capability to handle nested designs to the ANOVA function. XLSTAT-SPC has
  • been improved with a nested option for RRX analysis. A resampling statistics function
  • has been added to XLSTAT-Pro. XLSTAT-Life is complemented by a new feature for method comparisons, including the Bland Altman plots. Measurement System Analysis and Gage R&R are now available in XLSTAT-SPC, for both quantitative measures and attributes.

New in XLSTAT 2009.2 (Mar 7, 2009)

  • Brings a new tool to compute quantiles and their confidence intervals using 5 alternative methods.
  • XLSTAT-Pro is also completed with a tool to add a curve to an Excel scatter plot with just 3 clicks.
  • Principal Coordinate Analysis is added to XLSTAT-ADA.
  • Last, the GPA now offers two alternative algorithms.

New in XLSTAT 2009.1 (Jan 23, 2009)

  • This major upgrade brings mixed models and repeated measures ANOVA to XLSTAT-Pro.

New in XLSTAT 2008.6 (Jul 17, 2008)

  • New features have been added to the most accurate and complete statistical solution for Excel. While the XLSTAT logistic regression outperforms most of the other mainstream software, an easy to use multinomial logistic regression has just been added to XLSTAT-Pro. XLSTAT-Life is enriched by unbeaten ROC curves and sensitivity and specificity features.