what do you mean by statistical function explain different types of statistical function used in MS Excel with example
Answers
Answer:
A statistical function, such as Mean, Median, or Variance, summarizes a sample of values by a single value. By default, they expect their parameter(s) to be a probabilistic value represented by a random sample of values over the Run index. But, you can also apply a statistical function over an array of data index by specifying that index as an optional parameter. You can also see common statistics of an uncertain variable, including Mean, Standard deviation, Min, and Max, by selecting the Statistics option from the uncertainty views in the Result window.
Contents
1 Statistical functions force prob mode evaluation
2 Statistics from non-probabilistic arrays
3 Statistical Functions and Importance Weighting
4 Statistics and text-valued distributions
5 Notation in statistical formulas
6 Example model
7 Mean(x)
8 Median(x)
9 Sdeviation(x)
10 Variance(x)
11 Skewness(x)
12 Kurtosis(x)
13 Probability(b)
14 GetFract(x, p, I)
15 ProbBands(x)
16 Covariance(x, y)
17 Correlation(x, y)
18 Rankcorrel(x, y)
19 Frequency(x, i)
20 Mid(x)
21 Sample(x)
22 Statistics(x)
23 PDF(X) and CDF(X)
24 See Also
Statistical functions force prob mode evaluation
Unlike other functions, statistical functions force their main parameter(s) to be evaluated in prob mode (probabilistically) — even if the evaluation context is for mid mode -- unless you provide an index parameter other than Run. Their result is not probabilistic.