Funkcji statystyczne
[ ] indicates optional parameters
CZĘSTOŚĆ(tablica_dane, tablica_przedziały)CZĘSTOŚĆ(tablica_dane, tablica_przedziały)
Returns the counts of items in specified numeric categories.
tablica_dane | An array or reference to a range of cells containing values to be counted. |
tablica_przedziały | An 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.
tablica1 | The first range to be compared. |
tablica2 | The 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. |
Returns the specified quartile of a set of numbers.
tablica | An array or reference to cells containing the numbers. | ||||||||||
kwartyl | Specifies which quartile to return. The possible values are: | ||||||||||
|
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. |
Returns the kth largest number in a set of numbers.
tablica | An array or reference to cells containing numbers of which you want the kth largest. |
k | The 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. |
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. |
Returns the kth smallest number in a set of numbers.
tablica | An array or reference to cells containing numbers of which you want the kth smallest. |
k | The rank of the number that you want. |
Returns the slope of a line passing through a specified set of points.
znane_y | The y values that are already known. |
znane_x | The x values that are already known. |
NORMALIZUJ(x, średnia, odchylenie_std)
Returns the standardized value of x for the specified mean and standard deviation.
x | The value that you want to standardize. |
średnia | The mean of the values. |
odchylenie_std | The 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. |
Returns the expected value of y when x is zero for a line passing though a specified set of points.
znane_y | The y values that are already known. |
znane_x | The x values that are already known. |
Returns the Pearson correlation coefficient.
tablica1 | The first range to be compared. |
tablica2 | The second range to be compared. |
Returns the kth percentile of a set of values.
tablica | An array or reference to cells containing the values. |
k | The percentile value. |
PERMUTACJE(liczba, liczba_wybrana)
Returns the number of permutations in which a number of items can be chosen from a total number.
liczba | The total number of items. |
liczba_wybrana | The number of items chosen. |
Returns the rank of a number in a set of numbers.
liczba | The number of which you want the rank. | ||||
lista | An array or reference to cells containing the values. | ||||
lp | Specifies whether the list is treated as being in ascending or descending order of value. The possible values are: | ||||
| |||||
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_x | An array or reference to cells containing the numbers. |
zakres_prawdop | An array or reference to cells containing the probabilities associated with each number. These values must add up to 1. |
dolna_granica | The lower limit of the test. |
górna_granica | The 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.
tablica | An array or reference to cells containing the values. |
x | The 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óby | The total number of trials. |
prawdopodob_s | The probability of a single trial being successful. |
alfa | The value at which you want to evaluate the function. |
Returns the square of the Pearson correlation coefficient.
znane_y | The first range to be compared. |
znane_x | The second range to be compared. |
Returns the standard error of the y values of a line passing through a specified set of points.
znane_y | The y values that are already known. |
znane_x | The 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_y | The y values that are already known. | ||||
znane_x | One 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ła | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to PRAWDA. | |||||
statystyka | Specifies 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: | ||||
| |||||
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_y | The y values that are already known. | ||||
znane_x | The 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_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
stała | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
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_y | The y values that are already known. | ||||
znane_x | One 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ła | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to PRAWDA. | |||||
statystyka | Specifies 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: | ||||
| |||||
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_y | The y values that are already known. | ||||
znane_x | The 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_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
stała | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to PRAWDA. |
Returns the expected value of y for a given x value for a line passing through a specified set of points.
x | The x value at which to evaluate the function. |
znane_y | The y values that are already known. |
znane_x | The x values that are already known. |
ROZKŁAD.BETA(x, alfa, beta, [A], [B])
Returns the cumulative beta distribution probability.
x | The value at which you want to evaluate the function. |
alfa | The alpha value. |
beta | The beta value. |
A | The lower limit. If this parameter is omitted it defaults to 0. |
B | The 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ństwo | The cumulative beta distribution probability for which you want the value. |
alfa | The alpha value. |
beta | The beta value. |
A | The lower limit. If this parameter is omitted it defaults to 0. |
B | The upper limit. If this parameter is omitted it defaults to 1. |
ROZKŁAD.CHI(x, stopnie_swobody)
Returns the chi-squared distribution probability.
x | The value at which you want to evaluate the function. |
stopnie_swobody | The 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ństwo | The probability for which you want the value. |
stopnie_swobody | The number of degrees of freedom. |
ROZKŁAD.DWUM(liczba_s, próby, prawdopodob_s, skumulowany)
Returns the binomial distribution probability.
liczba_s | The number of trials that are successful. | ||||
próby | The total number of trials. | ||||
prawdopodob_s | The probability of a single trial being successful. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ROZKŁAD.DWUM.PRZEC(liczba_p, liczba_s, prawdopodob_s)
Returns the negative binomial distribution probability.
liczba_p | The number of trials that fail. |
liczba_s | The threshold number of trials that are successful. |
prawdopodob_s | The probability of a single trial being successful. |
ROZKŁAD.EXP(x, lambda, skumulowany)
Returns the exponential distribution probability.
x | The value at which you want to evaluate the function. | ||||
lambda | The lambda value. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ROZKŁAD.F(x, stopnie_swobody1, stopnie_swobody2)
Returns the F distribution probability.
x | The value at which you want to evaluate the function. |
stopnie_swobody1 | The degrees of freedom of the first set. |
stopnie_swobody2 | The 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ństwo | The probability for which you want the value. |
stopnie_swobody1 | The degrees of freedom of the first set. |
stopnie_swobody2 | The degrees of freedom of the second set. |
Returns the Fisher transformation.
x | The value at which to evaluate the function. |
Returns the inverse Fisher transformation.
y | The value at which to evaluate the function. |
ROZKŁAD.GAMMA(x, alfa, beta, skumulowany)
Returns the gamma distribution probability.
x | The value at which you want to evaluate the function. | ||||
alfa | The alpha value. | ||||
beta | The beta value. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ROZKŁAD.GAMMA.ODW(prawdopodobieństwo, alfa, beta)
Returns the value associated with the specified gamma distribution probability.
prawdopodobieństwo | The probability for which you want the value. |
alfa | The alpha value. |
beta | The beta value. |
ROZKŁAD.HIPERGEOM(próbka_s, wielk_próbki, populacja_s, wielk_populacji)
Returns the hypergeometric distribution probability.
próbka_s | The number of sample trials that are successful. |
wielk_próbki | The total number of trials in the sample. |
populacja_s | The number of population trials that are successful. |
wielk_populacji | The total number of trials in the population. |
Returns the natural logarithm of the gamma function evaluated at x.
x | The value at which you want to evaluate the function. |
ROZKŁAD.LOG(x, średnia, odchylenie_std)
Returns the cumulative lognormal distribution probability.
x | The value at which you want to evaluate the function. |
średnia | The mean of the natural logarithms of the values. |
odchylenie_std | The 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ństwo | The probability for which you want the value. |
średnia | The mean of the natural logarithms of the values. |
odchylenie_std | The standard deviation of the natural logarithms of the values. |
ROZKŁAD.NORMALNY(x, średnia, odchylenie_std, skumulowany)
Returns the normal distribution probability.
x | The value at which you want to evaluate the function. | ||||
średnia | The mean of the values. | ||||
odchylenie_std | The standard deviation of the values. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ROZKŁAD.NORMALNY.ODW(prawdopodobieństwo, średnia, odchylenie_std)
Returns the value associated with the specified cumulative normal distribution probability.
prawdopodobieństwo | The probability for which you want the value. |
średnia | The mean of the values. |
odchylenie_std | The standard deviation of the values. |
Returns the cumulative standard normal distribution probability.
z | The 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ństwo | The probability for which you want the value. |
ROZKŁAD.POISSON(x, średnia, skumulowany)
Returns the Poisson distribution probability.
x | The value at which you want to evaluate the function. | ||||
średnia | The mean of the values. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ROZKŁAD.T(x, stopnie_swobody, ślady)
Returns the Student's T distribution probability.
x | The value at which you want to evaluate the function. |
stopnie_swobody | The degrees of freedom. |
ślady | Specifies 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ństwo | The probability for which you want the value. |
stopnie_swobody | The degrees of freedom. |
ROZKŁAD.WEIBULL(x, alfa, beta, skumulowany)
Returns the Weibull distribution probability.
x | The value at which you want to evaluate the function. | ||||
alfa | The alpha value. | ||||
beta | The beta value. | ||||
skumulowany | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
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żący | An array or reference to cells containing the empirical results. |
zakres_przewidywany | An array or reference to cells containing the theoretical results. |
Returns the probability result of the F test.
tablica1 | The first range to be compared. |
tablica1 | The second range to be compared. |
TEST.T(tablica1, tablica2, ślady, typ)
Returns the probability result of the Student's T test.
tablica1 | The first range to be compared. | ||||||
tablica2 | The second range to be compared. | ||||||
ślady | Specifies the tails to include in the distribution. Should be 1 or 2. | ||||||
typ | Specifies which type of test is required. The possible values are: | ||||||
|
Returns the probability result of the z test.
tablica | An array or reference to cells containing the data against which x is to be tested. |
x | The value to be tested. |
sigma | The 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.
alfa | The significance level. |
odchylenie_std | The population standard deviation. |
rozmiar | The 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.
tablica1 | The first range to be compared. |
tablica2 | The 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.
tablica | An array or reference to cells containing the numbers. |
tablica | The percentage of the numbers to exclude from the calculation. |