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
(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.
COM.MICROSOFT.CONFIDENCE.T
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.
COM.MICROSOFT.CONFIDENCE.NORM
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.
COVAR
waxamino beehaachi gumi xaadu badooshshe qolanno.
COVAR(Daata1; Daata2)
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)
COM.MICROSOFT.COVARIANCE.P
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)
COM.MICROSOFT.COVARIANCE.S
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.
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.
This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.
=KURT(A1;A2;A3;A4;A5;A6)
LARGE
daatu gambooshshi giddo jawiidi deerri_c-th qolanno.
This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)
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.
This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.
=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.
LOGINV
rosantino borro tuqishshi galchamme qolanno.
LOGINV(Number [; Mean [; StDev]])
Number (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.
Mean (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).
StDev (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).
=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.
LOGNORM.INV(Number ; Mean ; StDev)
Kiiro ikkanna hoongete hornya ikkite margeessu shallago tuqishshi galchamme shallagama noose.
Mereerima margeessu shallago tuqishshiha arithmetike mereerimaati.
StDev (required) is the standard deviation of the standard logarithmic distribution.
=LOGINV(0.05;0;1) 0.19 qolanno.
COM.MICROSOFT.LOGNORM.INV
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.
COM.MICROSOFT.LOGNORM.DIST
SMALL
daatu gambooshshi giddo shiimiidi deerri_c-th qolanno.
This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)
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.
This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.
=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.