Статистические functions
[ ] indicates optional parameters
FРАСП(x, степени_свободы1, степени_свободы2)FРАСП(x, степени_свободы1, степени_свободы2)
Returns the F distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы1 | The degrees of freedom of the first set. |
| степени_свободы2 | The degrees of freedom of the second set. |
FРАСПОБР(вероятность, степени_свободы1, степени_свободы2)
Returns the value associated with the specified F distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы1 | The degrees of freedom of the first set. |
| степени_свободы2 | The degrees of freedom of the second set. |
Returns the probability result of the z test.
| массив | An array or reference to cells containing the data against which x is to be tested. |
| x | The value to be tested. |
| сигма | The population standard deviation. If this parameter is omitted it defaults to the sample standard deviation of the data. |
БЕТАОБР(вероятность, альфа, бета, [А], [B])
Returns the value associated with the specified cumulative beta distribution probability.
| вероятность | The cumulative beta distribution probability for which you want the value. |
| альфа | The alpha value. |
| бета | The beta value. |
| А | 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. |
БЕТАРАСП(x, альфа, бета, [А], [B])
Returns the cumulative beta distribution probability.
| x | The value at which you want to evaluate the function. |
| альфа | The alpha value. |
| бета | The beta value. |
| А | 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. |
БИНОМРАСП(число_s, испытания, вероятность_s, интегральный)
Returns the binomial distribution probability.
| число_s | The number of trials that are successful. | ||||
| испытания | The total number of trials. | ||||
| вероятность_s | The probability of a single trial being successful. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ВЕЙБУЛЛ(x, альфа, бета, интегральный)
Returns the Weibull distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| альфа | The alpha value. | ||||
| бета | The beta value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ВЕРОЯТНОСТЬ(x_диапазон, диапазон_вероятн, нижний_предел, [верхний_пред])
Returns the probability that numbers in a set are between the specified limits.
| x_диапазон | An array or reference to cells containing the numbers. |
| диапазон_вероятн | An array or reference to cells containing the probabilities associated with each number. These values must add up to 1. |
| нижний_предел | The lower limit of the test. |
| верхний_пред | The upper limit of the test. If this value is omitted it defaults to the value specified for the lower limit. |
Returns the natural logarithm of the gamma function evaluated at x.
| x | The value at which you want to evaluate the function. |
ГАММАОБР(вероятность, альфа, бета)
Returns the value associated with the specified gamma distribution probability.
| вероятность | The probability for which you want the value. |
| альфа | The alpha value. |
| бета | The beta value. |
ГАММАРАСП(x, альфа, бета, интегральный)
Returns the gamma distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| альфа | The alpha value. | ||||
| бета | The beta value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ГИПЕРГЕОМЕТ(пример_s, размер_выборки, ген_совокупность_s, размер_ген_совокупности)
Returns the hypergeometric distribution probability.
| пример_s | The number of sample trials that are successful. |
| размер_выборки | The total number of trials in the sample. |
| ген_совокупность_s | The number of population trials that are successful. |
| размер_ген_совокупности | The total number of trials in the population. |
Returns the variance (based on a population sample) of a set of numbers.
| число1, ... | The numbers of which you want the variance. |
ДИСПА(значение1, [значение2, ...])
Returns the variance (based on a population sample) of a set of values.
| значение1, ... | The values of which you want the variance. |
Returns the variance (based on the entire population) of a set of numbers.
| число1, ... | The numbers of which you want the variance. |
ДИСПРА(значение1, [значение2, ...])
Returns the variance (based on the entire population) of a set of values.
| значение1, ... | The values of which you want the variance. |
ДОВЕРИТ(альфа, стандартное_откл, размер)
Returns the confidence interval for a population mean.
| альфа | The significance level. |
| стандартное_откл | The population standard deviation. |
| размер | The sample size. |
КВАДРОТКЛ(число1, [число2, ...])
Returns the sum of the squares of the differences of a set of numbers from their mean.
| число1, ... | The numbers of which you want the squared deviations. |
Returns the specified quartile of a set of numbers.
| массив | An array or reference to cells containing the numbers. | ||||||||||
| значение | Specifies which quartile to return. The possible values are: | ||||||||||
|
КВПИРСОН(известные_y, известные_x)
Returns the square of the Pearson correlation coefficient.
| известные_y | The first range to be compared. |
| известные_x | The second range to be compared. |
Returns the covariance of two ranges.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
Returns the correlation coefficient of two ranges.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
КРИТБИНОМ(испытания, вероятность_s, альфа)
Returns the value at which the cumulative binomial distribution is greater than or equal to alpha.
| испытания | The total number of trials. |
| вероятность_s | The probability of a single trial being successful. |
| альфа | The value at which you want to evaluate the function. |
ЛГРФПРИБЛ(изв_знач_y, [изв_знач_x], [константа], [стат])
Returns the coefficients for an exponential curve using multiple linear regression.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_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. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| стат | 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 ЛОЖЬ. |
ЛИНЕЙН(изв_знач_y, [изв_знач_x], [константа], [стат])
Returns the coefficients for a straight line using multiple linear regression.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_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. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| стат | 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 ЛОЖЬ. |
ЛОГНОРМОБР(вероятность, среднее, стандартное_откл)
Returns the value associated with the specified cumulative lognormal distribution probability.
| вероятность | The probability for which you want the value. |
| среднее | The mean of the natural logarithms of the values. |
| стандартное_откл | The standard deviation of the natural logarithms of the values. |
ЛОГНОРМРАСП(x, среднее, стандартное_откл)
Returns the cumulative lognormal distribution probability.
| x | The value at which you want to evaluate the function. |
| среднее | The mean of the natural logarithms of the values. |
| стандартное_откл | The standard deviation of the natural logarithms of the values. |
Returns the maximum of a set of numbers.
| число1, ... | The numbers of which you want the maximum. |
МАКСА(значение1, [значение2, ...])
Returns the maximum of a set of values.
| значение1, ... | The values of which you want the maximum. |
МЕДИАНА(число1, [число2, ...])
Returns the median of a set of numbers.
| число1, ... | The numbers of which you want the median. |
Returns the minimum of a set of numbers.
| число1, ... | The numbers of which you want the minimum. |
МИНА(значение1, [значение2, ...])
Returns the minimum of a set of values.
| значение1, ... | The values of which you want the minimum. |
Returns the mode of a set of numbers.
| число1, ... | The numbers of which you want the mode. |
Returns the kth largest number in a set of numbers.
| массив | An array or reference to cells containing numbers of which you want the kth largest. |
| k | The rank of the number that you want. |
Returns the kth smallest number in a set of numbers.
| массив | An array or reference to cells containing numbers of which you want the kth smallest. |
| k | The rank of the number that you want. |
НАКЛОН(изв_знач_y, изв_знач_x)
Returns the slope of a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
НОРМАЛИЗАЦИЯ(x, среднее, стандартное_откл)
Returns the standardized value of x for the specified mean and standard deviation.
| x | The value that you want to standardize. |
| среднее | The mean of the values. |
| стандартное_откл | The standard deviation of the values. |
НОРМОБР(вероятность, среднее, стандартное_откл)
Returns the value associated with the specified cumulative normal distribution probability.
| вероятность | The probability for which you want the value. |
| среднее | The mean of the values. |
| стандартное_откл | The standard deviation of the values. |
НОРМРАСП(x, среднее, стандартное_откл, интегральный)
Returns the normal distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| среднее | The mean of the values. | ||||
| стандартное_откл | The standard deviation of the values. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
Returns the value associated with the specified cumulative standard normal distribution probability.
| вероятность | The probability for which you want the value. |
Returns the cumulative standard normal distribution probability.
| z | The value at which you want to evaluate the function. |
ОТРБИНОМРАСП(число_f, число_s, вероятность_s)
Returns the negative binomial distribution probability.
| число_f | The number of trials that fail. |
| число_s | The threshold number of trials that are successful. |
| вероятность_s | The probability of a single trial being successful. |
ОТРЕЗОК(изв_знач_y, изв_знач_x)
Returns the expected value of y when x is zero for a line passing though a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
ПЕРЕСТ(число, выбранное_число)
Returns the number of permutations in which a number of items can be chosen from a total number.
| число | The total number of items. |
| выбранное_число | The number of items chosen. |
Returns the kth percentile of a set of values.
| массив | An array or reference to cells containing the values. |
| k | The percentile value. |
Returns the Pearson correlation coefficient.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
ПРЕДСКАЗ(x, изв_знач_y, изв_знач_x)
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. |
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
ПРОЦЕНТРАНГ(массив, x, [значимость])
Returns the percentile of a value in a set of values.
| массив | An array or reference to cells containing the values. |
| x | The value of which you want the percentile. |
| значимость | The number of decimal places required in the result. If this parameter is omitted it defaults to 3. |
ПУАССОН(x, среднее, интегральный)
Returns the Poisson distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| среднее | The mean of the values. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
РАНГ(число, ссылка, [порядок])
Returns the rank of a number in a set of numbers.
| число | The number of which you want the rank. | ||||
| ссылка | An array or reference to cells containing the values. | ||||
| порядок | 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. |
РОСТ(изв_знач_y, [изв_знач_x], [нов_знач_x], [константа])
Returns the expected values of y for given x values for an exponential curve passing through a specified set of points.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_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. | ||||
| нов_знач_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
Returns the skewness of a set of numbers.
| число1, ... | The numbers of which you want the skewness. |
Returns the harmonic mean of a set of numbers.
| число1, ... | The numbers of which you want the harmonic mean. |
Returns the geometric mean of a set of numbers.
| число1, ... | The numbers of which you want the geometric mean. |
Returns the average of a set of numbers.
| число1, ... | The numbers of which you want the average. |
СРЗНАЧА(значение1, [значение2, ...])
Returns the average of a set of values.
| значение1, ... | The values of which you want the average. |
Returns the average of the differences of a set of numbers from their mean.
| число1, ... | The numbers of which you want the average deviation. |
СТАНДОТКЛОН(число1, [число2, ...])
Returns the standard deviation (based on a population sample) of a set of numbers.
| число1, ... | The numbers of which you want the standard deviation. |
СТАНДОТКЛОНА(значение1, [значение2, ...])
Returns the standard deviation (based on a population sample) of a set of values.
| значение1, ... | The values of which you want the standard deviation. |
СТАНДОТКЛОНП(число1, [число2, ...])
Returns the standard deviation (based on the entire population) of a set of numbers.
| число1, ... | The numbers of which you want the standard deviation. |
СТАНДОТКЛОНПА(значение1, [значение2, ...])
Returns the standard deviation (based on the entire population) of a set of values.
| значение1, ... | The values of which you want the standard deviation. |
СТОШYX(изв_знач_y, изв_знач_x)
Returns the standard error of the y values of a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
СТЬЮДРАСП(x, степени_свободы, хвосты)
Returns the Student's T distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы | The degrees of freedom. |
| хвосты | Specifies the tails to include in the distribution. Should be 1 or 2. |
СТЬЮДРАСПОБР(вероятность, степени_свободы)
Returns the value associated with the specified Student's T distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы | The degrees of freedom. |
СЧЁТ(значение1, [значение2, ...])
Returns the count of numbers in a list.
| значение1, ... | The items whose numbers are to be counted. |
СЧЁТЗ(значение1, [значение2, ...])
Returns the count of values in a list.
| значение1, ... | The items whose values are to be counted. |
ТЕНДЕНЦИЯ(изв_знач_y, [изв_знач_x], [нов_знач_x], [константа])
Returns the expected values of y for given x values for a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_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. | ||||
| нов_знач_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ТТЕСТ(массив1, массив2, хвосты, тип)
Returns the probability result of the Student's T test.
| массив1 | The first range to be compared. | ||||||
| массив2 | The second range to be compared. | ||||||
| хвосты | Specifies the tails to include in the distribution. Should be 1 or 2. | ||||||
| тип | Specifies which type of test is required. The possible values are: | ||||||
|
Returns the mean of a set of numbers with the extreme values removed.
| массив | An array or reference to cells containing the numbers. |
| процент | The percentage of the numbers to exclude from the calculation. |
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. |
Returns the probability result of the F test.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
ХИ2ОБР(вероятность, степени_свободы)
Returns the value associated with the specified chi-squared distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы | The number of degrees of freedom. |
Returns the chi-squared distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы | The number of degrees of freedom. |
ХИ2ТЕСТ(фактический_интервал, ожидаемый_интервал)
Returns the probability result of the chi-squared test.
| фактический_интервал | An array or reference to cells containing the empirical results. |
| ожидаемый_интервал | An array or reference to cells containing the theoretical results. |
ЧАСТОТА(массив_данных, двоичный_массив)
Returns the counts of items in specified numeric categories.
| массив_данных | An array or reference to a range of cells containing values to be counted. |
| двоичный_массив | An array or reference to a range of cells containing the upper limits for each category. |
ЭКСПРАСП(x, лямбда, интегральный)
Returns the exponential distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| лямбда | The lambda value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ЭКСЦЕСС(число1, [число2, ...])
Returns the kurtosis of a set of numbers.
| число1, ... | The numbers of which you want the kurtosis. |