Introduction Outline XLSTAT Presentation Excel and XLSTAT Users - PowerPoint PPT Presentation

Introduction

Outline XLSTAT Presentation – Excel and XLSTAT – Users – A modular application – Benefits The XLSTAT approach Demo Prices Outline 2

XLSTAT Presentation Excel and XLSTAT 3

Facts MS Excel is the most used spreadsheet software in the world (90% market share) Excel is the leading numerical data storing format XLSTAT 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 Facts 4

XLSTAT Presentation Users 5

Users all around the world Users in 96 countries 63 countries 29 countries Distributors in UK, DE, CA, ES, JP, IL, TW, CN, BR, … Users 6

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) Users 7

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, … Utilisateurs (3) 8

Users |Education Cambridge, Columbia, Cornell, Harvard, McGill, Oxford, Princeton, Rice university, Stanford, Sydney, Washington, Wisconsin, Wharton, Yale, UC Davis, UCLA, UC San Diego, … Utilisateurs (4) 9

Users |Research COD, CSIC (ES), CSIRO (AU), Max Planck Institut (DE), NASA, NIH, USDA, … Utilisateurs (5) 10

XLSTAT Presentation Modular application 11

XLSTAT – A modular application 3DPlot MX ADA PLS Pivot C++ XLSTAT- Home-made VBA Time PLSPM Application Pro MS Dose SPC Excel Life Sim Conjoint Core module Modules developed by Addinsoft Modules developed in partnership XLSTAT 12

XLSTAT-Pro Preparing data • 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 XLSTAT

XLSTAT-Pro Preparing data Describing data • Descriptive statistics • Histograms • Normality tests • Similarity/Dissimilarity matrices • Multicolinearity statistics • Contingency tables XLSTAT 14

XLSTAT-Pro Preparing data Describing data • Univariate plots Visualizing data • Scatter plots • Parallel coordinates • Axes Zoomer • Easy labels • Orthonormal plots • Plot transformer • Reposition labels • Resize a chart • Merge charts

XLSTAT-Pro Preparing data Describing data Visualizing data • Factor analysis • Principal component analysis Analyzing data • Discriminant analysis • Correspondence analysis • Multiple correspondence analysis • Multidimensional Scaling • K-means clustering • Agglomerative Hierarchical Clustering • Univariate clustering XLSTAT 16

XLSTAT-Pro Preparing data Describing data Visualizing data • Distribution fitting Analyzing data • Linear regression Modeling data • ANOVA • ANCOVA • Logistic regression • Nonparametric regression • Nonlinear regression • Classification and regression trees XLSTAT 17

XLSTAT-Pro Preparing data • Correlation tests Describing data • Tests on contingency tables • Cochran Armitage trend test Visualizing data • Mantel test Analyzing data Modeling data • Tests on proportions (1, 2, k) • Tests on means (1, 2) Correlation/Association tests • Tests on variances (2, k) • Mantel test Parametric tests Nonparametric tests • Comparison of distributions (KS test) • Tests on location (2, k) • Cochran Q and McNemar tests • Runs test XLSTAT 18

XLSTAT-Pro Preparing data Describing data Visualizing data • Clean data Analyzing data • Find min/max Modeling data • Flag data • Clean Excel workbooks Correlation/Association tests Parametric tests Nonparametric tests Tools XLSTAT 19

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 XLSTAT 20

Adding your own code You can use the XLSTAT VBA layer, or use XLSTAT as a bridge to the XLSTAT C++ layer Your VBA code XLSTAT Architecture 21

XLSTAT Presentation Benefits 22

Easy to get started with – Microsoft Excel is the most used spreadsheet worldwide. – XLSTAT dialog boxes approach is user-friendly.

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 .

Results organized and didactic � Results are organized � Information is given to following the analytical help interpreting results process

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 license nor a different viewer

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) Export as .png 27

Available in several languages Chinese English French German Italian Japanese Polish Portuguese Spanish

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.

A great value XLSTAT products and solutions are reasonably priced and include top level support and assistance.

Approche XLSTAT 31

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 Product demo - Approach 32

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 XLSTAT Formulae 33

Demonstration Démonstration 34

Prices 35

Licence types Sector: Period: Private Yearly Education Unlimited Student Group / Campus Tarification 36

Yearly / Unlimited licenses Yearly licenses Unlimited licenses Priority support X X Access to latest updates For 1 year and then X if renewal of license agreement Discount when new modules are launched X X Fees dispatched over the years Same price every A higher investment year the first year 600 3500 Permanent once - 500 3000 cumulative Permanent once 2500 400 2000 300 Permanent Permanent 1500 200 updated - updated 1000 cumulative 100 Yearly 500 0 Yearly - cumulative 0 Prices 37

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 Prices 38

Solutions Perpetual Rental Maintenance XLSTAT-Sensory: 995 395 315 – 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