Kiirote assiishsha gafa sase

CONFIDENCE

(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.

This function is available since LibreOffice 4.2.

Syntax

CONFIDENCE(Umiha; StDev; bikka)

Umihu umunni ammanamate badooshshi deerraati.

StDev xaphoomu dagata margeessu uurrooti.

Bikko xaphooma dagate bikkaati.

Example

=Jawaante(0.05;1.5;100) 0.29. aanno.

CONFIDENCE.NORM

(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.

This function is available since LibreOffice 4.2.

Syntax

CONFIDENCE(Umiha; StDev; bikka)

Umihu umunni ammanamate badooshshi deerraati.

StDev xaphoomu dagata margeessu uurrooti.

Bikko xaphooma dagate bikkaati.

Example

=Jawaante(0.05;1.5;100) 0.29. aanno.

CONFIDENCE

(1-umiha) rosamino tuqishshira umunni amanamate badooshshe qolanno.

Syntax

CONFIDENCE(Umiha; StDev; bikka)

Umihu umunni ammanamate badooshshi deerraati.

StDev xaphoomu dagata margeessu uurrooti.

Bikko xaphooma dagate bikkaati.

Example

=Jawaante(0.05;1.5;100) 0.29. aanno.

KURT

Daatu gambooshshiha tajete bikka qolanno (ajanna 4 hornyuwa shiqanno).

Syntax

KURT(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

The parameters should specify at least four values.

Example

=KURT(A1;A2;A3;A4;A5;A6)

COVARIANCE.S

Returns the covariance of the product of paired deviations, for a sample of the population.

This function is available since LibreOffice 4.2.

Syntax

COVARIANCE.S(Data1; Data2)

Daata1 umi daatu gamboosheeti.

Daata2 layinki daatu gamboosheeti.

Example

=COVAR(A1:A30;B1:B30)

COVARIANCE.P

Returns the covariance of the product of paired deviations, for the entire population.

This function is available since LibreOffice 4.2.

Syntax

COVARIANCE.P(Data1; Data2)

Daata1 umi daatu gamboosheeti.

Daata2 layinki daatu gamboosheeti.

Example

=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.

Syntax

CRITBINOM(Sasimma; SP; Umifidale)

Sasimma sasimmate xaphooma kiirooti.

SP mitte sasimma ikkanna hoongu ikkadimmaati.

Umi fidale hanafote ikkanna hoongiilla woy roora noosi.

Example

=CRITBINOM(100;0.5;0.1) gumma 44.

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)

Syntax

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.

Example

=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.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

Syntax

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.

Example

=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.

Syntax

CORREL(Daata1; Daata2)

Daata1 umi daatu gamboosheeti.

Daata2 layinki daatu gamboosheeti.

Example

=CORREL(A1:A50;B1:B50) lamu daatu gambooshshira shiimiidi hanqafaancho bikko gede fiixoontino hanqafaancho shallagganno.

LOGINV

rosantino borro tuqishshi galchamme qolanno.

Syntax

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.

Example

=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.

This function is available since LibreOffice 4.3.

Syntax

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.

Example

=LOGINV(0.05;0;1) 0.19 qolanno.

COVAR

waxamino beehaachi gumi xaadu badooshshe qolanno.

Syntax

COVAR(Daata1; Daata2)

Daata1 umi daatu gamboosheeti.

Daata2 layinki daatu gamboosheeti.

Example

=COVAR(A1:A30;B1:B30)

LOGNORMDIST

xawado beeddakko tuqishshi hornyuwa qolanno.

Syntax

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.

Example

=LOGNORMDIST(0.1;0;1) 0.01 qolanno.

LOGNORMDIST

xawado beeddakko tuqishshi hornyuwa qolanno.

This function is available since LibreOffice 4.3.

Syntax

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.

Example

=LOGNORMDIST(0.1;0;1) 0.01 qolanno.

Functions by Category