8b7ab5 |
BETA.DIST |
=BETA.DIST(0.5, 2, 2, TRUE, 0, 1) |
value |
|
ae3d04 |
BETA.DIST |
=BETA.DIST(0.5, 2, 2, FALSE, 0, 1) |
value |
|
a303e2 |
BETA.DIST |
=BETA.DIST(1, 2, 5, TRUE, 0, 1) |
value |
1 |
ffcca6 |
BETA.INV |
=BETA.INV(0.5, 2, 2, 0, 1) |
value |
|
ed7a8b |
BETA.INV |
=BETA.INV(BETA.DIST(0.3, 2, 5, TRUE, 0, 1), 2, 5, 0, 1) |
value |
|
85313f |
BETADIST |
=BETADIST(0.5, 2, 2) |
value |
|
34bd5b |
BETADIST |
=BETADIST(5, 2, 3, 0, 10) |
value |
|
910fd5 |
BETAINV |
=BETAINV(0.5, 2, 2) |
value |
|
8d4244 |
BETAINV |
=BETAINV(BETADIST(0.4, 3, 2), 3, 2) |
value |
|
f7dd6c |
BINOM.DIST |
=BINOM.DIST(0, 10, 0.5, FALSE) |
value |
|
ed9a44 |
BINOM.DIST |
=BINOM.DIST(5, 10, 0.5, FALSE) |
value |
|
0d22be |
BINOM.DIST |
=BINOM.DIST(10, 10, 0.5, TRUE) |
value |
2 |
d4476b |
BINOM.DIST |
=BINOM.DIST(3, 10, 0.25, TRUE) |
value |
|
6be05f |
BINOM.INV |
=BINOM.INV(10, 0.5, 0.5) |
value |
1 |
f37fd2 |
BINOM.INV |
=BINOM.INV(20, 0.3, 0.95) |
value |
1 |
7ae66c |
BINOMDIST |
=BINOMDIST(2, 5, 0.5, FALSE) |
value |
1 |
5e48b9 |
BINOMDIST |
=BINOMDIST(2, 5, 0.5, TRUE) |
value |
|
c83ba1 |
CHIDIST |
=CHIDIST(4, 4) |
value |
|
05f6a5 |
CHIDIST |
=CHIDIST(18.307, 10) |
value |
|
ad8138 |
CHIINV |
=CHIINV(0.05, 10) |
value |
|
a92f3d |
CHIINV |
=CHIINV(CHIDIST(5, 4), 4) |
value |
|
20f366 |
CHISQ.DIST |
=CHISQ.DIST(4, 4, TRUE) |
value |
|
518808 |
CHISQ.DIST |
=CHISQ.DIST(4, 4, FALSE) |
value |
|
76d572 |
CHISQ.DIST.RT |
=CHISQ.DIST.RT(18.307, 10) |
value |
|
7906e9 |
CHISQ.DIST.RT |
=CHISQ.DIST.RT(4, 4) |
value |
|
ef4f2b |
CHISQ.INV |
=CHISQ.INV(0.5, 4) |
value |
|
6fec33 |
CHISQ.INV |
=CHISQ.INV(CHISQ.DIST(5, 4, TRUE), 4) |
value |
|
f35ece |
CHISQ.INV.RT |
=CHISQ.INV.RT(0.05, 10) |
value |
|
2dcc32 |
CHISQ.INV.RT |
=CHISQ.INV.RT(CHISQ.DIST.RT(5, 4), 4) |
value |
|
22f1e5 |
CHISQ.TEST |
=CHISQ.TEST(A1:C2, A4:C5) |
value |
|
216393 |
CHISQ.TEST |
=CHISQ.TEST(A1:B2, A4:B5) |
value |
1 |
8cfb38 |
CHITEST |
=CHITEST(A1:C2, A4:C5) |
value |
|
2a0dcd |
CHITEST |
=CHITEST(A1:B2, A4:B5) |
value |
|
99c196 |
CONFIDENCE.NORM |
=CONFIDENCE.NORM(0.05, 1, 100) |
value |
|
620a1d |
CONFIDENCE.NORM |
=CONFIDENCE.NORM(0.01, 2.5, 50) |
value |
|
50b095 |
CRITBINOM |
=CRITBINOM(10, 0.5, 0.5) |
value |
1 |
fa0704 |
CRITBINOM |
=CRITBINOM(20, 0.3, 0.95) |
value |
1 |
d98063 |
EXPON.DIST |
=EXPON.DIST(1, 1, TRUE) |
value |
|
dbfb47 |
EXPON.DIST |
=EXPON.DIST(0, 2, FALSE) |
value |
1 |
eff9a5 |
EXPON.DIST |
=EXPON.DIST(1, 2, FALSE) |
value |
|
cf4a48 |
EXPONDIST |
=EXPONDIST(2, 0.5, TRUE) |
value |
|
f7b698 |
EXPONDIST |
=EXPONDIST(2, 0.5, FALSE) |
value |
|
26f770 |
F.DIST |
=F.DIST(1, 5, 10, TRUE) |
value |
|
1821f5 |
F.DIST |
=F.DIST(1, 5, 10, FALSE) |
value |
|
fbcf80 |
F.DIST.RT |
=F.DIST.RT(3.33, 5, 10) |
value |
|
0e3f47 |
F.DIST.RT |
=F.DIST.RT(1, 5, 10) |
value |
|
2fa361 |
F.INV |
=F.INV(0.5, 5, 10) |
value |
|
0134c0 |
F.INV |
=F.INV(F.DIST(2, 5, 10, TRUE), 5, 10) |
value |
|
fc6fe4 |
F.INV.RT |
=F.INV.RT(0.05, 5, 10) |
value |
|
0d1399 |
F.INV.RT |
=F.INV.RT(F.DIST.RT(2, 5, 10), 5, 10) |
value |
|
6e0773 |
FDIST |
=FDIST(3.33, 5, 10) |
value |
|
2d1c02 |
FDIST |
=FDIST(1, 5, 10) |
value |
|
e67e2f |
FINV |
=FINV(0.05, 5, 10) |
value |
|
524da0 |
FINV |
=FINV(FDIST(2, 5, 10), 5, 10) |
value |
|
e2c476 |
FISHER |
=FISHER(0) |
value |
1 |
72d089 |
FISHER |
=FISHER(0.5) |
value |
|
22f636 |
FISHERINV |
=FISHERINV(0) |
value |
1 |
acd720 |
FISHERINV |
=FISHERINV(FISHER(0.75)) |
value |
1 |
b1b992 |
GAMMA |
=GAMMA(1) |
value |
1 |
10ae0f |
GAMMA |
=GAMMA(5) |
value |
2 |
be2b26 |
GAMMA |
=GAMMA(0.5) |
value |
|
b5d58a |
GAMMA.DIST |
=GAMMA.DIST(2, 2, 1, TRUE) |
value |
|
45fd9d |
GAMMA.DIST |
=GAMMA.DIST(2, 2, 1, FALSE) |
value |
|
bf5ced |
GAMMA.INV |
=GAMMA.INV(0.5, 2, 1) |
value |
|
03c6bd |
GAMMA.INV |
=GAMMA.INV(GAMMA.DIST(2, 2, 1, TRUE), 2, 1) |
value |
1 |
a7d7d0 |
GAMMADIST |
=GAMMADIST(2, 2, 1, TRUE) |
value |
|
e35752 |
GAMMADIST |
=GAMMADIST(2, 2, 1, FALSE) |
value |
|
85cfc2 |
GAMMAINV |
=GAMMAINV(0.5, 2, 1) |
value |
|
05518b |
GAMMAINV |
=GAMMAINV(GAMMADIST(3, 2, 1, TRUE), 2, 1) |
value |
|
6f64cb |
GAUSS |
=GAUSS(0) |
value |
1 |
9faa07 |
GAUSS |
=GAUSS(1) |
value |
|
dfce0f |
HYPGEOM.DIST |
=HYPGEOM.DIST(1, 4, 8, 20, FALSE) |
value |
|
a34ddd |
HYPGEOM.DIST |
=HYPGEOM.DIST(1, 4, 8, 20, TRUE) |
value |
|
cea0f3 |
HYPGEOM.DIST |
=HYPGEOM.DIST(0, 4, 8, 20, FALSE) |
value |
|
e3a2cb |
HYPGEOMDIST |
=HYPGEOMDIST(1, 4, 8, 20) |
value |
|
f41a26 |
HYPGEOMDIST |
=HYPGEOMDIST(0, 4, 8, 20) |
value |
|
9f865c |
LOGINV |
=LOGINV(0.5, 0, 1) |
value |
1 |
d9e084 |
LOGINV |
=LOGINV(LOGNORMDIST(2, 0, 1), 0, 1) |
value |
|
31fe08 |
LOGNORM.DIST |
=LOGNORM.DIST(2, 0, 1, TRUE) |
value |
|
c076d8 |
LOGNORM.DIST |
=LOGNORM.DIST(2, 0, 1, FALSE) |
value |
|
38f50d |
LOGNORM.INV |
=LOGNORM.INV(0.5, 0, 1) |
value |
1 |
da0fa9 |
LOGNORM.INV |
=LOGNORM.INV(LOGNORM.DIST(2, 0, 1, TRUE), 0, 1) |
value |
|
fb6e20 |
LOGNORMDIST |
=LOGNORMDIST(1, 0, 1) |
value |
2 |
8a7132 |
LOGNORMDIST |
=LOGNORMDIST(2, 0, 1) |
value |
|
661969 |
NEGBINOM.DIST |
=NEGBINOM.DIST(10, 5, 0.25, FALSE) |
value |
|
3bf9d0 |
NEGBINOM.DIST |
=NEGBINOM.DIST(10, 5, 0.25, TRUE) |
value |
|
9e96f7 |
NEGBINOM.DIST |
=NEGBINOM.DIST(0, 5, 0.5, FALSE) |
value |
|
3ecad1 |
NEGBINOMDIST |
=NEGBINOMDIST(10, 5, 0.25) |
value |
|
1ada2f |
NEGBINOMDIST |
=NEGBINOMDIST(0, 5, 0.5) |
value |
|
2823a6 |
NORM.DIST |
=NORM.DIST(0, 0, 1, TRUE) |
value |
1 |
f8db5f |
NORM.DIST |
=NORM.DIST(0, 0, 1, FALSE) |
value |
|
f0ac5e |
NORM.DIST |
=NORM.DIST(1, 0, 1, TRUE) |
value |
|
2cf81f |
NORM.DIST |
=NORM.DIST(42, 40, 1.5, TRUE) |
value |
|
8d7bbe |
NORM.INV |
=NORM.INV(0.5, 0, 1) |
value |
2 |
a16eda |
NORM.INV |
=NORM.INV(0.975, 0, 1) |
value |
|
aecc82 |
NORM.INV |
=NORM.INV(NORM.DIST(1.5, 0, 1, TRUE), 0, 1) |
value |
|
b1d7b4 |
NORM.S.DIST |
=NORM.S.DIST(0, TRUE) |
value |
2 |
3c94c5 |
NORM.S.DIST |
=NORM.S.DIST(0, FALSE) |
value |
|
485eeb |
NORM.S.DIST |
=NORM.S.DIST(1.96, TRUE) |
value |
|
679343 |
NORM.S.INV |
=NORM.S.INV(0.5) |
value |
2 |
568f13 |
NORM.S.INV |
=NORM.S.INV(0.975) |
value |
|
7169b0 |
NORMDIST |
=NORMDIST(0, 0, 1, TRUE) |
value |
1 |
c2fb4d |
NORMDIST |
=NORMDIST(0, 0, 1, FALSE) |
value |
|
86dcd2 |
NORMINV |
=NORMINV(0.5, 0, 1) |
value |
2 |
047aa7 |
NORMINV |
=NORMINV(0.95, 0, 1) |
value |
|
2075c8 |
NORMSDIST |
=NORMSDIST(0) |
value |
2 |
a309b5 |
NORMSDIST |
=NORMSDIST(1.96) |
value |
|
292a2e |
NORMSINV |
=NORMSINV(0.5) |
value |
2 |
69084f |
NORMSINV |
=NORMSINV(0.025) |
value |
|
2848bc |
PHI |
=PHI(0) |
value |
|
d1d9f2 |
PHI |
=PHI(1) |
value |
|
61dda8 |
POISSON |
=POISSON(0, 3, FALSE) |
value |
|
558d2d |
POISSON |
=POISSON(3, 3, FALSE) |
value |
|
82056b |
POISSON |
=POISSON(5, 3, TRUE) |
value |
|
de940d |
POISSON.DIST |
=POISSON.DIST(0, 3, FALSE) |
value |
|
ed50c3 |
POISSON.DIST |
=POISSON.DIST(3, 3, FALSE) |
value |
|
cfb24b |
POISSON.DIST |
=POISSON.DIST(5, 3, TRUE) |
value |
|
872355 |
T.DIST |
=T.DIST(0, 10, TRUE) |
value |
1 |
57874a |
T.DIST |
=T.DIST(0, 10, FALSE) |
value |
|
73766b |
T.DIST |
=T.DIST(1.812, 10, TRUE) |
value |
|
7dca37 |
T.DIST.2T |
=T.DIST.2T(1.812, 10) |
value |
|
677b8b |
T.DIST.2T |
=T.DIST.2T(0.5, 10) |
value |
|
26a574 |
T.DIST.RT |
=T.DIST.RT(1.812, 10) |
value |
|
b819dc |
T.DIST.RT |
=T.DIST.RT(0, 10) |
value |
1 |
8e4c28 |
T.INV |
=T.INV(0.5, 10) |
value |
1 |
da3cf3 |
T.INV |
=T.INV(T.DIST(1.5, 10, TRUE), 10) |
value |
|
641eb7 |
T.INV.2T |
=T.INV.2T(0.05, 10) |
value |
|
702eb4 |
T.INV.2T |
=T.INV.2T(T.DIST.2T(1.5, 10), 10) |
value |
|
8d2e7a |
TDIST |
=TDIST(1.812, 10, 1) |
value |
|
f1e449 |
TDIST |
=TDIST(1.812, 10, 2) |
value |
|
2d2e2f |
TINV |
=TINV(0.05, 10) |
value |
|
bc4988 |
TINV |
=TINV(TDIST(1.5, 10, 2), 10) |
value |
|
bf32b6 |
WEIBULL |
=WEIBULL(2, 2, 1, TRUE) |
value |
|
75cc32 |
WEIBULL |
=WEIBULL(2, 2, 1, FALSE) |
value |
|
57468b |
WEIBULL.DIST |
=WEIBULL.DIST(2, 2, 1, TRUE) |
value |
|
946f38 |
WEIBULL.DIST |
=WEIBULL.DIST(2, 2, 1, FALSE) |
value |
|
5af6dc |
WEIBULL.DIST |
=WEIBULL.DIST(0, 2, 1, TRUE) |
value |
1 |