|
| |
| VisualStat .NET 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 |
| An exceptional
integration of
help in VisualStat |
| 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 |
|
| 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, ... |
|
| Statistics |
| Probability Densities Functions |
| 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 |
|
| Post Hoc Interval Plot in ANOVA |
| Test for Equal Variances |
| X'X (Hat) Matrix in Regression |
| Influential Data and Residuals in Regression |
| Residual Plots in Regression |
| Diagnostic Measures in Regression, including
| Residuals |
| Studentized Residuals |
| Jackknife Residuals |
| Cook's Distance |
| Leverage values |
| DFFITS |
| Fitted values |
| SE of Fitted values |
| CI of Fitted values |
|
| F-Test |
| Levene Test |
| Distribution Functions
(PDF, CDF, InvCDF)
| Beta |
| Binomial |
| Chi Square |
| Exponential |
| Gamma |
| Geometric |
| Gumbel |
| Hyper Geometric |
| Log Normal |
| Normal |
| Poisson |
| t |
| Weibull |
|
| 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 |
|
| Parametric Methods
| Student's t tests for single sample |
| Student's t tests for paired
samples |
| Student's t tests for unpaired sample |
| Normal distribution Z-tests |
| Unequal variance t-test |
|
| Bivariate Correlations
| Person's Correlation |
| Spearman's Rank-Correlation |
| Kendall's Rank-Correlation |
|
| Curve Estimation
| Linear Model |
| Exponential Model |
| Power Model |
| Compound Model |
| Logarithmic Model |
| Inverse Model |
| S Model |
| Growth Model |
|
| Multiple Regression
| Unlimited number of Independent (Predictor)
variables |
| R Value, R Square Value, Regression Equation,
Standard Error of R |
| Standard Error of Estimate, Standard Error of B |
| Confidence Interval of B |
| F-test for two population variances |
| Save Predicated Values, Simple Residual, Leverage Values,
... |
| Applies Lilliefors' test to Residuals |
|
| One-Way ANOVA
| One-Way Between-groups (t-test) |
| Using Summary Data |
| Homogeneity of variance |
| Comparing unlimited number of groups |
| Calculates Summary Table, F Value and
Probability Level |
| Mean, Standard Deviation and Standard Error for
each Groups |
| Estimated Confidence Interval for each Level |
| Levene's Test of Homogeneity |
| Post Hoc Multiple Comparisons |
| Bonferroni's Procedure |
| Tukey's Honestly Significant Difference Test |
| Fisher's Least-Significant
Difference |
| Scheffe's Procedure |
| Multiple comparisons |
|
| 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 |
|
|
|
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 |
| | | | |
