O'Reilly logo

Statistics, 3E by Fatma Abdel-Raouf, Robert A. Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required