# Statistilised funktsioonid, 4. osa

Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.

Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.

## AVEDEV

Tagastab andmepunktide absoluuthĂ¤lvete (keskvĂ¤Ă¤rtusega vĂµrreldes) aritmeetilise keskmise. Kuvab andmehulga hajutuse.

#### SĂĽntaks

AVEDEV(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

=AVEDEV(A1:A50)

## AVERAGE

Tagastab argumentide aritmeetilise keskmise.

#### SĂĽntaks

AVERAGE(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

=AVERAGE(A1:A50)

## AVERAGEA

Tagastab argumentide aritmeetilise keskmise. Teksti vĂ¤Ă¤rtuseks on 0.

#### SĂĽntaks

AVERAGEA(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### NĂ¤ide

=AVERAGEA(A1:A50)

## MAX

Tagastab argumentide loendist selle maksimumvĂ¤Ă¤rtuse.

Tagastab 0, kui lahtriviitena esitatud lahtrivahemikus polnud arvvĂ¤Ă¤rtusi ega vigu. Funktsioonid MIN() ja MAX() ignoreerivad tekstilahtreid. Funktsioonid MINA() ja MAXA() tagastavad 0, kui vĂ¤Ă¤rtust (arvu ega teksti) pole ja vigu ei ilmnenud. Literaalstringist argumendi esitamine funktsioonile MIN() vĂµi MAX(), nĂ¤iteks MIN("string"), tagastab siiski veavĂ¤Ă¤rtuse.

#### SĂĽntaks

MAX(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

#### NĂ¤ide

=MAX(A1;A2;A3;50;100;200) tagastab loendi suurima vĂ¤Ă¤rtuse.

=MAX(A1:B100) tagastab loendi suurima vĂ¤Ă¤rtuse.

## MAXA

Tagastab suurima vĂ¤Ă¤rtuse argumentide loendis. Erinevalt funktsioonist MAX saab siin sisestada ka teksti. Teksti vĂ¤Ă¤rtus on 0.

Funktsioonid MINA() ja MAXA() tagastavad 0, kui vĂ¤Ă¤rtust (arvu ega teksti) pole ja vigu ei ilmnenud.

#### SĂĽntaks

MAXA(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### NĂ¤ide

=MAXA(A1;A2;A3;50;100;200;"Tekst") tagastab loendi suurima vĂ¤Ă¤rtuse.

=MAXA(A1:B100) tagastab loendi suurima vĂ¤Ă¤rtuse.

## MEDIAN

Tagastab arvuhulga keskmise (mediaanvĂ¤Ă¤rtuse). Kui hulk sisaldab paaritut arvu vĂ¤Ă¤rtusi, on mediaanvĂ¤Ă¤rtuse arvuhulga keskel asuv vĂ¤Ă¤rtus; paarisarvu vĂ¤Ă¤rtusi sisaldavas hulgas on mediaanvĂ¤Ă¤rtus kahe hulga keskel asuva arvu aritmeetiline keskmine.

#### SĂĽntaks

MEDIAN(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

#### NĂ¤ide

kui argumente on paaritu arv: =MEDIAN(1; 5; 9; 20; 21) tagastab 9 kui keskmise vĂ¤Ă¤rtuse.

kui argumente on paarisarv: =MEDIAN(1; 5; 9; 20) tagastab kahe keskmise vĂ¤Ă¤rtuse 5 ja 9 keskmise, mis on 7.

## MIN

Tagastab argumentide loendist selle vĂ¤hima vĂ¤Ă¤rtuse.

Tagastab 0, kui lahtriviitena esitatud lahtrivahemikus polnud arvvĂ¤Ă¤rtusi ega vigu. Funktsioonid MIN() ja MAX() ignoreerivad tekstilahtreid. Funktsioonid MINA() ja MAXA() tagastavad 0, kui vĂ¤Ă¤rtust (arvu ega teksti) pole ja vigu ei ilmnenud. Literaalstringist argumendi esitamine funktsioonile MIN() vĂµi MAX(), nĂ¤iteks MIN("string"), tagastab siiski veavĂ¤Ă¤rtuse.

#### SĂĽntaks

MIN(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

#### NĂ¤ide

=MIN(A1:B100) tagastab loendi vĂ¤ikseima vĂ¤Ă¤rtuse.

## MINA

Tagastab vĂ¤ikseima vĂ¤Ă¤rtuse argumentide loendis. Siin saab sisestada ka teksti. Teksti vĂ¤Ă¤rtus on 0.

Funktsioonid MINA() ja MAXA() tagastavad 0, kui vĂ¤Ă¤rtust (arvu ega teksti) pole ja vigu ei ilmnenud.

#### SĂĽntaks

MINA(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### NĂ¤ide

=MINA(1;"Tekst";20) tagastab 0.

=MINA(A1:B100) tagastab loendi vĂ¤ikseima vĂ¤Ă¤rtuse.

## MODE

Tagastab kĂµige sagedasema vĂ¤Ă¤rtuse andmehulgas. Kui mitu vĂ¤Ă¤rtust on sama sagedusega, tagastatakse vĂ¤ikseim nendest. Kui ĂĽkski vĂ¤Ă¤rtus ei kordu, annab funktsioon veateate.

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

#### SĂĽntaks

MODE(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

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.

=MODE(A1:A50)

## MODE.MULT

Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.

#### SĂĽntaks

MODE.MULT(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.

=MODE(A1:A50)

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.MODE.MULT

## MODE.SNGL

Tagastab kĂµige sagedasema vĂ¤Ă¤rtuse andmehulgas. Kui mitu vĂ¤Ă¤rtust on sama sagedusega, tagastatakse vĂ¤ikseim nendest. Kui ĂĽkski vĂ¤Ă¤rtus ei kordu, annab funktsioon veateate.

#### SĂĽntaks

MODE.SNGL(Number 1 [; Number 2 [; â€¦ [; Number 255]]])

Number 1, Number 2, â€¦ , Number 255 are numbers, references to cells or to cell ranges of numbers.

If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.

=MODE(A1:A50)

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.MODE.SNGL

## NEGBINOM.DIST

Tagastab negatiivse binoomjaotuse.

#### SĂĽntaks

NEGBINOMDIST(X; R; SP)

X tĂ¤histab ebaĂµnnestunud katsete korral tagastatavat vĂ¤Ă¤rtust.

R tĂ¤histab Ăµnnestunud katsete korral tagastatavat vĂ¤Ă¤rtust.

SP on ĂĽhe katse edu tĂµenĂ¤osus.

Kumulatiivne (pole kohustuslik) = 0 arvutab tihedusfunktsiooni, Kumulatiivne = 1 arvutab jaotuse.

#### NĂ¤ide

=NEGBINOMDIST(1;1;0,5) tagastab 0,25.

=NEGBINOMDIST(1;1;0,5) tagastab 0,25.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NEGBINOM.DIST

## NEGBINOMDIST

Tagastab negatiivse binoomjaotuse.

#### SĂĽntaks

NEGBINOMDIST(X; R; SP)

X tĂ¤histab ebaĂµnnestunud katsete korral tagastatavat vĂ¤Ă¤rtust.

R tĂ¤histab Ăµnnestunud katsete korral tagastatavat vĂ¤Ă¤rtust.

SP on ĂĽhe katse edu tĂµenĂ¤osus.

#### NĂ¤ide

=NEGBINOMDIST(1;1;0,5) tagastab 0,25.

## NORM.DIST

Tagastab kumulatiivse normaaljaotuse tihedusfunktsiooni.

#### SĂĽntaks

NORMDIST(arv; keskmine; stdev; c)

Arv on jaotuse vĂ¤Ă¤rtus, mille pĂµhjal arvutatakse normaaljaotus.

Keskmine on jaotuse keskmine vĂ¤Ă¤rtus.

Stdev on kogu populatsiooni standardhĂ¤lve.

C pole kohustuslik. C = 0 arvutab tihedusfunktsiooni, C = 1 arvutab jaotuse.

#### NĂ¤ide

=NORMDIST(70;63;5;0) tagastab 0,03.

=NORMDIST(70;63;5;1) tagastab 0,92.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NORM.DIST

## NORM.INV

Tagastab kumulatiivse normaaljaotuse pĂ¶Ă¶rdvĂ¤Ă¤rtuse.

#### SĂĽntaks

NORMINV(arv; keskmine; stdev)

Arv on tĂµenĂ¤osusvĂ¤Ă¤rtus, mida kasutatakse normaaljaotuse pĂ¶Ă¶rdvĂ¤Ă¤rtuse mĂ¤Ă¤ramiseks.

Keskmine on pĂ¶Ă¶rdnormaaljaotuse keskmine vĂ¤Ă¤rtus.

Stdev on normaaljaotuse standardhĂ¤lve.

#### NĂ¤ide

=NORMINV(0,9;63;5) tagastab 69,41. Kui keskmine muna kaalub 63 grammi ja standardhĂ¤lve on 5, on 90% tĂµenĂ¤osus, et muna pole raskem kui 69,41 grammi.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NORM.INV

## NORMDIST

Tagastab kumulatiivse normaaljaotuse tihedusfunktsiooni.

#### SĂĽntaks

NORMDIST(Number; Mean; StDev [; C])

Arv on jaotuse vĂ¤Ă¤rtus, mille pĂµhjal arvutatakse normaaljaotus.

Keskmine on jaotuse keskmine vĂ¤Ă¤rtus.

Stdev on kogu populatsiooni standardhĂ¤lve.

C pole kohustuslik. C = 0 arvutab tihedusfunktsiooni, C = 1 arvutab jaotuse.

#### NĂ¤ide

=NORMDIST(70;63;5;0) tagastab 0,03.

=NORMDIST(70;63;5;1) tagastab 0,92.

## NORMINV

Tagastab kumulatiivse normaaljaotuse pĂ¶Ă¶rdvĂ¤Ă¤rtuse.

#### SĂĽntaks

NORMINV(arv; keskmine; stdev)

Arv on tĂµenĂ¤osusvĂ¤Ă¤rtus, mida kasutatakse normaaljaotuse pĂ¶Ă¶rdvĂ¤Ă¤rtuse mĂ¤Ă¤ramiseks.

Keskmine on pĂ¶Ă¶rdnormaaljaotuse keskmine vĂ¤Ă¤rtus.

Stdev on normaaljaotuse standardhĂ¤lve.

#### NĂ¤ide

=NORMINV(0,9;63;5) tagastab 69,41. Kui keskmine muna kaalub 63 grammi ja standardhĂ¤lve on 5, on 90% tĂµenĂ¤osus, et muna pole raskem kui 69,41 grammi.

## PEARSON

Tagastab Pearsoni korrelatsioonikordaja r.

#### SĂĽntaks

PEARSON(andmed_1; andmed_2)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

Klassid on piirvĂ¤Ă¤rtuste massiiv.

#### NĂ¤ide

=PEARSON(A1:A30;B1:B30) tagastab mĂµlema andmehulga Pearsoni korrelatsioonikordaja.

## PERCENTILE

Tagastab massiivi andmevĂ¤Ă¤rtuste alfaprotsentiili. Protsentiil tagastab andmejada skaalavĂ¤Ă¤rtuse, mis lĂ¤heb andmejada vĂ¤ikseimast (alfa=0) kuni suurima (alfa=1) vĂ¤Ă¤rtuseni. Kui alfa = 25%, tĂ¤hendab protsentiil esimest kvartiili; alfa = 50% on MEDIAN (mediaanvĂ¤Ă¤rtus).

#### SĂĽntaks

PERCENTILE(andmed; alfa)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

Alfa on skaala protsent vahemikus 0 kuni 1.

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.

#### NĂ¤ide

=PERCENTILE(A1:A50;0.1) on andmehulgas vĂ¤Ă¤rtus, mis vĂµrdub 10% kogu andmeskaalast vahemikus A1:A50.

## PERCENTILE.EXC

Tagastab massiivi andmevĂ¤Ă¤rtuste alfaprotsentiili. Protsentiil tagastab andmejada skaalavĂ¤Ă¤rtuse, mis lĂ¤heb andmejada vĂ¤ikseimast (alfa=0) kuni suurima (alfa=1) vĂ¤Ă¤rtuseni. Kui alfa = 25%, tĂ¤hendab protsentiil esimest kvartiili; alfa = 50% on MEDIAN (mediaanvĂ¤Ă¤rtus).

If Alpha is not a multiple of 1/(n+1), (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if Alpha is less than 1/(n+1) or Alpha is greater than n/(n+1), the function is unable to interpolate, and so returns an error.

The difference between PERCENTILE.INC and PERCENTILE.EXC is that, in the PERCENTILE.INC function the value of alpha is within the range 0 to 1 inclusive, and in the PERCENTILE.EXC function, the value of alpha is within the range 0 to 1 exclusive.

#### SĂĽntaks

PERCENTILE(andmed; alfa)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

Alfa on skaala protsent vahemikus 0 kuni 1.

#### NĂ¤ide

=PERCENTILE(A1:A50;0.1) on andmehulgas vĂ¤Ă¤rtus, mis vĂµrdub 10% kogu andmeskaalast vahemikus A1:A50.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTILE.EXC

## PERCENTILE.INC

Tagastab massiivi andmevĂ¤Ă¤rtuste alfaprotsentiili. Protsentiil tagastab andmejada skaalavĂ¤Ă¤rtuse, mis lĂ¤heb andmejada vĂ¤ikseimast (alfa=0) kuni suurima (alfa=1) vĂ¤Ă¤rtuseni. Kui alfa = 25%, tĂ¤hendab protsentiil esimest kvartiili; alfa = 50% on MEDIAN (mediaanvĂ¤Ă¤rtus).

The difference between PERCENTILE.INC and PERCENTILE.EXC is that, in the PERCENTILE.INC function the value of alpha is within the range 0 to 1 inclusive, and in the PERCENTILE.EXC function, the value of alpha is within the range 0 to 1 exclusive.

#### SĂĽntaks

PERCENTILE(andmed; alfa)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

Alfa on skaala protsent vahemikus 0 kuni 1.

#### NĂ¤ide

=PERCENTILE(A1:A50;0.1) on andmehulgas vĂ¤Ă¤rtus, mis vĂµrdub 10% kogu andmeskaalast vahemikus A1:A50.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTILE.INC

## PERCENTRANK

Tagastab valimi liikme protsentuaalse jĂ¤rgu.

#### SĂĽntaks

PERCENTRANK(Data; Value [; Significance])

Klassid on piirvĂ¤Ă¤rtuste massiiv.

VĂ¤Ă¤rtus on vĂ¤Ă¤rtus, mille protsentiilreiting tuleb mĂ¤Ă¤ratleda.

Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. If omitted, a value of 3 is used.

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.

#### NĂ¤ide

=PERCENTRANK(A1:A50;50) tagastab vĂ¤Ă¤rtuse 50 protsentreitingu kĂµigi vahemikus A1:A50 leiduvate vĂ¤Ă¤rtuste hulgas. Kui 50 jĂ¤Ă¤b vĂ¤ljapoole koguvahemikku, kuvatakse veateade.

## PERCENTRANK.EXC

Tagastab valimi liikme protsentuaalse jĂ¤rgu.

The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive.

#### SĂĽntaks

PERCENTRANK.EXC(Data; Value [; Significance])

Klassid on piirvĂ¤Ă¤rtuste massiiv.

VĂ¤Ă¤rtus on vĂ¤Ă¤rtus, mille protsentiilreiting tuleb mĂ¤Ă¤ratleda.

Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.

#### NĂ¤ide

=PERCENTRANK(A1:A50;50) tagastab vĂ¤Ă¤rtuse 50 protsentreitingu kĂµigi vahemikus A1:A50 leiduvate vĂ¤Ă¤rtuste hulgas. Kui 50 jĂ¤Ă¤b vĂ¤ljapoole koguvahemikku, kuvatakse veateade.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTRANK.EXC

## PERCENTRANK.INC

Tagastab valimi liikme protsentuaalse jĂ¤rgu.

The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive.

#### SĂĽntaks

PERCENTRANK.INC(Data; Value [; Significance])

Klassid on piirvĂ¤Ă¤rtuste massiiv.

VĂ¤Ă¤rtus on vĂ¤Ă¤rtus, mille protsentiilreiting tuleb mĂ¤Ă¤ratleda.

Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.

#### NĂ¤ide

=PERCENTRANK(A1:A50;50) tagastab vĂ¤Ă¤rtuse 50 protsentreitingu kĂµigi vahemikus A1:A50 leiduvate vĂ¤Ă¤rtuste hulgas. Kui 50 jĂ¤Ă¤b vĂ¤ljapoole koguvahemikku, kuvatakse veateade.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTRANK.INC

## PHI

Returns the value of the probability density function for a given value considering the standard normal distribution.

#### SĂĽntaks

PHI(Number)

Number is the value for which the probability density function is calculated.

#### NĂ¤ide

=PHI(2.25) returns 0.0317.

=PHI(-2.25) also returns 0.0317 because the normal distribution is symmetrical.

=PHI(0) returns 0.3989.

Calling PHI(Number) is equivalent to calling NORMDIST(Number,0,1,FALSE()) or NORM.S.DIST(Number;FALSE()), hence using the standard normal distribution with mean equal to 0 and standard deviation equal to 1 with the Cumulative argument set to False.

## POISSON

Tagastab Poissoni jaotuse.

#### SĂĽntaks

POISSON(Number; Mean [; C])

Arv on vĂ¤Ă¤rtus, mille pĂµhjal Poissoni jaotus arvutatakse.

Keskmine on Poissoni jaotuse keskmine vĂ¤Ă¤rtus.

C (mittekohustuslik) = 0 vĂµi VĂ¤Ă¤r arvutab tihedusfunktsiooni; C = 1 vĂµi TĂµene arvutab jaotuse. Kui see argument Ă¤ra jĂ¤tta, lisatakse dokumendi salvestamisel vaikevĂ¤Ă¤rtus TĂµene, et tagada parim ĂĽhilduvus muude programmide ja LibreOffice'i vanemate versioonidega.

#### NĂ¤ide

=POISSON(60;50;1) tagastab 0,93.

## POISSON.DIST

Tagastab Poissoni jaotuse.

#### SĂĽntaks

POISSON.DIST(Number; Mean ; Cumulative)

Arv on vĂ¤Ă¤rtus, mille pĂµhjal Poissoni jaotus arvutatakse.

Keskmine on Poissoni jaotuse keskmine vĂ¤Ă¤rtus.

Cumulative = 0 or False to calculate the probability mass function; Cumulative = 1, True, or any other non-zero value to calculate the cumulative distribution function.

#### NĂ¤ide

=POISSON(60;50;1) tagastab 0,93.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.2-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.POISSON.DIST

## QUARTILE

Tagastab andmehulga kvartiili.

#### SĂĽntaks

QUARTILE(andmed; tĂĽĂĽp)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

TĂĽĂĽp on kvartiili tĂĽĂĽp. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% ja 4 = MAX.)

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.

#### NĂ¤ide

=QUARTILE(A1:A50;2) tagastab vĂ¤Ă¤rtuse, mille skaalast 50% vastab vĂ¤ikseimast kuni suurima vĂ¤Ă¤rtuseni vahemikus A1:A50.

## QUARTILE.EXC

Tagastab andmehulga kvartiili.

The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive.

#### SĂĽntaks

QUARTILE(andmed; tĂĽĂĽp)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

Type An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values)

#### NĂ¤ide

=QUARTILE(A1:A50;2) tagastab vĂ¤Ă¤rtuse, mille skaalast 50% vastab vĂ¤ikseimast kuni suurima vĂ¤Ă¤rtuseni vahemikus A1:A50.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.QUARTILE.EXC

## QUARTILE.INC

Tagastab andmehulga kvartiili.

The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive.

#### SĂĽntaks

QUARTILE(andmed; tĂĽĂĽp)

Klassid on piirvĂ¤Ă¤rtuste massiiv.

TĂĽĂĽp on kvartiili tĂĽĂĽp. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% ja 4 = MAX.)

#### NĂ¤ide

=QUARTILE(A1:A50;2) tagastab vĂ¤Ă¤rtuse, mille skaalast 50% vastab vĂ¤ikseimast kuni suurima vĂ¤Ă¤rtuseni vahemikus A1:A50.

#### Technical information

See funktsioon on saadaval alates LibreOffice 4.3-st.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.QUARTILE.INC

Palun toeta meid!