Kiirote assiishsha gafa sase
CONFIDENCE
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
=Jawaante(0.05;1.5;100) 0.29. aanno.
CONFIDENCE.NORM
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
=Jawaante(0.05;1.5;100) 0.29. aanno.
CONFIDENCE
(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.
CONFIDENCE(Umiha; StDev; bikka)
Umihu umunni ammanamate badooshshi deerraati.
StDev xaphoomu dagata margeessu uurrooti.
Bikko xaphooma dagate bikkaati.
=Jawaante(0.05;1.5;100) 0.29. aanno.
KURT
Daatu gambooshshiha tajete bikka qolanno (ajanna 4 hornyuwa shiqanno).
KURT(Number 1 [; Number 2 [; … [; Number 255]]])
The parameters should specify at least four values.
=KURT(A1;A2;A3;A4;A5;A6)
COVARIANCE.S
Returns the covariance of the product of paired deviations, for a sample of the population.
COVARIANCE.S(Data1; Data2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
=COVAR(A1:A30;B1:B30)
COVARIANCE.P
Returns the covariance of the product of paired deviations, for the entire population.
COVARIANCE.P(Data1; Data2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
=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.
CRITBINOM(Sasimma; SP; Umifidale)
Sasimma sasimmate xaphooma kiirooti.
SP mitte sasimma ikkanna hoongu ikkadimmaati.
Umi fidale hanafote ikkanna hoongiilla woy roora noosi.
=CRITBINOM(100;0.5;0.1) gumma 44.
LARGE
daatu gambooshshi giddo jawiidi deerri_c-th qolanno.
LARGE(Daata; RankC)
Daatu daataho bisiccote hakka geeshshaati.
RankC is the ranking of the value. If RankC is an array, the function becomes an array function.
=LARGE(A1:C50;2) gives the second largest value in A1:C50.
=LARGE(A1:C50;B1:B5) entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5.
SMALL
daatu gambooshshi giddo shiimiidi deerri_c-th qolanno.
SMALL(Daata; RankC)
Daatu daataho bisiccote hakka geeshshaati.
RankC is the rank of the value. If RankC is an array, the function becomes an array function.
=SMALL(A1:C50;2) gives the second smallest value in A1:C50.
=SMALL(A1:C50;B1:B5) entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5.
CORREL
lamu daatu gambooshshuwa mereero fiixoontino hanqafaancho qolanno.
CORREL(Daata1; Daata2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
=CORREL(A1:A50;B1:B50) lamu daatu gambooshshira shiimiidi hanqafaancho bikko gede fiixoontino hanqafaancho shallagganno.
LOGINV
rosantino borro tuqishshi galchamme qolanno.
LOGINV(Number [; Mean [; StDev]])
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi galchamme shallagama noose.
Mereerima margeessu shallago tuqishshiha arithmetike mereerimaati.
StDev margeessu shallago tuqishshira margeessu badooshsheeti.
=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.
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.
=LOGINV(0.05;0;1) 0.19 qolanno.
COVAR
waxamino beehaachi gumi xaadu badooshshe qolanno.
COVAR(Daata1; Daata2)
Daata1 umi daatu gamboosheeti.
Daata2 layinki daatu gamboosheeti.
=COVAR(A1:A30;B1:B30)
LOGNORMDIST
xawado beeddakko tuqishshi hornyuwa qolanno.
LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]])
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.
=LOGNORMDIST(0.1;0;1) 0.01 qolanno.
LOGNORMDIST
xawado beeddakko tuqishshi hornyuwa qolanno.
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.
=LOGNORMDIST(0.1;0;1) 0.01 qolanno.