Dundas Chart for SharePoint Send comments on this topic.
Using Statistical Formulas
See Also

Glossary Item Box

Overview

Statistics is the study of how to acquire meaningful information by analyzing data (e.g. a list of numbers). Dundas Chart for SharePoint™ provides a complete set of statistical analysis functions, which are implemented using the Statistics class (exposed as the Statistics property of the DataManipulator class).

 

This Statistics class can be organized into 4 general groups:

 

It is important to note that all statistical methods that use one or more Series for their input data cannot use indexed data points.

Since these statistical methods cannot use indexed data points, therefore you must:

Statistical Tests

Statistical tests are used for Hypothesis testing. There are 6 different tests: ANOVA, F-Test, Z-Test, T-Tests (Equal Variance, Unequal Variance and Paired). All tests use series and various parameters for input, while the output value for each test is a test result class. These classes have read-only properties, and store the results from the tests.

Unlike the other tests that must have exactly two input series, the Anova test can have more then two input series.

Distribution Formulas

Dundas chart supports 3 Distributions: Normal Distribution, T-Distribution (or Students Distribution), and F-Distribution.

 

Figure 1: Graph of Standard Normal Distribution (left), T distribution (middle), and F Distribution (right).

 

The Distribution functions always have one double value for input, and return the probability for that distribution. The Inverse Distribution functions use probability as an input value, along with one, or two degrees of freedom.

Basic Statistical Formulas

The basic statistical functions are: Mean, Median, Variance, Correlation and Covariance. These functions always return a double value, and use one or two series for input.

Utility Functions

There are two utility functions: the Gamma and Beta functions, which are used in statistics to calculate distribution values. These functions always return a double value and use one or two double values for input.

See Also