XLSTAT

(1)

(2)

Outline

XLSTAT Presentation

– Excel and XLSTAT

– Users

– A modular application

– Benefits

The XLSTAT approach

Demo

Prices

2 Outline

(3)

XLSTAT Presentation

Excel and XLSTAT

(4)

Facts

MS Excel

is the most used spreadsheet software in the world

(90% market share)

Excel

is the leading numerical data storing format

is the statistical software that offers the tightest

integration with Excel

XLSTAT

is the most complete statistical software for Excel

XLSTAT’s

market share is still very little compared to SPSS’s or

Minitab’s, but it is growing fast at a 40%-50% rate per year

XLSTAT

is modular which allows to lower the cost and optimize

the usability

4 Facts

(5)

XLSTAT Presentation

Users

(6)

Users all around the world

Users in 96 countries

Distributors in UK, DE, CA, ES, JP, IL, TW, CN, BR, …

29 countries 63 countries

6 Users

(7)

Users in all industries

Half users work in companies

Users in half of the fortune

100 companies

Most users work in

marketing or R&D

More and more students

70% growth (2006-2007ytd)

7 Users

(8)

Users |Companies

Abbott, Bayer, Boeing, Cargill, Chevron, Coca Cola, Daimler, Deutsche Bank, Diageo, Exxonmobil, Firmenich, GfK, Givaudan, GlaxoSmithKline, HSBC, IFF, Illy, InBev, KFC,

Kimberly Clark, Kraft, Lloyds TSB, Mars, McDonalds, Nestlé, Nexans, Novartis, Otto Group, Pepsi Cola, Philip Morris, Procter & Gamble, Sun Microsystems, Tesco, TNS Sofres,

Unilever, Versar, Wells Fargo, Yahoo, Young & Rubicam, …

8 Utilisateurs (3)

(9)

Users |Education

Cambridge, Columbia, Cornell, Harvard, McGill, Oxford, Princeton, Rice university,

Stanford, Sydney, Washington, Wisconsin, Wharton, Yale, UC Davis, UCLA, UC San Diego, …

9 Utilisateurs (4)

(10)

Users |Research

COD, CSIC (ES), CSIRO (AU), Max Planck Institut (DE), NASA, NIH, USDA, …

10 Utilisateurs (5)

(11)

XLSTAT Presentation

Modular application

(12)

XLSTAT – A modular application

12 XLSTAT

XLSTAT-Pro

3DPlot ADA Pivot PLSPM SPC Sim Conjoint Life Dose Time PLS MX Home-made Application C++ MS Excel VBA Core module

Modules developed by Addinsoft Modules developed in partnership

(13)

XLSTAT-Pro

Preparing data

XLSTAT • Data sampling • Distribution sampling • Raking Survey • Variables transformation • Create a contingency table • Complete disjunctive tables • Discretization

• Data management • Coding

• Presence/Absence coding • Coding by ranks

(14)

XLSTAT-Pro

Preparing data

Describing data

14 XLSTAT • Descriptive statistics • Histograms • Normality tests • Similarity/Dissimilarity matrices • Multicolinearity statistics • Contingency tables

(15)

XLSTAT-Pro

Preparing data

Describing data

Visualizing data

• Univariate plots

• Scatter plots • Parallel coordinates • Axes Zoomer • Easy labels • Orthonormal plots • Plot transformer • Reposition labels • Resize a chart • Merge charts

(16)

XLSTAT-Pro

Preparing data

Describing data

Visualizing data

Analyzing data

16 XLSTAT • Factor analysis

• Principal component analysis • Discriminant analysis

• Correspondence analysis

• Multiple correspondence analysis • Multidimensional Scaling

• K-means clustering

• Agglomerative Hierarchical Clustering • Univariate clustering

(17)

XLSTAT-Pro

Preparing data

Describing data

Visualizing data

Analyzing data

Modeling data

17 XLSTAT • Distribution fitting • Linear regression • ANOVA • ANCOVA • Logistic regression • Nonparametric regression • Nonlinear regression

(18)

XLSTAT-Pro

Preparing data

Describing data

Visualizing data

Analyzing data

Modeling data

Correlation/Association tests

Parametric tests

Nonparametric tests

18 XLSTAT • Correlation tests

• Tests on contingency tables • Cochran Armitage trend test • Mantel test

• Tests on proportions (1, 2, k) • Tests on means (1, 2)

• Tests on variances (2, k) • Mantel test

• Comparison of distributions (KS test) • Tests on location (2, k)

• Cochran Q and McNemar tests • Runs test

(19)

XLSTAT-Pro

Preparing data

Describing data

Visualizing data

Analyzing data

Modeling data

Correlation/Association tests

Parametric tests

Nonparametric tests

Tools

19 XLSTAT • Clean data • Find min/max • Flag data

(20)

Complementary modules

XLSTAT-3DPlot: 3D visualization

XLSTAT-Time: Time series analysis

XLSTAT-PLS: Partial Least Square regression

XLSTAT-PLSPM: PLS Approach

XLSTAT-MX: Sensory data analysis

XLSTAT-Dose: Dose effect analysis

XLSTAT-SPC: Statistical Process Control

XLSTAT-Life: Survival analysis

XLSTAT-ADA: Advanced Data Analysis

XLSTAT-Pivot: Intelligent Pivot Tables

XLSTAT-Sim: Monte Carlo simulations

20 XLSTAT

(21)

Adding your own code

XLSTAT Architecture

You can use the XLSTAT VBA layer, or use XLSTAT as a bridge

to the XLSTAT C++ layer

Your VBA code

(22)

XLSTAT Presentation

Benefits

(23)

Easy to get started with

– Microsoft Excel is the most used spreadsheet

worldwide.

(24)

A modular multivariate analysis and

statistical package

– XLSTAT-Pro is the core statistical module of XLSTAT

which includes all the mainstream functionalities

in statistics and multivariate analysis.

– More advanced features contained in add-on

modules can be added for specific applications

.

(25)

Results organized and didactic



Results are organized

following the analytical

process



Information is given to

(26)

Share results seamlessly



_{Results stored in Microsoft Excel workbooks}



_{Results can be sent to anyone}



_{No need for the receiver to have neither a XLSTAT}

(27)

Export your results

Graphics can be copied and pasted in other

Microsoft application and keep track of the data

Export graphical and table results into image files

(.jpg, .png, .gif, .tif)

27

(28)

Available in several languages

Chinese

English

French

German

Italian

Japanese

Polish

Portuguese

Spanish

(29)

Automatisation and customization of

routine analysis

The statistical functions available in XLSTAT can be

called directly from the Visual Basic window of

Microsoft Excel.

Furthermore, XLSTAT includes a tool on every

dialog box to generate VBA codes. You can then:

• reproduce your analysis using the VBA editor

• or reload these codes to set the dialog box automatically.

– This effortless automation of routine analysis will be a

huge time saver on your part.

(30)

A great value

XLSTAT products and solutions are reasonably priced

and include top level support and assistance.

(31)

Approche XLSTAT

(32)

The XLSTAT Approach

No need to declare variables

Input data in Excel

Select the data directly with the mouse

Selections from one run to the next can be memorized

3 ways to work with XLSTAT:

– XLSTAT tab

– XLSTAT tool bar – XLSTAT functions

32 Product demo - Approach

(33)

XLSTAT Formulae

You can call directly in Excel some XLSTAT formulae

– Select the cell where the function should be computed – Go to Excel / Insert / Function

– Select the function – Enter the arguments

– Click OK to display the result in the cell

(34)

Demonstration

34 Démonstration

(35)

Prices

(36)

Licence types

Tarification 36

Period:

Yearly

Unlimited

Sector:

Private

Education

Student

Group / Campus

(37)

Yearly / Unlimited licenses

Yearly licenses Unlimited licenses

Priority support X X

Access to latest updates

X

For 1 year and then if renewal of license agreement

Discount when new modules are launched X X

Fees dispatched over the years Same price every year

A higher investment the first year

Prices 37 0 100 200 300 400 500 600 Permanent once Permanent updated Yearly 0 500 1000 1500 2000 2500 3000 3500 Permanent once -cumulative Permanent updated -cumulative Yearly - cumulative

(38)

Prices per modules (€)

Yearly licences

– 195 Euros (Pro) – 145 Euros (3DPlot)

– 125 Euros (ADA, Life, MX, PLS, PLSPM, Sim, SPC, Time) – 45 Euros (Dose)

– 395 Euros (Pivot)

Permanent licences and upgrades

– 495 Euros (Pro) – optional upgrade 175 Euros – 435 Euros (3DPlot) - optional upgrade 135 Euros

– 295 Euros (ADA, Life, MX, PLS, PLSPM, Sim, SPC, Time) - optional upgrade 85 Euros – 65 Euros (Dose) - optional upgrade 20 Euros

– 990 Euros (Pivot) - optional upgrade 175 Euros

(39)

Solutions

XLSTAT-Sensory:

– Pro to cover all your basic statistical needs;

– 3DPlot to enhance the visualization of your results by adding a third dimension to your charts

– MX that contains all the specific statistical tools sensory analysts need such as preference mapping, generalized procrustes analysis, penalty analysis, semantic differential charts, design of experiments, TURF analysis and more

– PLS to give you superior modeling possibilities with Partial Least Squares regression (PLS regression)

– ADA to perform more advanced analysis such as canonical

correspondence analysis or principal coordinates analysis among others

39

Perpetual Rental Maintenance

(40)

Solutions

XLSTAT-Medical:

– Life to provide you with specific tools for your special business needs such as survival analysis with Kaplan-Meier analysis, or life table

analysis or cumulative incidence among other useful functions;

– Dose to model the effects of a dose, if necessary taking into account an effect of natural mortality or to use advanced modeling functions as the four-parameter logistic model;

– PLS to give you superior modeling possibilities (PLS regression).

40

(41)

Solutions

XLSTAT-6S:

– SPC brings you all the essential tools for quality control management such as special control charts (subgroup, individual, attribute) as well as Pareto plots and Gage Repeatability and Reproducibility methods, – Power enables you to be certain of the quality of your analytical

results as you can monitor the statistical power of your experiments and models beforehand,

– Sim allows you to forecast the outcomes of your production and

predict the risks by creating and running simulation models based on various scenarios and statistics.

41

(42)

Solutions

XLSTAT-Predict:

– Time is necessary for forecasting complex time series such as stocks, risks or sales

– Sim allows to take into account uncertainties by considering the

inputs/outputs of a model not as fixed values but as distributions, by running simulations with different scenarios

– PLS - Partial Least Squares regression - is a very powerful alternative to build linear model based on the latent structure of the data

– Pivot allows you to quickly identify the reason why a quantity will be in a given range or not

– 3DPlot allows you to create optimal visualizations of your data and analytical results.

42

(43)