|
| |
| VisualStat is a remarkably comprehensive visual
statistics package. 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. VisualStat has a well-designed user interface with all its
statistical and charting procedures easily selected from menus. Basic
and frequently used commands can be shown continuously for instant
access. With VisualStat DataBook, you can develop feature-rich database
with an object-oriented, extensible set of classes to incorporate
spreadsheet functionality into your set of data. Use DataBook to manage your
statistics and access to multiple sheets using many types of variables and
predefined sheet styles. In addition, spreadsheet files in many formats can
be directly opened. VisualStat supports tables for ODBC database
connections.
Chart types in VisualStat include all the usual types for statistical
data such as Bar, Pie, Line, HiLo, Candle, Polar, Error Bar Plot,
Interval Plot and Box-and-Whisker Plot charts together with
3D charting options. A wide variety of action is available including
Zoom, Rotate, Scale and Translate Chart. VisualStat DataChart can be exported in
many formats, including *.jpg , *.bmp, *.emf and *.png file formats
|
| Core Features |
 | Exceptionally easy to use |
| Microsoft Office
style menus and toolbars |
| Includes all common statistical methods |
| Easy-to-use manuals HTML Online-Help |
| State-of-the-art computational methods for reliable results |
| Built-in application Task Bar |
| Support OLE Automation |
| Full academic references and validation of functions |
| Full context-sensitive integration of help in all dialog box |
|
| Statistics |
| Descriptive Statistics
 | Column Types |
| Missing Values |
| Counts and Sums |
| Min/Max Functions |
| Ranks, Percentiles, Deciles, and Quartiles |
| Central Tendency |
| Spread |
| Shape |
| Covariance, Correlation, and Autocorrelation |
| Sorting |
| Logical Functions |
|
| Special Functions
| Combinatorial Functions |
| Gamma Function |
| Beta Function |
|
| Probability Distributions
| Distribution Classes |
| Normal Distribution |
| Logistic Distribution |
| Poisson Distribution |
| Gamma Distribution |
| Chi-Square Distribution |
| Beta Distribution |
| Student’s t Distribution |
| F Distribution |
| Binomial Distribution |
| Negative Binomial Distribution |
|
| Hypothesis Tests
| One Sample Z-Test |
| One Sample T-Test |
| Two Sample Paired T-Test |
| Two Sample Unpaired T-Test |
| Two Sample F-Test |
| One Sample Kolmogorov-Smirnov Test |
| Two Sample Kolmogorov-Smirnov Test |
|
| Linear Regression
| Parameter Calculation |
| Intercept Parameters |
| Predictions |
| Accessing and Modifying the Model |
| Significance of Parameters |
| Properties Linear Regression Parameters |
| Hypothesis Tests |
|
| Analysis of Variance
| One-Way ANOVA
 | The One-Way ANOVA Table |
| Grand Mean, Group Means, and Group Sizes |
| Critical Value of the F Statistic |
|
| One-Way Repeated Measures ANOVA |
| Two-Way ANOVA
| The Two-Way ANOVA Table |
| Cell Data |
| Grand Mean, Cell Means, and Group Means |
| ANOVA Regression Parameters |
|
| Two-Way Repeated Measures ANOVA |
|
| Multivariate Techniques
| Principal Component Analysis |
| Hierarchical Cluster Analysis
| Distance Functions |
| Linkage Functions |
| Creating Cluster Analyses |
| Cluster Analysis Results |
| Show Dendrogram |
|
|
| Chart Plot in Frequencies Summary |
| Can choose output report for each procedure |
| Box-and-Whisker Plot in procedures, including
| Description & Mean Summary |
| ANOVA |
| One-Sample, Paired-Sample & Two-Sample t-Test |
|
| Char Bar & Chart Line in procedures, including
| Cross Tabulation |
| One-Sample, Paired-Sample & Two-Sample t-Test |
| ANOVA |
|
| Interval Plot for Mean in procedures, including
| Description & Mean Summary |
| One-Sample, Paired-Sample & Two-Sample t-Test |
| ANOVA |
|
| Bar Chart for Mean in Mean Summary |
| Common Univariate Statistics in
| Description, Mean |
| Regression, Bivariate Correlation |
| Parametric Test |
| Nonparametric Tests |
|
| X'X (Hat) Matrix in Regression |
| Residual Plots in Regression |
| Non-parametric Methods
| Chi-Square Goodness-of-Fit Test |
| Two-sample Kolmogorov-Smirnov Goodness-of-Fit Test |
| One-sample Kolmogorov-Smirnov Goodness-of-Fit Test |
| Kruskal-Wallis Rank Sum Test for Independent-Samples |
| Mann-Whitney U-test for Independent-Samples |
| Kendall's Rank Correlation |
| Spearman's Rank Correlation |
| Paired-Samples Sign Test |
| Wilcoxon Singed Rank test for Single Group Median |
| Wilcoxon Signed Rank Test for Paired-Samples |
| Homogeneity of variance, including Levene's test |
| Sign test for a median |
| Sign test for two medians (paired observations) |
|
| Chi Square Tests
| Pearson's Chi-Square Test |
| McNemar’s Chi-Square Test |
| Bowker's Chi-Square Test |
| Likelihood-Ratio Chi-Square Test |
| Cramer's V Coefficient |
| Phi Coefficient |
| Contingency Coefficient |
| Kappa Coefficient |
| Yates' Continuity Correction |
| Partial Chi Square |
| Goodness of fit |
|
| Bivariate Correlations
| Person's Correlation |
| Spearman's Rank-Correlation |
| Kendall's Rank-Correlation |
|
| Descriptive Statistics
| Count, Sum, Mean, Standard Deviation |
| Kurtosis, Skewness |
| Confidence Interval of the Population Mean |
| Standard Error of the Mean |
| Coefficient of Variation |
| Estimated Confidence Interval (from
0 to 1) |
| Maximum, Minimum |
| First Quartile, Median, 3rd Quartile,
Percentile |
| Cut points for equal groups |
| Frequencies and Crosstabulation |
|
|
| Data Management |
| Multiple Sheets
| Up to 2 billion sheets in a single DataSheet |
| Use multiple sheets to categorize your information, similar
to using worksheets in Microsoft Excel |
| Sheets can have up to 2 billion rows and 2 billion columns. |
|
| Spannable Cells |
| Headers with Multiple Columns and Rows |
| Sorting Capabilities
| User can sort rows automatically simply by clicking on the
column header. |
|
| Multiple Column Types
| Currency
| currency symbol (and whether to display it) |
| separator character (and whether to display it) |
| decimal symbol |
| whether to display a leading zero |
| positive currency format |
| negative currency format |
|
| Date and Time
| You can specify the format using several properties |
| The default values use the Regional Settings or Regional
Options in the Windows environment |
|
| General
| Using for entering text or numbers where formatting is
not critical or the type of data is not tied to a specific
data type. |
|
| Number |
| Percent |
| Text |
| Category
| displays an editable drop-down list, allowing user to
type in values as well as choosing from a displayed list. |
|
|
| Built-In Functions
| Use built-in functions and operators to develop formulas and
perform calculations. |
| Add calculations quickly to your DataSheet by using any of
over 200 pre-defined algorithms or add your own custom
functions. |
|
| Import and Export Capabilities |
| Full localization support. All regional and language
options are available. |
| Regional and Languages Options |
| Split, Subset, Merge & Transpose DataSheet |
| Multiple Sheets in DataBook |
| Stack, Transpose & Split Column and Row |
| Session Explorer |
| Right Pane Description |
| Task List Window |
| Messages Window and Logging |
| Web Browser Window |
| Command Window |
| Zooming DataBook, DataChart and Repport |
| New Data Types in Column Format, including General, Currency, ... |
|
|
Built-In Functions |
| Date and Time Functions
| DATE |
| DATEVALUE |
| DAY |
| DAYS360 |
| EDATE |
| EOMONTH |
| HOUR |
| MINUTE |
| MONTH |
| NOW |
| SECOND |
| TIME |
| TIMEVALUE |
| TODAY |
| WEEKDAY |
| WEEKNUM |
| YEAR |
|
| Engineering Functions
| BESSELI |
| BESSELJ |
| BESSELK |
| BESSELY |
| DELTA |
| ERF |
| ERFC |
| GESTEP |
|
| Financial Functions
| ACCRINT |
| ACCRINTM |
| DB |
| DDB |
| DISC |
| EFFECT |
| FV |
| FVSCHEDULE |
| INTRATE |
| IPMT |
| IRR |
| MIRR |
| NOMINAL |
| NPER |
| NPV |
| PMT |
| PPMT |
| PRICEDISC |
| PRICEMAT |
| PV |
| RATE |
| RECEIVED |
| SLN |
| SYD |
| TBILLEQ |
| TBILLPRICE |
| TBILLYIELD |
| VDB |
|
| Information Functions
| COUNTBLANK |
| ERRORTYPE |
| ISBLANK |
| ISERR |
| ISERROR |
| ISEVEN |
| ISLOGICAL |
| ISNA |
| ISNONTEXT |
| ISNUMBER |
| ISODD |
| ISREF |
| ISTEXT |
| N |
| NA |
| TYPE |
|
| Logical Functions
|
| Lookup Functions
| CHOOSE |
| COLUMNS |
| INDEX |
| ROWS |
|
| Math and Trigonometry
Functions
| ABS |
| ACOS |
| ACOSH |
| ASIN |
| ASINH |
| ATAN |
| ATAN2 |
| ATANH |
| CEILING |
| COMBIN |
| COS |
| COSH |
| DEGREES |
| EVEN |
| EXP |
| FACT |
| FACTDOUBLE |
| FLOOR |
| GCD |
| INT |
| LCM |
| LN |
| LOG |
| LOG10 |
| MOD |
| MROUND |
| MULTINOMIAL |
| ODD |
| PI |
| POWER |
| PRODUCT |
| QUOTIENT |
| RADIANS |
| RAND |
| RANDBETWEEN |
| ROUND |
| ROUNDDOWN |
| ROUNDUP |
| SERIESSUM |
| SIGN |
| SIN |
| SINH |
| SQRT |
| SQRTPI |
| SUM |
| SUMPRODUCT |
| SUMSQ |
| SUMX2MY2 |
| SUMX2PY2 |
| SUMXMY2 |
| TAN |
| TANH |
| TRUNC |
|
| Statistical Functions
| AVEDEV |
| AVERAGE |
| BETADIST |
| BETAINV |
| BINOMDIST |
| CHIDIST |
| CHIINV |
| CHITEST |
| CONFIDENCE |
| CORREL |
| COVAR |
| CRITBINOM |
| DEVSQ |
| EXPONDIST |
| FDIST |
| FINV |
| FISHER |
| FISHERINV |
| FORECAST |
| FTEST |
| GAMMADIST |
| GAMMAINV |
| GAMMALN |
| GEOMEAN |
| HARMEAN |
| HYPGEOMDIST |
| INTERCEPT |
| KURT |
| LARGE |
| LOGINV |
| LOGNORMDIST |
| MAX |
| MEDIAN |
| MIN |
| MODE |
| NEGBINOMDIST |
| NORMDIST |
| NORMINV |
| NORMSDIST |
| NORMSINV |
| PEARSON |
| PERCENTILE |
| PERCENTRANK |
| PERMUT |
| POISSON |
| PROB |
| QUARTILE |
| RANK |
| RSQ |
| SKEW |
| SLOPE |
| SMALL |
| STANDARDIZE |
| STDEV |
| STDEVP |
| STEYX |
| TDIST |
| TINV |
| TRIMMEAN |
| TTEST |
| VAR |
| VARP |
| WEIBULL |
| ZTEST |
|
| Text Functions
| CHAR |
| CLEAN |
| CODE |
| CONCATENATE |
| DOLLAR |
| EXACT |
| FIND |
| FIXED |
| LEFT |
| LEN |
| LOWER |
| MID |
| PROPER |
| REPLACE |
| REPT |
| RIGHT |
| SUBSTITUTE |
| TRIM |
| UPPER |
|
|
|
