|
| |
| VisualStat is a statistical and data analysis software
designed for business, science, marketing, and education, with fully
functional spreadsheet. It incorporates all the descriptive statistics,
parametric and nonparametric statistical methods, charts and data
transforms you will need for processing, analyzing and presenting data.
Multivariate procedures are included e.g. Principal component analysis
and Agglomerative Hierarchical Clustering.
All tests have associated report which give you a short conclusion and
other facts to assist in getting the right one for the job. |
| Core Features |
 | Exceptionally easy to use |
| Microsoft Office look and feel using Ribbon |
| Project Manager, organizes analysis |
| Includes all common statistical methods |
| Clear, comprehensive Help system |
| DataReport, report generator |
| Full academic references and validation of functions |
| Glossary of statistical terms |
| Multiple language versions, English and French |
| Methods and formulas used in calculations |
|
|
Data and File Management |
| DataBook, multiple sheets, allows calculation
like in Excel spreadsheet |
| Unlimited DataSheet capacity , with up to
2,000,000 columns by 2,000,000 rows |
| Import/Export Excel, Text, CVS, Html, XML, ...
etc. |
| Query databases with ODBC |
| Read/write reports in portable rich text format
(RTF) |
| Headers with multiple columns and rows |
| Multiple column types, including Currency,
Date/Time, Number, Percent and Factor |
| Over than 300 built-in functions |
| Full localization support, with all regional options |
| Easy copy/paste with Microsoft Excel |
| Categorization of continuous data |
| Assign formulas to columns; columns update when data change |
| Multiple Undo/Redo in the DataBook |
| Data manipulation: merge, subset, sort, transpose, split, stack, unstack, code |
| Generate random numbers (uniform, normal, chi-square, F, t, binomial, Poisson, gamma, exponential) |
|
|
Descriptive Statistics |
| Frequencies |
| Crosstabs |
| Counts |
| Arithmetic mean |
| Standard deviation (n-1) |
| Standard deviation (n) |
| Standard error |
| Skewness |
| Kurtosis |
| 95% confidence limit for mean |
| 99% confidence limit for mean |
| Min value |
| Max value |
| Sample range |
| Number of samples |
| Median |
| Geometric mean |
| Variance |
| Average deviation |
| Beta |
| Binomial |
| Log Binomial |
| Central Moment |
| Correlation |
| Count |
| Count If |
| Covariance |
| Covariance Matrix |
| Decile |
| Durbin Watson |
| Factorial |
| Log Factorial |
| Fisher |
| Fisher Inverse |
| Log Gamma |
| Harmonic Mean |
| If |
| Incomplete Beta |
| Incomplete Gamma |
| Interquartile Range |
| Kurtosis |
| Max Absolute Index |
| Max Absolute Value |
| Max Index |
| Max Value |
| Mean |
| Mean Deviation |
| Median |
| Median Deviation From Mean |
| Median Deviation From Median |
| Min Absolute Index |
| Min Absolute Value |
| Min Index |
| Min Value |
| Mode |
|
| Chi-square |
| Pearson's Test |
| Likelihood-Ratio Test |
| McNemar’s Test |
| Bowker's Test of Symmetry |
| Cramer's V coefficient |
| Contingency Coefficient |
| Kappa Coefficient |
| Chi-square test for consistency in a 2xk table |
| Chi-square test for independence in a pxq table |
| Chi-square test for compatibility of K counts |
| nxk Chi-squared |
| 2x2 Chi-squared |
| Fisher's exact test |
| One-sample chi-squared |
| Phi-Coefficient for 2x2 tables |
| Cramer coefficient C |
| Chi-square test for k independent samples |
| Kappa statistic for nominally scaled data |
|
| Random Data |
| Normal |
| Uniform |
| Gamma |
| Pareto |
| Exponential |
| Poisson |
| Binomial |
| Lognormal |
| Triangular |
|
| Parametric Methods |
| Frequency analysis |
| Unpaired t-test |
| Paired t-test |
| Unequal variance t-test |
| Normal distribution Z tests |
| F test for equal variances |
| Compare two observed values |
| Compare 2 sample proportions |
| Compare sample and population |
| Compare paired proportions |
| Z-test of a correlation coefficient |
| Z-test of 2 correlation coefficients |
| Z-test for correlated proportions |
| F-test for the overall mean of K subpopulations |
| F-test for K population means |
| t-test of a correlation coefficient |
| F-test for two population variances |
| Sign test for a median |
| Sign test for two medians (paired observations) |
|
| Charting Data |
| Bar Chart |
| Bubble Chart |
| Polar Chart |
| Radar Chart |
| Column Chart |
| Line Chart |
| Pie Chart |
| Area Chart |
| Box-and-Whisker |
| Error Bar Chart |
| Hi Lo Chart |
| Scatter Chart |
| Bubble Chart |
| Doughnut Chart |
| Step Chart |
| Histogram Chart |
| State-of-the-art graphics engine |
| Pictorial gallery simplify graph creation |
| Interactively edit attributes (axes, labels, etc.) |
| Information display tools: tooltips, ... |
| Interval plots area graphs |
| Save as TIF, JPEG, PNG, BMP, GIF, EMF |
|
|
Regression &
Correlation |
| Simple linear and Pearson's correlation |
| Multiple and General linear regression |
| Influential data identification |
| Residual plots and analysis |
| Linear-linear correlation |
| Repeated measures linear regression |
| Spearman rank correlation |
| Kendall rank correlation |
| Kendall partial rank correlation |
| Kendall coefficient of concordance |
| Confidence intervals for Kendall's and Spearman's rank correlations |
|
|
Analysis of Variance |
| One-way non-repeated ANOVA |
| One-way repeated ANOVA |
| Two-way replicated ANOVA |
| Two-way repeated ANOVA |
| Randomized Block |
| Analysis of means |
|
|
Non-parametric Methods |
| Wilcoxon |
| Signed Rank Test for Single Group Median |
| Mann-Whitney U-test for Independent-Samples |
| Wilcoxon Signed Rank Test for Paired-Samples |
| Kruskal-Wallis Rank Sum Test for Independent-Samples |
| One-sample Kolmogorov-Smirnov Test |
| Two-sample Kolmogorov-Smirnov Test |
| Paired-Samples Sign Test |
| Signed rank test for a mean |
| Signed rank test for two mean (paired observations) |
| Wilcoxon's matched pairs |
| Median test |
| Extension of the median test |
| Median test of two populations |
| Median test of k populations |
|
|
Multivariate Analysis |
| Principal components analysis |
| Cluster analysis |
| Correspondence analysis |
| Biplot for principal components and correspondence analysis |
|
|
Data Transformation |
| Database Functions
 | DAVERAGE |
| DCOUNT |
| DCOUNTA |
| DGET |
| DMAX |
| DMIN |
| DPRODUCT |
| DSTDEV |
| DSTDEVP |
| DSUM |
| DVAR |
| DVARP |
|
| Date and Time Functions
| DATE |
| DATEDIF |
| DATEVALUE |
| DAY |
| DAYS360 |
| EDATE |
| EOMONTH |
| HOUR |
| MINUTE |
| MONTH |
| NETWORKDAYS |
| NOW |
| SECOND |
| TIME |
| TIMEVALUE |
| TODAY |
| WEEKDAY |
| WEEKNUM |
| WORKDAY |
| YEAR |
| YEARFRAC |
|
| Engineering Functions
| BESSELI |
| BESSELJ |
| BESSELK |
| BESSELY |
| BIN2DEC |
| BIN2HEX |
| BIN2OCT |
| COMPLEX |
| CONVERT |
| DEC2BIN |
| DEC2HEX |
| DEC2OCT |
| DELTA |
| ERF |
| ERFC |
| GESTEP |
| HEX2BIN |
| HEX2DEC |
| HEX2OCT |
| IMABS |
| IMAGINARY |
| IMARGUMENT |
| IMCONJUGATE |
| IMCOS |
| IMDIV |
| IMEXP |
| IMLN |
| IMLOG10 |
| IMLOG2 |
| IMPOWER |
| IMPRODUCT |
| IMREAL |
| IMSIN |
| IMSQRT |
| IMSUB |
| IMSUM |
| OCT2BIN |
| OCT2DEC |
| OCT2HEX |
|
| Financial Functions
| ACCRINT |
| ACCRINTM |
| AMORDEGRC |
| AMORLINC |
| COUPDAYS |
| COUPDAYBS |
| COUPDAYSNC |
| COUPNCD |
| COUPNUM |
| COUPPCD |
| CUMIPMT |
| CUMPRINC |
| DB |
| DDB |
| DISC |
| DOLLAR |
| DOLLARDE |
| DOLLARFR |
| DURATION |
| EFFECT |
| EURO |
| EUROCONVERT |
| FV |
| FVSCHEDULE |
| INTRATE |
| IPMT |
| IRR |
| ISPMT |
| MDURATION |
| MIRR |
| NOMINAL |
| NPER |
| NPV |
| ODDFPRICE |
| ODDFYIELD |
| ODDLPRICE |
| ODDLYIELD |
| PMT |
| PPMT |
| PRICE |
| PRICEDISC |
| PRICEMAT |
| PV |
| RATE |
| RECEIVED |
| SLN |
| SYD |
| TBILLEQ |
| TBILLPRICE |
| TBILLYIELD |
| VDB |
| XIRR |
| XNPV |
| YIELD |
| YIELDDISC |
| YIELDMAT |
|
| Information Functions
| COUNTBLANK |
| ERRORTYPE |
| ISBLANK |
| ISERR |
| ISERROR |
| ISEVEN |
| ISLOGICAL |
| ISNA |
| ISNONTEXT |
| ISNUMBER |
| ISODD |
| ISREF |
| ISTEXT |
| N |
| NA |
| TYPE |
|
| Logical Functions
|
| Lookup Functions
| ADDRESS |
| CHOOSE |
| COLUMN |
| COLUMNS |
| HLOOKUP |
| INDEX |
| LOOKUP |
| OFFSET |
| ROW |
| ROWS |
| TRANSPOSE |
| VLOOKUP |
|
|
| Math and Trigonometry Functions
| ABS |
| ACOS |
| ACOSH |
| ASIN |
| ASINH |
| ATAN |
| ATAN2 |
| ATANH |
| CEILING |
| COMBIN |
| COS |
| COSH |
| COUNTIF |
| DEGREES |
| EVEN |
| EXP |
| FACT |
| FACTDOUBLE |
| FLOOR |
| GCD |
| INT |
| LCM |
| LN |
| LOG |
| LOG10 |
| MDETERM |
| MINVERSE |
| MMULT |
| MOD |
| MROUND |
| MULTINOMIAL |
| ODD |
| PI |
| POWER |
| PRODUCT |
| QUOTIENT |
| RADIANS |
| RAND |
| RANDBETWEEN |
| ROMAN |
| ROUND |
| ROUNDDOWN |
| ROUNDUP |
| SERIESSUM |
| SIGN |
| SIN |
| SINH |
| SQRT |
| SQRTPI |
| SUBTOTAL |
| SUM |
| SUMIF |
| SUMPRODUCT |
| SUMSQ |
| SUMX2MY2 |
| SUMX2PY2 |
| SUMXMY2 |
| TAN |
| TANH |
| TRUNC |
|
| Statistical Functions
| AVEDEV |
| AVERAGE |
| AVERAGEA |
| BETADIST |
| BETAINV |
| BINOMDIST |
| CHIDIST |
| CHIINV |
| CHITEST |
| CONFIDENCE |
| CORREL |
| COUNT |
| COUNTA |
| COVAR |
| CRITBINOM |
| DEVSQ |
| EXPONDIST |
| FDIST |
| FINV |
| FISHER |
| FISHERINV |
| FORECAST |
| FREQUENCY |
| FTEST |
| GAMMADIST |
| GAMMAINV |
| GAMMALN |
| GEOMEAN |
| GROWTH |
| HARMEAN |
| HYPGEOMDIST |
| INTERCEPT |
| KURT |
| LARGE |
| LINEST |
| LOGEST |
| LOGINV |
| LOGNORMDIST |
| MAX |
| MAXA |
| MEDIAN |
| MIN |
| MINA |
| MODE |
| NEGBINOMDIST |
| NORMDIST |
| NORMINV |
| NORMSDIST |
| NORMSINV |
| PEARSON |
| PERCENTILE |
| PERCENTRANK |
| PERMUT |
| POISSON |
| PROB |
| QUARTILE |
| RANK |
| RSQ |
| SKEW |
| SLOPE |
| SMALL |
| STANDARDIZE |
| STDEV |
| STDEVA |
| STDEVP |
| STDEVPA |
| STEYX |
| TDIST |
| TINV |
| TREND |
| TRIMMEAN |
| TTEST |
| VAR |
| VARA |
| VARP |
| VARPA |
| WEIBULL |
| ZTEST |
|
| Text Functions
| CHAR |
| CLEAN |
| CODE |
| CONCATENATE |
| DOLLAR |
| EXACT |
| FIND |
| FIXED |
| LEFT |
| LEN |
| LOWER |
| MID |
| PROPER |
| REPLACE |
| REPT |
| RIGHT |
| SUBSTITUTE |
| T |
| TRIM |
| UPPER |
| VALUE |
|
|
|
