ΟΙ ΣΥΝΕΡΓΑΤΕΣ ΠΟΥ

ΣΥΜΒΑΛΛΟΥΝ ΕΝΕΡΓΑ ΣΤΗΝ ΕΠΙΤΥΧΙΑ


XLSTAT-Pivot is a must-have software addition for XLSTAT-Pro to quickly create pivot tables. XLSTAT-Pivot module facilitates your data analysis and helps you to discover important trends and factors impacting your business by structuring your data in a way that allows you to see the most important information first; whereas the reporting tools available on the market today provide you with a lot of features to slice and dice your data they do not offer such synthetic analytical reports.

XLSTAT-Pivot


Pivot Features

  • Pivot table

Pivot table

What is a Pivot table?

A pivot table (or contingency table, or two-way table) is a synthetic representation of occurrences observed on an N-size population for crosses of all the different categories of two variables. 

A dynamic pivot table allows to take more than two variables into account and to organize the table structure into a hierarchy. The table is said to be dynamic in the sense that software functionalities allow to navigate among the hierarchy and to create a focused view on particular classes of particular variables.

Dynamic pivot table in XLSTAT software

XLSTAT-Pivot allows you to create dynamic pivot tables whose structure is optimized with respect to a target variable. The target variable can be a qualitative variable (with a target category), or a quantitative variable. Numeric continuous or discrete explanatory variables are automatically sliced into classes that contribute to optimize the quality of the table.

By inputing a table that contains a set of observations described by categorical and numerical variables - including the target variable which corresponds to the phenomenon of interest (revenue, response or not to a direct mailing, among others) - into XLSTAT-Pivot you will be able to:

  • Create a dynamic pivot table with a hierarchy among the variables depending on their contributions to the target variable, 
  • Identify the variables holding the most influence over the target variable,
  • Identify the combination of variables modt influencing the target variable,
  • Build optimal classes for the numerical variables, making it possible to use them in the dynamic pivot table.


Benefits

  • Easy and user-friendly
  • Data and results shared seamlessly
  • Modular
  • Didactic
  • Affordable
  • Accessible - Available in many languages
  • Automatable and customizable

System configuration

  • Windows:
    • Versions: 9x/Me/NT/2000/XP/Vista/Win 7/Win 8
    • Excel: 97 and later
    • Processor: 32 or 64 bits
    • Hard disk: 150 Mb
  • Mac OS X:
    • OS: OS X
    • Excel: X, 2004 and 2011
    • Hard disk: 150Mb.