Funkcji statystyczne

[ ] indicates optional parameters

CZĘSTOŚĆ(tablica_dane, tablica_przedziały)
ILE.LICZB(wartość1, [wartość2, ...])
ILE.NIEPUSTYCH(wartość1, [wartość2, ...])
KOWARIANCJA(tablica1, tablica2)
KURTOZA(liczba1, [liczba2, ...])
KWARTYL(tablica, kwartyl)
MAX(liczba1, [liczba2, ...])
MAX.A(wartość1, [wartość2, ...])
MAX.K(tablica, k)
MEDIANA(liczba1, [liczba2, ...])
MIN(liczba1, [liczba2, ...])
MIN.A(wartość1, [wartość2, ...])
MIN.K(tablica, k)
NACHYLENIE(znane_y, znane_x)
NORMALIZUJ(x, średnia, odchylenie_std)
ODCH.KWADRATOWE(liczba1, [liczba2, ...])
ODCH.STANDARD.POPUL(liczba1, [liczba2, ...])
ODCH.STANDARD.POPUL.A(wartość1, [wartość2, ...])
ODCH.STANDARDOWE(liczba1, [liczba2, ...])
ODCH.STANDARDOWE.A(wartość1, [wartość2, ...])
ODCH.ŚREDNIE(liczba1, [liczba2, ...])
ODCIĘTA(znane_y, znane_x)
PEARSON(tablica1, tablica2)
PERCENTYL(tablica, k)
PERMUTACJE(liczba, liczba_wybrana)
POZYCJA(liczba, lista, [lp])
PRAWDPD(zakres_x, zakres_prawdop, dolna_granica, [górna_granica])
PROCENT.POZYCJA(tablica, x, [istotność])
PRÓG.ROZKŁAD.DWUM(próby, prawdopodob_s, alfa)
R.KWADRAT(znane_y, znane_x)
REGBŁSTD(znane_y, znane_x)
REGEXPP(znane_y, [znane_x], [stała], [statystyka])
REGEXPW(znane_y, [znane_x], [nowe_x], [stała])
REGLINP(znane_y, [znane_x], [stała], [statystyka])
REGLINW(znane_y, [znane_x], [nowe_x], [stała])
REGLINX(x, znane_y, znane_x)
ROZKŁAD.BETA(x, alfa, beta, [A], [B])
ROZKŁAD.BETA.ODW(prawdopodobieństwo, alfa, beta, [A], [B])
ROZKŁAD.CHI(x, stopnie_swobody)
ROZKŁAD.CHI.ODW(prawdopodobieństwo, stopnie_swobody)
ROZKŁAD.DWUM(liczba_s, próby, prawdopodob_s, skumulowany)
ROZKŁAD.DWUM.PRZEC(liczba_p, liczba_s, prawdopodob_s)
ROZKŁAD.EXP(x, lambda, skumulowany)
ROZKŁAD.F(x, stopnie_swobody1, stopnie_swobody2)
ROZKŁAD.F.ODW(prawdopodobieństwo, stopnie_swobody1, stopnie_swobody2)
ROZKŁAD.FISHER(x)
ROZKŁAD.FISHER.ODW(y)
ROZKŁAD.GAMMA(x, alfa, beta, skumulowany)
ROZKŁAD.GAMMA.ODW(prawdopodobieństwo, alfa, beta)
ROZKŁAD.HIPERGEOM(próbka_s, wielk_próbki, populacja_s, wielk_populacji)
ROZKŁAD.LIN.GAMMA(x)
ROZKŁAD.LOG(x, średnia, odchylenie_std)
ROZKŁAD.LOG.ODW(prawdopodobieństwo, średnia, odchylenie_std)
ROZKŁAD.NORMALNY(x, średnia, odchylenie_std, skumulowany)
ROZKŁAD.NORMALNY.ODW(prawdopodobieństwo, średnia, odchylenie_std)
ROZKŁAD.NORMALNY.S(z)
ROZKŁAD.NORMALNY.S.ODW(prawdopodobieństwo)
ROZKŁAD.POISSON(x, średnia, skumulowany)
ROZKŁAD.T(x, stopnie_swobody, ślady)
ROZKŁAD.T.ODW(prawdopodobieństwo, stopnie_swobody)
ROZKŁAD.WEIBULL(x, alfa, beta, skumulowany)
SKOŚNOŚĆ(liczba1, [liczba2, ...])
TEST.CHI(zakres_bieżący, zakres_przewidywany)
TEST.F(tablica1, tablica2)
TEST.T(tablica1, tablica2, ślady, typ)
TEST.Z(tablica, x, [sigma])
UFNOŚĆ(alfa, odchylenie_std, rozmiar)
WARIANCJA(liczba1, [liczba2, ...])
WARIANCJA.A(wartość1, [wartość2, ...])
WARIANCJA.POPUL(liczba1, [liczba2, ...])
WARIANCJA.POPUL.A(wartość1, [wartość2, ...])
WSP.KORELACJI(tablica1, tablica2)
WYST.NAJCZĘŚCIEJ(liczba1, [liczba2, ...])
ŚREDNIA(liczba1, [liczba2, ...])
ŚREDNIA.A(wartość1, [wartość2, ...])
ŚREDNIA.GEOMETRYCZNA(liczba1, [liczba2, ...])
ŚREDNIA.HARMONICZNA(liczba1, [liczba2, ...])
ŚREDNIA.WEWN(tablica, procent)


Statistical functions

CZĘSTOŚĆ(tablica_dane, tablica_przedziały)

Returns the counts of items in specified numeric categories.

tablica_daneAn array or reference to a range of cells containing values to be counted.
tablica_przedziałyAn array or reference to a range of cells containing the upper limits for each category.


ILE.LICZB(wartość1, [wartość2, ...])

Returns the count of numbers in a list.

wartość1, ...The items whose numbers are to be counted.


ILE.NIEPUSTYCH(wartość1, [wartość2, ...])

Returns the count of values in a list.

wartość1, ...The items whose values are to be counted.


KOWARIANCJA(tablica1, tablica2)

Returns the covariance of two ranges.

tablica1The first range to be compared.
tablica2The second range to be compared.


KURTOZA(liczba1, [liczba2, ...])

Returns the kurtosis of a set of numbers.

liczba1, ...The numbers of which you want the kurtosis.


KWARTYL(tablica, kwartyl)

Returns the specified quartile of a set of numbers.

tablicaAn array or reference to cells containing the numbers.
kwartylSpecifies which quartile to return. The possible values are:
0Returns the minimum value.
1Returns the first quartile.
2Returns the second quartile.
3Returns the third quartile.
4Returns the maximum value.


MAX(liczba1, [liczba2, ...])

Returns the maximum of a set of numbers.

liczba1, ...The numbers of which you want the maximum.


MAX.A(wartość1, [wartość2, ...])

Returns the maximum of a set of values.

wartość1, ...The values of which you want the maximum.


MAX.K(tablica, k)

Returns the kth largest number in a set of numbers.

tablicaAn array or reference to cells containing numbers of which you want the kth largest.
kThe rank of the number that you want.


MEDIANA(liczba1, [liczba2, ...])

Returns the median of a set of numbers.

liczba1, ...The numbers of which you want the median.


MIN(liczba1, [liczba2, ...])

Returns the minimum of a set of numbers.

liczba1, ...The numbers of which you want the minimum.


MIN.A(wartość1, [wartość2, ...])

Returns the minimum of a set of values.

wartość1, ...The values of which you want the minimum.


MIN.K(tablica, k)

Returns the kth smallest number in a set of numbers.

tablicaAn array or reference to cells containing numbers of which you want the kth smallest.
kThe rank of the number that you want.


NACHYLENIE(znane_y, znane_x)

Returns the slope of a line passing through a specified set of points.

znane_yThe y values that are already known.
znane_xThe x values that are already known.


NORMALIZUJ(x, średnia, odchylenie_std)

Returns the standardized value of x for the specified mean and standard deviation.

xThe value that you want to standardize.
średniaThe mean of the values.
odchylenie_stdThe standard deviation of the values.


ODCH.KWADRATOWE(liczba1, [liczba2, ...])

Returns the sum of the squares of the differences of a set of numbers from their mean.

liczba1, ...The numbers of which you want the squared deviations.


ODCH.STANDARD.POPUL(liczba1, [liczba2, ...])

Returns the standard deviation (based on the entire population) of a set of numbers.

liczba1, ...The numbers of which you want the standard deviation.


ODCH.STANDARD.POPUL.A(wartość1, [wartość2, ...])

Returns the standard deviation (based on the entire population) of a set of values.

wartość1, ...The values of which you want the standard deviation.


ODCH.STANDARDOWE(liczba1, [liczba2, ...])

Returns the standard deviation (based on a population sample) of a set of numbers.

liczba1, ...The numbers of which you want the standard deviation.


ODCH.STANDARDOWE.A(wartość1, [wartość2, ...])

Returns the standard deviation (based on a population sample) of a set of values.

wartość1, ...The values of which you want the standard deviation.


ODCH.ŚREDNIE(liczba1, [liczba2, ...])

Returns the average of the differences of a set of numbers from their mean.

liczba1, ...The numbers of which you want the average deviation.


ODCIĘTA(znane_y, znane_x)

Returns the expected value of y when x is zero for a line passing though a specified set of points.

znane_yThe y values that are already known.
znane_xThe x values that are already known.


PEARSON(tablica1, tablica2)

Returns the Pearson correlation coefficient.

tablica1The first range to be compared.
tablica2The second range to be compared.


PERCENTYL(tablica, k)

Returns the kth percentile of a set of values.

tablicaAn array or reference to cells containing the values.
kThe percentile value.


PERMUTACJE(liczba, liczba_wybrana)

Returns the number of permutations in which a number of items can be chosen from a total number.

liczbaThe total number of items.
liczba_wybranaThe number of items chosen.


POZYCJA(liczba, lista, [lp])

Returns the rank of a number in a set of numbers.

liczbaThe number of which you want the rank.
listaAn array or reference to cells containing the values.
lpSpecifies whether the list is treated as being in ascending or descending order of value. The possible values are:
0The list is in descending order (the highest value has rank 1).
any other valueThe list is in ascending order (the lowest value has rank 1).
If this parameter is omitted it defaults to 0.


PRAWDPD(zakres_x, zakres_prawdop, dolna_granica, [górna_granica])

Returns the probability that numbers in a set are between the specified limits.

zakres_xAn array or reference to cells containing the numbers.
zakres_prawdopAn array or reference to cells containing the probabilities associated with each number. These values must add up to 1.
dolna_granicaThe lower limit of the test.
górna_granicaThe upper limit of the test. If this value is omitted it defaults to the value specified for the lower limit.


PROCENT.POZYCJA(tablica, x, [istotność])

Returns the percentile of a value in a set of values.

tablicaAn array or reference to cells containing the values.
xThe value of which you want the percentile.
istotnośćThe number of decimal places required in the result. If this parameter is omitted it defaults to 3.


PRÓG.ROZKŁAD.DWUM(próby, prawdopodob_s, alfa)

Returns the value at which the cumulative binomial distribution is greater than or equal to alpha.

próbyThe total number of trials.
prawdopodob_sThe probability of a single trial being successful.
alfaThe value at which you want to evaluate the function.


R.KWADRAT(znane_y, znane_x)

Returns the square of the Pearson correlation coefficient.

znane_yThe first range to be compared.
znane_xThe second range to be compared.


REGBŁSTD(znane_y, znane_x)

Returns the standard error of the y values of a line passing through a specified set of points.

znane_yThe y values that are already known.
znane_xThe x values that are already known.


REGEXPP(znane_y, [znane_x], [stała], [statystyka])

Returns the coefficients for an exponential curve using multiple linear regression.

znane_yThe y values that are already known.
znane_xOne or more sets of x values corresponding to the known y values. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys.
stałaSpecifies whether the line must pass through the origin. The possible values are:
FAŁSZThe intercept is forced to be 1.
PRAWDAThe intercept is calculated normally.
If this parameter is omitted it defaults to PRAWDA.
statystykaSpecifies whether the additional statistics are returned in the rows below the coefficients. These are: the standard error values for the coefficients, the R2 coefficient, the standard error for the Y estimate, the F statistic, the degrees of freedom, the regression sum of squares and the residual sum of squares. The possible values are:
FAŁSZThe additional statistics are not returned.
PRAWDAThe additional statistics are returned.
If this parameter is omitted it defaults to FAŁSZ.


REGEXPW(znane_y, [znane_x], [nowe_x], [stała])

Returns the expected values of y for given x values for an exponential curve passing through a specified set of points.

znane_yThe y values that are already known.
znane_xThe x values that are already known. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys.
nowe_xThe new x values for which y values are required. If this parameter is omitted it defaults to the known xs.
stałaSpecifies whether the line must pass through the origin. The possible values are:
FAŁSZThe intercept is forced to be 1.
PRAWDAThe intercept is calculated normally.
If this parameter is omitted it defaults to PRAWDA.


REGLINP(znane_y, [znane_x], [stała], [statystyka])

Returns the coefficients for a straight line using multiple linear regression.

znane_yThe y values that are already known.
znane_xOne or more sets of x values corresponding to the known y values. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys.
stałaSpecifies whether the line must pass through the origin. The possible values are:
FAŁSZThe line is forced to pass through the origin.
PRAWDAThe line is not forced to pass through the origin.
If this parameter is omitted it defaults to PRAWDA.
statystykaSpecifies whether the additional statistics are returned in the rows below the coefficients. These are: the standard error values for the coefficients, the R2 coefficient, the standard error for the Y estimate, the F statistic, the degrees of freedom, the regression sum of squares and the residual sum of squares. The possible values are:
FAŁSZThe additional statistics are not returned.
PRAWDAThe additional statistics are returned.
If this parameter is omitted it defaults to FAŁSZ.


REGLINW(znane_y, [znane_x], [nowe_x], [stała])

Returns the expected values of y for given x values for a line passing through a specified set of points.

znane_yThe y values that are already known.
znane_xThe x values that are already known. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys.
nowe_xThe new x values for which y values are required. If this parameter is omitted it defaults to the known xs.
stałaSpecifies whether the line must pass through the origin. The possible values are:
FAŁSZThe line is forced to pass through the origin.
PRAWDAThe line is not forced to pass through the origin.
If this parameter is omitted it defaults to PRAWDA.


REGLINX(x, znane_y, znane_x)

Returns the expected value of y for a given x value for a line passing through a specified set of points.

xThe x value at which to evaluate the function.
znane_yThe y values that are already known.
znane_xThe x values that are already known.


ROZKŁAD.BETA(x, alfa, beta, [A], [B])

Returns the cumulative beta distribution probability.

xThe value at which you want to evaluate the function.
alfaThe alpha value.
betaThe beta value.
AThe lower limit. If this parameter is omitted it defaults to 0.
BThe upper limit. If this parameter is omitted it defaults to 1.


ROZKŁAD.BETA.ODW(prawdopodobieństwo, alfa, beta, [A], [B])

Returns the value associated with the specified cumulative beta distribution probability.

prawdopodobieństwoThe cumulative beta distribution probability for which you want the value.
alfaThe alpha value.
betaThe beta value.
AThe lower limit. If this parameter is omitted it defaults to 0.
BThe upper limit. If this parameter is omitted it defaults to 1.


ROZKŁAD.CHI(x, stopnie_swobody)

Returns the chi-squared distribution probability.

xThe value at which you want to evaluate the function.
stopnie_swobodyThe number of degrees of freedom.


ROZKŁAD.CHI.ODW(prawdopodobieństwo, stopnie_swobody)

Returns the value associated with the specified chi-squared distribution probability.

prawdopodobieństwoThe probability for which you want the value.
stopnie_swobodyThe number of degrees of freedom.


ROZKŁAD.DWUM(liczba_s, próby, prawdopodob_s, skumulowany)

Returns the binomial distribution probability.

liczba_sThe number of trials that are successful.
próbyThe total number of trials.
prawdopodob_sThe probability of a single trial being successful.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


ROZKŁAD.DWUM.PRZEC(liczba_p, liczba_s, prawdopodob_s)

Returns the negative binomial distribution probability.

liczba_pThe number of trials that fail.
liczba_sThe threshold number of trials that are successful.
prawdopodob_sThe probability of a single trial being successful.


ROZKŁAD.EXP(x, lambda, skumulowany)

Returns the exponential distribution probability.

xThe value at which you want to evaluate the function.
lambdaThe lambda value.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


ROZKŁAD.F(x, stopnie_swobody1, stopnie_swobody2)

Returns the F distribution probability.

xThe value at which you want to evaluate the function.
stopnie_swobody1The degrees of freedom of the first set.
stopnie_swobody2The degrees of freedom of the second set.


ROZKŁAD.F.ODW(ROZKŁAD.F.ODW(prawdopodobieństwo, stopnie_swobody1, stopnie_swobody2)

Returns the value associated with the specified F distribution probability.

prawdopodobieństwoThe probability for which you want the value.
stopnie_swobody1The degrees of freedom of the first set.
stopnie_swobody2The degrees of freedom of the second set.


ROZKŁAD.FISHER(x)

Returns the Fisher transformation.

xThe value at which to evaluate the function.


ROZKŁAD.FISHER.ODW(y)

Returns the inverse Fisher transformation.

yThe value at which to evaluate the function.


ROZKŁAD.GAMMA(x, alfa, beta, skumulowany)

Returns the gamma distribution probability.

xThe value at which you want to evaluate the function.
alfaThe alpha value.
betaThe beta value.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


ROZKŁAD.GAMMA.ODW(prawdopodobieństwo, alfa, beta)

Returns the value associated with the specified gamma distribution probability.

prawdopodobieństwoThe probability for which you want the value.
alfaThe alpha value.
betaThe beta value.


ROZKŁAD.HIPERGEOM(próbka_s, wielk_próbki, populacja_s, wielk_populacji)

Returns the hypergeometric distribution probability.

próbka_sThe number of sample trials that are successful.
wielk_próbkiThe total number of trials in the sample.
populacja_sThe number of population trials that are successful.
wielk_populacjiThe total number of trials in the population.


ROZKŁAD.LIN.GAMMA(x)

Returns the natural logarithm of the gamma function evaluated at x.

xThe value at which you want to evaluate the function.


ROZKŁAD.LOG(x, średnia, odchylenie_std)

Returns the cumulative lognormal distribution probability.

xThe value at which you want to evaluate the function.
średniaThe mean of the natural logarithms of the values.
odchylenie_stdThe standard deviation of the natural logarithms of the values.


ROZKŁAD.LOG.ODW(prawdopodobieństwo, średnia, odchylenie_std)

Returns the value associated with the specified cumulative lognormal distribution probability.

prawdopodobieństwoThe probability for which you want the value.
średniaThe mean of the natural logarithms of the values.
odchylenie_stdThe standard deviation of the natural logarithms of the values.


ROZKŁAD.NORMALNY(x, średnia, odchylenie_std, skumulowany)

Returns the normal distribution probability.

xThe value at which you want to evaluate the function.
średniaThe mean of the values.
odchylenie_stdThe standard deviation of the values.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


ROZKŁAD.NORMALNY.ODW(prawdopodobieństwo, średnia, odchylenie_std)

Returns the value associated with the specified cumulative normal distribution probability.

prawdopodobieństwoThe probability for which you want the value.
średniaThe mean of the values.
odchylenie_stdThe standard deviation of the values.


ROZKŁAD.NORMALNY.S(z)

Returns the cumulative standard normal distribution probability.

zThe value at which you want to evaluate the function.


ROZKŁAD.NORMALNY.S.ODW(prawdopodobieństwo)

Returns the value associated with the specified cumulative standard normal distribution probability.

prawdopodobieństwoThe probability for which you want the value.


ROZKŁAD.POISSON(x, średnia, skumulowany)

Returns the Poisson distribution probability.

xThe value at which you want to evaluate the function.
średniaThe mean of the values.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


ROZKŁAD.T(x, stopnie_swobody, ślady)

Returns the Student's T distribution probability.

xThe value at which you want to evaluate the function.
stopnie_swobodyThe degrees of freedom.
śladySpecifies the tails to include in the distribution. Should be 1 or 2.


ROZKŁAD.T.ODW(prawdopodobieństwo, stopnie_swobody)

Returns the value associated with the specified Student's T distribution probability.

prawdopodobieństwoThe probability for which you want the value.
stopnie_swobodyThe degrees of freedom.


ROZKŁAD.WEIBULL(x, alfa, beta, skumulowany)

Returns the Weibull distribution probability.

xThe value at which you want to evaluate the function.
alfaThe alpha value.
betaThe beta value.
skumulowanySpecifies whether to return the cumulative probability or not. The possible values are:
FAŁSZReturn the value of the function.
PRAWDAReturn the integral of the function.


SKOŚNOŚĆ(liczba1, [liczba2, ...])

Returns the skewness of a set of numbers.

liczba1, ...The numbers of which you want the skewness.


TEST.CHI(zakres_bieżący, zakres_przewidywany)

Returns the probability result of the chi-squared test.

zakres_bieżącyAn array or reference to cells containing the empirical results.
zakres_przewidywanyAn array or reference to cells containing the theoretical results.


TEST.F(tablica1, tablica1)

Returns the probability result of the F test.

tablica1The first range to be compared.
tablica1The second range to be compared.


TEST.T(tablica1, tablica2, ślady, typ)

Returns the probability result of the Student's T test.

tablica1The first range to be compared.
tablica2The second range to be compared.
śladySpecifies the tails to include in the distribution. Should be 1 or 2.
typSpecifies which type of test is required. The possible values are:
1Paired.
2Equal variance.
3Unequal variance.


TEST.Z(tablica, x, [sigma])

Returns the probability result of the z test.

tablicaAn array or reference to cells containing the data against which x is to be tested.
xThe value to be tested.
sigmaThe population standard deviation. If this parameter is omitted it defaults to the sample standard deviation of the data.


UFNOŚĆ(alfa, odchylenie_std, rozmiar)

Returns the confidence interval for a population mean.

alfaThe significance level.
odchylenie_stdThe population standard deviation.
rozmiarThe sample size.


WARIANCJA(liczba1, [liczba2, ...])

Returns the variance (based on a population sample) of a set of numbers.

liczba1, ...The numbers of which you want the variance.


WARIANCJA.A(wartość1, [wartość2, ...])

Returns the variance (based on a population sample) of a set of values.

wartość1, ...The values of which you want the variance.


WARIANCJA.POPUL(liczba1, [liczba2, ...])

Returns the variance (based on the entire population) of a set of numbers.

liczba1, ...The numbers of which you want the variance.


WARIANCJA.POPUL.A(wartość1, [wartość2, ...])

Returns the variance (based on the entire population) of a set of values.

wartość1, ...The values of which you want the variance.


WSP.KORELACJI(tablica1, tablica2)

Returns the correlation coefficient of two ranges.

tablica1The first range to be compared.
tablica2The second range to be compared.


WYST.NAJCZĘŚCIEJ(liczba1, [liczba2, ...])

Returns the mode of a set of numbers.

liczba1, ...The numbers of which you want the mode.


ŚREDNIA(liczba1, [liczba2, ...])

Returns the average of a set of numbers.

liczba1, ...The numbers of which you want the average.


ŚREDNIA.A(wartość1, [wartość2, ...])

Returns the average of a set of values.

wartość1, ...The values of which you want the average.


ŚREDNIA.GEOMETRYCZNA(liczba1, [liczba2, ...])

Returns the geometric mean of a set of numbers.

liczba1, ...The numbers of which you want the geometric mean.


ŚREDNIA.HARMONICZNA(liczba1, [liczba2, ...])

Returns the harmonic mean of a set of numbers.

liczba1, ...The numbers of which you want the harmonic mean.


ŚREDNIA.WEWN(tablica, tablica)

Returns the mean of a set of numbers with the extreme values removed.

tablicaAn array or reference to cells containing the numbers.
tablicaThe percentage of the numbers to exclude from the calculation.