1 / 43

Introduction

Introduction. Outline. Outline. XLSTAT Presentation Excel and XLSTAT Users A modular application Benefits The XLSTAT approach Demo Prices. XLSTAT Presentation Excel and XLSTAT. Facts. Facts. MS Excel is the most used spreadsheet software in the world (90% market share)

vesta
Download Presentation

Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction

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

  3. XLSTAT PresentationExcel and XLSTAT

  4. Facts 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

  5. XLSTAT PresentationUsers

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

  7. Users in all industries Users 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)

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

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

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

  11. XLSTAT PresentationModular application

  12. XLSTAT – A modular application Home-made Application VBA Core module Modules developed by Addinsoft Modules developed in partnership XLSTAT

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

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

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

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

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

  18. XLSTAT-Pro • 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 XLSTAT Preparing data Describing data Visualizing data Analyzing data Modeling data Correlation/Association tests Parametric tests Nonparametric tests

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

  20. Complementary modules XLSTAT 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

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

  22. XLSTAT PresentationBenefits

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

  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 • Information is given to help interpreting results • Results are organized following the analytical process

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

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

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

  33. XLSTAT Formulae 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 Démonstration

  35. Prices

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

  37. Yearly / Unlimited licenses Prices

  38. Prices per modules (€) Prices • 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

  40. Solutions • XLSTAT-Medical: • Pro to cover all your basic statistical needs; • 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).

  41. Solutions • XLSTAT-6S: • Pro to cover all your basic statistical needs; • 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.

  42. Solutions • XLSTAT-Predict: • Pro to cover all your basic statistical needs; • 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.

  43. Contact Contact www.xlstat.com info@xlstat.com 40 rue Damrémont / 75018 PARIS Tél : 01 47 66 43 24 / Fax : 01 53 01 65 88

More Related