Minimum system configuration
MS Excel 2003 or MS Excel 2007
Windows XP or Windows Vista
Microsoft Framework 2.0

Variables:
• Numeric variables (quantity)
• Categorical variables with numeric or alphnumeric characters
• Textual variables
• Logical or binary variables
• Multiple answer variables
• Ranked variables and Likert scale variables

Up to 2000 items for a categorical variable
Up to 2000 questions (variables) for the Pro Edition
Up to 2 000 000 questionnaires (observations) for the Pro Edition
Unlimited number of subset populations,

Labels
question and item long labels, ordered label display

Import and Export
Import and Export with the standard Triple-S format file
Import SPSS(R) files
Import labels from a simple text file
And all the Excel import and export functions

Sampling
Random Sampling
and quota sampling with up to 6 criterion variables

Weighting
Iterative procedure for weighted adjustment. Weighting individuals up to 6 criterion variables

Data Cleaning
List all the responses and create sets of rules to correct improper values with or without scripts

Subgroups or population subsets
Unlimited subset creation, simple or advanced logical relation between items

Advanced coding
• Coding numeric variable into equal range classes
• Coding numeric variable into equal frequency classes
• Coding numeric variable with user defined class boundaries
• New variable by formula
• Grouping items
• Insert sub-totals
• Dimensioned variables, new variable using existing variables and items
• Creation of dummy or binary variables
• Binary variables in one multiple response variable
• Several categorical variables in one multiple response variable
• For each coding procedure, automatic script creation
• Automatic coding procedures

Frequency Tables
• Produce several tables in one click
• Population subset
• Weighted results
• % with missing values
• Multiple response variables
• Cumulative %
• Confidence Intervals
• missing value of your choice



Numeric descriptive statistics (weighted or un-weighted)
• Base, Missing values, Minimum, Maximum, Range
• Mean, Harmonic Mean, Geometric Mean
• Standard deviation unbiased (N-1), Standard deviation, variance unbiased (N-1),Variance
• Sum, Sum of weight
• Skewness (Pearson formula), kurtosis (Pearson formula), skewness, kurtosis
• Percentage of the minimum values
• Median, First quartile, Third quartile
• Variation coefficient, Variation coefficient unbiased
• Standard deviation of the mean, Absolute values of the deviations

Cross tabulation
• Produce many tables in one click
• Frequencies and percents
• With or without missing data
• Population subsets
• Un weighted or Weighted results
• Crossing 2 categorical variables
• Banner tables: crossing a categorical variable in rows and several variables in columns
• Crossing a categorical variable in rows and a numeric (quantity) in columns
• 1 ranked or scale variable in rows and 1 categorical variable in columns
• 2 categorical variables and a numeric variable in the table cell

 Statistical tests
• Cell Chi-square test and Frequency test
• Student t test: crossing a scale variable in row and a categorical variable in column.
• Student t test between categorical variable items and a numeric variable
• Student t test in a cross tabulation of 2 categorical variables and a numeric variable in the different cells,
 the comparison between the column means

Automatic statistical report generation
• All the variable selection and options saved in a script
• Automatic report updated on new dataset
• Use all the Excel reporting layouts
• Use all the statistical results on categorial or on numeric variables

Graphics
• About 50 different graphic types: Column clustered, stacked, bars, lines,...

Table formats
 About 16 different table layouts

Multivariate Data Analysis

• Principal Component Analysis
- with or without supplementary variables or observations
- factorial graphics
- individual (observation) results
- Varimax or quartimax rotation
- Pearson, Kendall, Spearman coefficient, or covariances
- Missing data management
• Binary Correspondence Analysis
-- with or without supplementary variables
- graphics
- Weighted or not
• Multiple Correspondence Analysis
-- with or without supplementary variables or observations
- Individual (observation) results
- factorial graphics
- Weighted or not
• Multiple regression
- R2, adjusted R2
- Anova
- Individual estimations and Cook distance