July 2016
Intermediate to advanced
336 pages
8h 58m
English
APPENDIXE
Excel Reference Glossary
Probability Distributions
FACT(n) |
Factorial |
PERMUT(n, r) |
Permutations |
COMBIN(n, r) |
Combinations |
BINOM.DIST(x, n, p, cumulative) |
Binomial probability distribution |
POISSON.DIST(y, λ, cumulative) |
Poisson probability distribution |
NORM.DIST(x, mean, standard_dev, cumulative) |
Normal probability distribution |
Confidence Intervals
CONFIDENCE.NORM(alpha, standard_dev, size) |
Confidence interval using normal distribution |
CONFIDENCE.T(alpha, standard_dev, size) |
Confidence interval using the t-distribution |
One-Sample Hypothesis Tests
NORM.S.DIST(z, cumulative) |
The p-value for a calculated z-test statistic |
T.DIST(x, Deg_freedom) |
The p-value for a calculated t-test statistic, left-tail test |