8.5.11. stat¶
Python equivalents of statistical Excel functions.
Functions
CONFIDENCE.NORM(alpha, standard_dev, size) - alpha in (0,1) - standard_dev > 0 - size > 0 (integer) Returns the margin of error for a population mean when σ is known. |
|
CONFIDENCE.T(alpha, standard_dev, size) Returns the margin of error: t_{1-α/2, n-1} * sd / sqrt(n) |
|
EXPON.DIST(x, lambda, cumulative) |
|
FISHER(number) -> 0.5 * ln((1+x)/(1-x)) Excel domain: -1 < x < 1 (else #NUM!) |
|
FISHERINV(y) -> inverse Fisher transform = tanh(y) - Domain: any real y (returns value in (-1, 1)). |
|
FREQUENCY(data_array, bins_array) -> list of counts |
|
GAMMA(number) Excel domain: - allowed: any real except non-positive integers - error: number in { …, -2, -1, 0 } -> #NUM! |
|
GAMMA.INV(probability, alpha, beta) - 0 < probability < 1 - alpha > 0, beta > 0 |
|
GAMMALN(x) and GAMMALN.PRECISE(x) Excel domain: x > 0 (else #NUM!) |
|
GAUSS(z) = Φ(z) - 0.5 (Φ is the CDF of N(0,1); result in (-0.5, 0.5)) |
|
EXPON.DIST(x, lambda, cumulative) |
|
PERCENTRANK.EXC(array, x, [significance]) - Returns rank of x in array as a percentage in (0,1) (excludes endpoints). |
|
PROB(x_range, prob_range, lower_limit, [upper_limit]) |
|
RSQ(known_y's, known_x's) -> r^2 |
|
TRIMMEAN(array, percent) |
|
Z.TEST(array, x, [sigma]) -> one-tailed p-value |