Kiirote assiishsha gafa sase

CONFIDENCE

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

tip

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.

tip

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.

tip

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.

tip

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.

Qaagishshu Bido

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.

Qaagishshu Bido

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.

tip

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.

tip

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.

Please support us!