SurveyMiner 2.3

SurveyMiner 2.3 is an effective utility which allows you to turn Microsoft Excel into a powerful survey analysis tools

SurveyMiner is a complete set of survey response analysis tools for Microsoft Excel. It turns Microsoft Excel into a powerful survey analysis and tabulation package. If your survey responses are already collected, XLCrossTab is the software to get the most of your data.

SurveyMiner adds to Excel: advanced coding functions, crosstabulations, banner tables, multiple response variables, long labels, missing data estimation, data cleaning, coding scripts, quotas sampling, weighting, significance tests included in the crosstabs, customizable reports with graphics and multivariate data analysis. SurveyMiner imports in Excel triple-S and Spss format files. SurveyMiner is reliable, easy to use and has competitive prices.

Major Features:

1. 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,
2. 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
3. Sampling
   • Random Sampling and quota sampling with up to 6 criterion variables
4. Weighting: Iterative procedure for weighted adjustment. Weighting individuals up to 6 criterion variables
5. Data Cleaning: List all the responses and create sets of rules to correct improper values with or without scripts
6. Subgroups or population subsets: Unlimited subset creation, simple or advanced logical relation between items
7. 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
8. 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
9. 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
10. 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
11.  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
12. 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
13. Graphics: About 50 different graphic types: Column clustered, stacked, bars, lines,...
14. Table formats:  About 16 different table layouts
15. 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
16. Binary Correspondence Analysis
    • With or without supplementary variables
    • Graphics
    • Weighted or not
17. Multiple Correspondence Analysis
    • With or without supplementary variables or observations
    • Individual (observation) results
    • Factorial graphics
    • Weighted or not
18. Multiple regression
    • R2, adjusted R2
    • Anova
    • Individual estimations and Cook distance

Enhancements:

• New automatic reporting functions
• Import improvement,
• The demo version is only limited by 100 observations