Kiirote assiishsha gafa sase
CONFIDENCE
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
Ganallo
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
Lawishsha
=Jawaante(0.05;1.5;100) 0.29. aanno.
CONFIDENCE
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
Ganallo
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
Lawishsha
=Jawaante(0.05;1.5;100) 0.29. aanno.
CONFIDENCE.NORM
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
Ganallo
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
Lawishsha
=Jawaante(0.05;1.5;100) 0.29. aanno.
CORREL
lamu daatu gambooshshuwa mereero fiixoontino hanqafaancho qolanno.
Ganallo
CORREL(Daata1; Daata2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
Lawishsha
=CORREL(A1:A50;B1:B50) lamu daatu gambooshshira shiimiidi hanqafaancho bikko gede fiixoontino hanqafaancho shallagganno.
COVAR
waxamino beehaachi gumi xaadu badooshshe qolanno.
Ganallo
COVAR(Daata1; Daata2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
Lawishsha
=COVAR(A1:A30;B1:B30)
COVARIANCE.P
Returns the covariance of the product of paired deviations, for the entire population.
Ganallo
COVARIANCE.P(Data1; Data2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
Lawishsha
=COVAR(A1:A30;B1:B30)
COVARIANCE.S
Returns the covariance of the product of paired deviations, for a sample of the population.
Ganallo
COVARIANCE.S(Data1; Data2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
Lawishsha
=COVAR(A1:A30;B1:B30)
CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
Ganallo
CRITBINOM(Sasimma; SP; Umifidale)
Sasimma sasimmate xaphooma kiirooti.
SP mitte sasimma ikkanna hoongu ikkadimmaati.
Umi fidale hanafote ikkanna hoongiilla woy roora noosi.
Lawishsha
=CRITBINOM(100;0.5;0.1) gumma 44.
KURT
Daatu gambooshshiha tajete bikka qolanno (ajanna 4 hornyuwa shiqanno).
Ganallo
KURT(Number1; Number2; ...; Number30)
Number1, Number2, ..., Number30 are numeric arguments or ranges representing a random sample of distribution.
Lawishsha
=KURT(A1;A2;A3;A4;A5;A6)
LARGE
daatu gambooshshi giddo jawiidi deerri_c-th qolanno.
Ganallo
LARGE(Daata; RankC)
Daatu daataho bisiccote hakka geeshshaati.
deerraC hornyu deerraati.
Lawishsha
=jawa(A1:C50;2) A1:C50 giddo layiinkki jawiidi hornyaati.
LOGINV
rosantino borro tuqishshi galchamme qolanno.
Ganallo
LOGINV(Kiiro; Mereerima; StDev)
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi galchamme shallagama noose.
Mereerima margeessu shallago tuqishshiha arithmetike mereerimaati.
StDev margeessu shallago tuqishshira margeessu badooshsheeti.
Lawishsha
=LOGINV(0.05;0;1) 0.19 qolanno.
LOGNORMDIST
rosantino borro tuqishshi galchamme qolanno.
This function is identical to LOGINV and was introduced for interoperability with other office suites.
Ganallo
LOGINV(Kiiro; Mereerima; StDev)
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi galchamme shallagama noose.
Mereerima margeessu shallago tuqishshiha arithmetike mereerimaati.
StDev (doorsha) margeessu shallago tuqishshira margeessu badooshsheeti.
Lawishsha
=LOGINV(0.05;0;1) 0.19 qolanno.
LOGNORMDIST
xawado beeddakko tuqishshi hornyuwa qolanno.
Ganallo
LOGNORMDIST(Kiiro; Mereerima; StDev; xaphooma)
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi shallagama noose.
Mereerima (doorsha) margeessu shallago tuqishshira mereerima hornyooti.
StDev (doorsha) margeessu shallago tuqishshira margeessu badooshsheeti.
Xaphoomu (doorshu) = 0 dargu amado assiishsha shallaganno, xaphoomu = 1 tuqishsha shallaganno.
Lawishsha
=LOGNORMDIST(0.1;0;1) 0.01 qolanno.
LOGNORMDIST
xawado beeddakko tuqishshi hornyuwa qolanno.
Ganallo
LOGNORMDIST(Kiiro; Mereerima; StDev; xaphooma)
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi shallagama noose.
Mereerima (doorsha) margeessu shallago tuqishshira mereerima hornyooti.
StDev (doorsha) margeessu shallago tuqishshira margeessu badooshsheeti.
Xaphoomu (doorshu) = 0 dargu amado assiishsha shallaganno, xaphoomu = 1 tuqishsha shallaganno.
Lawishsha
=LOGNORMDIST(0.1;0;1) 0.01 qolanno.
SMALL
daatu gambooshshi giddo shiimiidi deerri_c-th qolanno.
Ganallo
SMALL(Daata; RankC)
Daatu daataho bisiccote hakka geeshshaati.
deerraC hornyu deerraati.
Lawishsha
=shiima(A1:C50;2) A1:C50 giddo layiinkki shiimiidi hornyaati.