beta-dist-cdf-at-0-5 |
BETA.DIST |
=BETA.DIST(0.5, 2, 2, TRUE, 0, 1) |
value |
|
beta-dist-pdf-at-0-5 |
BETA.DIST |
=BETA.DIST(0.5, 2, 2, FALSE, 0, 1) |
value |
|
beta-dist-cdf-at-boundary |
BETA.DIST |
=BETA.DIST(1, 2, 5, TRUE, 0, 1) |
value |
1 |
beta-inv-at-0-5 |
BETA.INV |
=BETA.INV(0.5, 2, 2, 0, 1) |
value |
|
beta-inv-roundtrip |
BETA.INV |
=BETA.INV(BETA.DIST(0.3, 2, 5, TRUE, 0, 1), 2, 5, 0, 1) |
value |
|
betadist-central |
BETADIST |
=BETADIST(0.5, 2, 2) |
value |
|
betadist-with-bounds |
BETADIST |
=BETADIST(5, 2, 3, 0, 10) |
value |
|
betainv-at-0-5 |
BETAINV |
=BETAINV(0.5, 2, 2) |
value |
|
betainv-roundtrip |
BETAINV |
=BETAINV(BETADIST(0.4, 3, 2), 3, 2) |
value |
|
binom-dist-pmf-at-0 |
BINOM.DIST |
=BINOM.DIST(0, 10, 0.5, FALSE) |
value |
|
binom-dist-pmf-at-k-5-n-10 |
BINOM.DIST |
=BINOM.DIST(5, 10, 0.5, FALSE) |
value |
|
binom-dist-cdf-at-n |
BINOM.DIST |
=BINOM.DIST(10, 10, 0.5, TRUE) |
value |
2 |
binom-dist-tail-probability |
BINOM.DIST |
=BINOM.DIST(3, 10, 0.25, TRUE) |
value |
|
binom-inv-median |
BINOM.INV |
=BINOM.INV(10, 0.5, 0.5) |
value |
1 |
binom-inv-tail |
BINOM.INV |
=BINOM.INV(20, 0.3, 0.95) |
value |
1 |
binomdist-pmf |
BINOMDIST |
=BINOMDIST(2, 5, 0.5, FALSE) |
value |
1 |
binomdist-cdf |
BINOMDIST |
=BINOMDIST(2, 5, 0.5, TRUE) |
value |
|
chidist-at-mean-df-4 |
CHIDIST |
=CHIDIST(4, 4) |
value |
|
chidist-tail-df-10 |
CHIDIST |
=CHIDIST(18.307, 10) |
value |
|
chiinv-0-05-df-10 |
CHIINV |
=CHIINV(0.05, 10) |
value |
|
chiinv-roundtrip |
CHIINV |
=CHIINV(CHIDIST(5, 4), 4) |
value |
|
chisq-dist-cdf-df-4 |
CHISQ.DIST |
=CHISQ.DIST(4, 4, TRUE) |
value |
|
chisq-dist-pdf-df-4 |
CHISQ.DIST |
=CHISQ.DIST(4, 4, FALSE) |
value |
|
chisq-dist-rt-df-10 |
CHISQ.DIST.RT |
=CHISQ.DIST.RT(18.307, 10) |
value |
|
chisq-dist-rt-median |
CHISQ.DIST.RT |
=CHISQ.DIST.RT(4, 4) |
value |
|
chisq-inv-at-0-5-df-4 |
CHISQ.INV |
=CHISQ.INV(0.5, 4) |
value |
|
chisq-inv-roundtrip |
CHISQ.INV |
=CHISQ.INV(CHISQ.DIST(5, 4, TRUE), 4) |
value |
|
chisq-inv-rt-at-0-05-df-10 |
CHISQ.INV.RT |
=CHISQ.INV.RT(0.05, 10) |
value |
|
chisq-inv-rt-roundtrip |
CHISQ.INV.RT |
=CHISQ.INV.RT(CHISQ.DIST.RT(5, 4), 4) |
value |
|
chisq-test-2x3-contingency |
CHISQ.TEST |
=CHISQ.TEST(A1:C2, A4:C5) |
value |
|
chisq-test-identical-ranges |
CHISQ.TEST |
=CHISQ.TEST(A1:B2, A4:B5) |
value |
1 |
chitest-2x3-contingency |
CHITEST |
=CHITEST(A1:C2, A4:C5) |
value |
|
chitest-small-table |
CHITEST |
=CHITEST(A1:B2, A4:B5) |
value |
|
confidence-norm-standard |
CONFIDENCE.NORM |
=CONFIDENCE.NORM(0.05, 1, 100) |
value |
|
confidence-norm-99-percent |
CONFIDENCE.NORM |
=CONFIDENCE.NORM(0.01, 2.5, 50) |
value |
|
critbinom-median |
CRITBINOM |
=CRITBINOM(10, 0.5, 0.5) |
value |
1 |
critbinom-tail |
CRITBINOM |
=CRITBINOM(20, 0.3, 0.95) |
value |
1 |
expon-dist-cdf-at-mean |
EXPON.DIST |
=EXPON.DIST(1, 1, TRUE) |
value |
|
expon-dist-pdf-at-0 |
EXPON.DIST |
=EXPON.DIST(0, 2, FALSE) |
value |
1 |
expon-dist-pdf-at-x-1 |
EXPON.DIST |
=EXPON.DIST(1, 2, FALSE) |
value |
|
expondist-cdf |
EXPONDIST |
=EXPONDIST(2, 0.5, TRUE) |
value |
|
expondist-pdf |
EXPONDIST |
=EXPONDIST(2, 0.5, FALSE) |
value |
|
f-dist-cdf |
F.DIST |
=F.DIST(1, 5, 10, TRUE) |
value |
|
f-dist-pdf |
F.DIST |
=F.DIST(1, 5, 10, FALSE) |
value |
|
f-dist-rt-tail |
F.DIST.RT |
=F.DIST.RT(3.33, 5, 10) |
value |
|
f-dist-rt-central |
F.DIST.RT |
=F.DIST.RT(1, 5, 10) |
value |
|
f-inv-at-0-5 |
F.INV |
=F.INV(0.5, 5, 10) |
value |
|
f-inv-roundtrip |
F.INV |
=F.INV(F.DIST(2, 5, 10, TRUE), 5, 10) |
value |
|
f-inv-rt-at-0-05 |
F.INV.RT |
=F.INV.RT(0.05, 5, 10) |
value |
|
f-inv-rt-roundtrip |
F.INV.RT |
=F.INV.RT(F.DIST.RT(2, 5, 10), 5, 10) |
value |
|
fdist-tail |
FDIST |
=FDIST(3.33, 5, 10) |
value |
|
fdist-central |
FDIST |
=FDIST(1, 5, 10) |
value |
|
finv-at-0-05 |
FINV |
=FINV(0.05, 5, 10) |
value |
|
finv-roundtrip |
FINV |
=FINV(FDIST(2, 5, 10), 5, 10) |
value |
|
fisher-at-0 |
FISHER |
=FISHER(0) |
value |
1 |
fisher-at-0-5 |
FISHER |
=FISHER(0.5) |
value |
|
fisherinv-at-0 |
FISHERINV |
=FISHERINV(0) |
value |
1 |
fisherinv-roundtrip |
FISHERINV |
=FISHERINV(FISHER(0.75)) |
value |
1 |
gamma-at-1 |
GAMMA |
=GAMMA(1) |
value |
1 |
gamma-at-5 |
GAMMA |
=GAMMA(5) |
value |
2 |
gamma-at-0-5 |
GAMMA |
=GAMMA(0.5) |
value |
|
gamma-dist-cdf |
GAMMA.DIST |
=GAMMA.DIST(2, 2, 1, TRUE) |
value |
|
gamma-dist-pdf |
GAMMA.DIST |
=GAMMA.DIST(2, 2, 1, FALSE) |
value |
|
gamma-inv-at-0-5 |
GAMMA.INV |
=GAMMA.INV(0.5, 2, 1) |
value |
|
gamma-inv-roundtrip |
GAMMA.INV |
=GAMMA.INV(GAMMA.DIST(2, 2, 1, TRUE), 2, 1) |
value |
1 |
gammadist-cdf |
GAMMADIST |
=GAMMADIST(2, 2, 1, TRUE) |
value |
|
gammadist-pdf |
GAMMADIST |
=GAMMADIST(2, 2, 1, FALSE) |
value |
|
gammainv-at-0-5 |
GAMMAINV |
=GAMMAINV(0.5, 2, 1) |
value |
|
gammainv-roundtrip |
GAMMAINV |
=GAMMAINV(GAMMADIST(3, 2, 1, TRUE), 2, 1) |
value |
|
gauss-at-0 |
GAUSS |
=GAUSS(0) |
value |
1 |
gauss-at-1 |
GAUSS |
=GAUSS(1) |
value |
|
hypgeom-dist-pmf |
HYPGEOM.DIST |
=HYPGEOM.DIST(1, 4, 8, 20, FALSE) |
value |
|
hypgeom-dist-cdf |
HYPGEOM.DIST |
=HYPGEOM.DIST(1, 4, 8, 20, TRUE) |
value |
|
hypgeom-dist-at-0 |
HYPGEOM.DIST |
=HYPGEOM.DIST(0, 4, 8, 20, FALSE) |
value |
|
hypgeomdist-basic |
HYPGEOMDIST |
=HYPGEOMDIST(1, 4, 8, 20) |
value |
|
hypgeomdist-zero-successes |
HYPGEOMDIST |
=HYPGEOMDIST(0, 4, 8, 20) |
value |
|
loginv-at-0-5 |
LOGINV |
=LOGINV(0.5, 0, 1) |
value |
1 |
loginv-roundtrip |
LOGINV |
=LOGINV(LOGNORMDIST(2, 0, 1), 0, 1) |
value |
|
lognorm-dist-cdf |
LOGNORM.DIST |
=LOGNORM.DIST(2, 0, 1, TRUE) |
value |
|
lognorm-dist-pdf |
LOGNORM.DIST |
=LOGNORM.DIST(2, 0, 1, FALSE) |
value |
|
lognorm-inv-at-0-5 |
LOGNORM.INV |
=LOGNORM.INV(0.5, 0, 1) |
value |
1 |
lognorm-inv-roundtrip |
LOGNORM.INV |
=LOGNORM.INV(LOGNORM.DIST(2, 0, 1, TRUE), 0, 1) |
value |
|
lognormdist-at-1 |
LOGNORMDIST |
=LOGNORMDIST(1, 0, 1) |
value |
2 |
lognormdist-at-2 |
LOGNORMDIST |
=LOGNORMDIST(2, 0, 1) |
value |
|
negbinom-dist-pmf |
NEGBINOM.DIST |
=NEGBINOM.DIST(10, 5, 0.25, FALSE) |
value |
|
negbinom-dist-cdf |
NEGBINOM.DIST |
=NEGBINOM.DIST(10, 5, 0.25, TRUE) |
value |
|
negbinom-dist-at-0-failures |
NEGBINOM.DIST |
=NEGBINOM.DIST(0, 5, 0.5, FALSE) |
value |
|
negbinomdist-basic |
NEGBINOMDIST |
=NEGBINOMDIST(10, 5, 0.25) |
value |
|
negbinomdist-at-0 |
NEGBINOMDIST |
=NEGBINOMDIST(0, 5, 0.5) |
value |
|
norm-dist-at-mean-cdf |
NORM.DIST |
=NORM.DIST(0, 0, 1, TRUE) |
value |
1 |
norm-dist-at-mean-pdf |
NORM.DIST |
=NORM.DIST(0, 0, 1, FALSE) |
value |
|
norm-dist-at-1-sigma-cdf |
NORM.DIST |
=NORM.DIST(1, 0, 1, TRUE) |
value |
|
norm-dist-non-standard |
NORM.DIST |
=NORM.DIST(42, 40, 1.5, TRUE) |
value |
|
norm-inv-at-0-5 |
NORM.INV |
=NORM.INV(0.5, 0, 1) |
value |
2 |
norm-inv-at-0-975 |
NORM.INV |
=NORM.INV(0.975, 0, 1) |
value |
|
norm-inv-roundtrip |
NORM.INV |
=NORM.INV(NORM.DIST(1.5, 0, 1, TRUE), 0, 1) |
value |
|
norm-s-dist-at-0-cdf |
NORM.S.DIST |
=NORM.S.DIST(0, TRUE) |
value |
2 |
norm-s-dist-at-0-pdf |
NORM.S.DIST |
=NORM.S.DIST(0, FALSE) |
value |
|
norm-s-dist-at-1-96 |
NORM.S.DIST |
=NORM.S.DIST(1.96, TRUE) |
value |
|
norm-s-inv-at-0-5 |
NORM.S.INV |
=NORM.S.INV(0.5) |
value |
2 |
norm-s-inv-at-0-975 |
NORM.S.INV |
=NORM.S.INV(0.975) |
value |
|
normdist-at-mean-cdf |
NORMDIST |
=NORMDIST(0, 0, 1, TRUE) |
value |
1 |
normdist-at-mean-pdf |
NORMDIST |
=NORMDIST(0, 0, 1, FALSE) |
value |
|
norminv-at-0-5 |
NORMINV |
=NORMINV(0.5, 0, 1) |
value |
2 |
norminv-at-0-95 |
NORMINV |
=NORMINV(0.95, 0, 1) |
value |
|
normsdist-at-0 |
NORMSDIST |
=NORMSDIST(0) |
value |
2 |
normsdist-at-1-96 |
NORMSDIST |
=NORMSDIST(1.96) |
value |
|
normsinv-at-0-5 |
NORMSINV |
=NORMSINV(0.5) |
value |
2 |
normsinv-at-0-025 |
NORMSINV |
=NORMSINV(0.025) |
value |
|
phi-at-0 |
PHI |
=PHI(0) |
value |
|
phi-at-1 |
PHI |
=PHI(1) |
value |
|
poisson-pmf-at-0 |
POISSON |
=POISSON(0, 3, FALSE) |
value |
|
poisson-pmf-at-mean |
POISSON |
=POISSON(3, 3, FALSE) |
value |
|
poisson-cdf |
POISSON |
=POISSON(5, 3, TRUE) |
value |
|
poisson-dist-pmf-at-0 |
POISSON.DIST |
=POISSON.DIST(0, 3, FALSE) |
value |
|
poisson-dist-pmf-at-mean |
POISSON.DIST |
=POISSON.DIST(3, 3, FALSE) |
value |
|
poisson-dist-cdf |
POISSON.DIST |
=POISSON.DIST(5, 3, TRUE) |
value |
|
t-dist-cdf-at-0 |
T.DIST |
=T.DIST(0, 10, TRUE) |
value |
1 |
t-dist-pdf-at-0 |
T.DIST |
=T.DIST(0, 10, FALSE) |
value |
|
t-dist-tail |
T.DIST |
=T.DIST(1.812, 10, TRUE) |
value |
|
t-dist-2t-df-10 |
T.DIST.2T |
=T.DIST.2T(1.812, 10) |
value |
|
t-dist-2t-central |
T.DIST.2T |
=T.DIST.2T(0.5, 10) |
value |
|
t-dist-rt-df-10 |
T.DIST.RT |
=T.DIST.RT(1.812, 10) |
value |
|
t-dist-rt-at-0 |
T.DIST.RT |
=T.DIST.RT(0, 10) |
value |
1 |
t-inv-at-0-5 |
T.INV |
=T.INV(0.5, 10) |
value |
1 |
t-inv-roundtrip |
T.INV |
=T.INV(T.DIST(1.5, 10, TRUE), 10) |
value |
|
t-inv-2t-95-df-10 |
T.INV.2T |
=T.INV.2T(0.05, 10) |
value |
|
t-inv-2t-roundtrip |
T.INV.2T |
=T.INV.2T(T.DIST.2T(1.5, 10), 10) |
value |
|
tdist-one-tailed |
TDIST |
=TDIST(1.812, 10, 1) |
value |
|
tdist-two-tailed |
TDIST |
=TDIST(1.812, 10, 2) |
value |
|
tinv-95-df-10 |
TINV |
=TINV(0.05, 10) |
value |
|
tinv-roundtrip |
TINV |
=TINV(TDIST(1.5, 10, 2), 10) |
value |
|
weibull-cdf |
WEIBULL |
=WEIBULL(2, 2, 1, TRUE) |
value |
|
weibull-pdf |
WEIBULL |
=WEIBULL(2, 2, 1, FALSE) |
value |
|
weibull-dist-cdf |
WEIBULL.DIST |
=WEIBULL.DIST(2, 2, 1, TRUE) |
value |
|
weibull-dist-pdf |
WEIBULL.DIST |
=WEIBULL.DIST(2, 2, 1, FALSE) |
value |
|
weibull-dist-at-0 |
WEIBULL.DIST |
=WEIBULL.DIST(0, 2, 1, TRUE) |
value |
1 |