Difference between revisions of "Documentation/SL/How Tos/Calc: Statistične funkcije"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
(→Seznam statističnih funkcij za Calc) |
|||
Line 8: | Line 8: | ||
|colspan="2"|'''<big>Measures of Central Tendency</big>''' | |colspan="2"|'''<big>Measures of Central Tendency</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: AVEDEV | + | |[[Documentation/SL/How_Tos/Calc: funkcija AVEDEV|'''AVEDEV''']] |
|Returns the average of the absolute deviations of values from their mean. | |Returns the average of the absolute deviations of values from their mean. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: AVERAGE | + | |[[Documentation/SL/How_Tos/Calc: funkcija AVERAGE|'''AVERAGE''']] |
|Returns the average of the arguments, ignoring text. | |Returns the average of the arguments, ignoring text. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: AVERAGEA | + | |[[Documentation/SL/How_Tos/Calc: funkcija AVERAGEA|'''AVERAGEA''']] |
|Returns the average of the arguments, including text (valued as 0). | |Returns the average of the arguments, including text (valued as 0). | ||
|-valign="top" | |-valign="top" | ||
Line 23: | Line 23: | ||
|Prešteje ne prazne vnose v seznamu argumentov. | |Prešteje ne prazne vnose v seznamu argumentov. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GEOMEAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija GEOMEAN|'''GEOMEAN''']] |
|Returns the geometric mean of the arguments. | |Returns the geometric mean of the arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: HARMEAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija HARMEAN|'''HARMEAN''']] |
|Returns the harmonic mean of the arguments. | |Returns the harmonic mean of the arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MEDIAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija MEDIAN|'''MEDIAN''']] |
|Returns the median of a set of numbers. | |Returns the median of a set of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MODE | + | |[[Documentation/SL/How_Tos/Calc: funkcija MODE|'''MODE''']] |
|Returns the most common value in a set of numbers. | |Returns the most common value in a set of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TRIMMEAN | + | |[[Documentation/SL/How_Tos/Calc: funkcija TRIMMEAN|'''TRIMMEAN''']] |
|Returns the mean of a set of numbers, ignoring a proportion of high and low values. | |Returns the mean of a set of numbers, ignoring a proportion of high and low values. | ||
Line 41: | Line 41: | ||
|colspan="2"|'''<big>Measures of dispersion / spread</big>''' | |colspan="2"|'''<big>Measures of dispersion / spread</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: DEVSQ | + | |[[Documentation/SL/How_Tos/Calc: funkcija DEVSQ|'''DEVSQ''']] |
|Returns the sum of squares of deviations from the mean. | |Returns the sum of squares of deviations from the mean. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: KURT | + | |[[Documentation/SL/How_Tos/Calc: funkcija KURT|'''KURT''']] |
|Returns the kurtosis, a measure of how peaked or flat a distribution is. | |Returns the kurtosis, a measure of how peaked or flat a distribution is. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SKEW | + | |[[Documentation/SL/How_Tos/Calc: funkcija SKEW|'''SKEW''']] |
|Returns a measure of how skewed a distribution is. | |Returns a measure of how skewed a distribution is. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEV | + | |[[Documentation/SL/How_Tos/Calc: funkcija STDEV|'''STDEV''']] |
|Returns the sample standard deviation. | |Returns the sample standard deviation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVA | + | |[[Documentation/SL/How_Tos/Calc: funkcija STDEVA|'''STDEVA''']] |
|Returns the sample standard deviation (allowing text and logical values). | |Returns the sample standard deviation (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVP | + | |[[Documentation/SL/How_Tos/Calc: funkcija STDEVP|'''STDEVP''']] |
|Returns the population standard deviation. | |Returns the population standard deviation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVPA | + | |[[Documentation/SL/How_Tos/Calc: funkcija STDEVPA|'''STDEVPA''']] |
|Returns the population standard deviation (allowing text and logical values). | |Returns the population standard deviation (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VAR | + | |[[Documentation/SL/How_Tos/Calc: funkcija VAR|'''VAR''']] |
|Returns the sample variance. | |Returns the sample variance. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARA | + | |[[Documentation/SL/How_Tos/Calc: funkcija VARA|'''VARA''']] |
|Returns the sample variance (allowing text and logical values). | |Returns the sample variance (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARP | + | |[[Documentation/SL/How_Tos/Calc: funkcija VARP|'''VARP''']] |
|Returns the population variance. | |Returns the population variance. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARPA | + | |[[Documentation/SL/How_Tos/Calc: funkcija VARPA|'''VARPA''']] |
|Returns the population variance (allowing text and logical values). | |Returns the population variance (allowing text and logical values). | ||
Line 77: | Line 77: | ||
|colspan="2"|'''<big>Probability and statistics</big>''' | |colspan="2"|'''<big>Probability and statistics</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: B | + | |[[Documentation/SL/How_Tos/Calc: funkcija B|'''B''']] |
|Calculates probabilities for a binomial distribution. | |Calculates probabilities for a binomial distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BETADIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija BETADIST|'''BETADIST''']] |
− | |Calculates the cumulative distribution | + | |Calculates the cumulative distribution of a beta distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BETAINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija BETAINV|'''BETAINV''']] |
− | |Calculates the inverse of the BETADIST | + | |Calculates the inverse of the BETADIST. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BINOMDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija BINOMDIST|'''BINOMDIST''']] |
|Calculates probabilities for a binomial distribution. | |Calculates probabilities for a binomial distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CHIDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija CHIDIST|'''CHIDIST''']] |
|Calculates values for a χ<sup>2</sup>-distribution. | |Calculates values for a χ<sup>2</sup>-distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CHIINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija CHIINV|'''CHIINV''']] |
− | |Calculates the inverse of the CHIDIST | + | |Calculates the inverse of the CHIDIST. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CHITEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija CHITEST|'''CHITEST''']] |
|Returns a measure of χ<sup>2</sup> 'goodness of fit'. | |Returns a measure of χ<sup>2</sup> 'goodness of fit'. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CONFIDENCE | + | |[[Documentation/SL/How_Tos/Calc: funkcija CONFIDENCE|'''CONFIDENCE''']] |
|Returns a confidence interval. | |Returns a confidence interval. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CRITBINOM | + | |[[Documentation/SL/How_Tos/Calc: funkcija CRITBINOM|'''CRITBINOM''']] |
|Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | |Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: EXPONDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija EXPONDIST|'''EXPONDIST''']] |
|Calculates values for an exponential distribution. | |Calculates values for an exponential distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija FINV|'''FINV''']] |
|Returns the inverse of the F probability distribution. | |Returns the inverse of the F probability distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FISHER | + | |[[Documentation/SL/How_Tos/Calc: funkcija FISHER|'''FISHER''']] |
|Calculates values for the Fisher transformation. | |Calculates values for the Fisher transformation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FISHERINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija FISHERINV|'''FISHERINV''']] |
|Calculates the inverse of the FISHER transformation. | |Calculates the inverse of the FISHER transformation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija FDIST|'''FDIST''']] |
|Calculates the values of an F distribution. | |Calculates the values of an F distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FTEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija FTEST|'''FTEST''']] |
|Returns the result of an F test. | |Returns the result of an F test. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GAMMAINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija GAMMAINV|'''GAMMAINV''']] |
− | |Calculates the inverse of the cumulative GAMMADIST | + | |Calculates the inverse of the cumulative GAMMADIST. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GAMMALN | + | |[[Documentation/SL/How_Tos/Calc: funkcija GAMMALN|'''GAMMALN''']] |
− | |Returns the natural logarithm of the gamma | + | |Returns the natural logarithm of the gamma. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GAMMADIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija GAMMADIST|'''GAMMADIST''']] |
|Calculates values for a gamma distribution. | |Calculates values for a gamma distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GAUSS | + | |[[Documentation/SL/How_Tos/Calc: funkcija GAUSS|'''GAUSS''']] |
|Returns the standard normal cumulative distribution. | |Returns the standard normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: HYPGEOMDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija HYPGEOMDIST|'''HYPGEOMDIST''']] |
|Calculates values for a hypergeometric distribution. | |Calculates values for a hypergeometric distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LOGINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija LOGINV|'''LOGINV''']] |
|Returns the inverse of the lognormal distribution. | |Returns the inverse of the lognormal distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LOGNORMDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija LOGNORMDIST|'''LOGNORMDIST''']] |
|Returns the cumulative lognormal distribution. | |Returns the cumulative lognormal distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NEGBINOMDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija NEGBINOMDIST|'''NEGBINOMDIST''']] |
|Calculates probabilities for a negative binomial distribution. | |Calculates probabilities for a negative binomial distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NORMINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija NORMINV|'''NORMINV''']] |
|Returns the inverse of the normal cumulative distribution. | |Returns the inverse of the normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NORMDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija NORMDIST|'''NORMDIST''']] |
|Calculates values for a normal distribution. | |Calculates values for a normal distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NORMSINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija NORMSINV|'''NORMSINV''']] |
|Returns the inverse of the standard normal cumulative distribution. | |Returns the inverse of the standard normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NORMSDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija NORMSDIST|'''NORMSDIST''']] |
|Calculates values for the standard normal cumulative distribution. | |Calculates values for the standard normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERMUT | + | |[[Documentation/SL/How_Tos/Calc: funkcija PERMUT|'''PERMUT''']] |
|Returns the number of permutations for a given number of objects. | |Returns the number of permutations for a given number of objects. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERMUTATIONA | + | |[[Documentation/SL/How_Tos/Calc: funkcija PERMUTATIONA|'''PERMUTATIONA''']] |
|Returns the number of permutations for a given number of objects (repetition allowed). | |Returns the number of permutations for a given number of objects (repetition allowed). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PHI | + | |[[Documentation/SL/How_Tos/Calc: funkcija PHI|'''PHI''']] |
|Calculates values for the standard normal probability distribution. | |Calculates values for the standard normal probability distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: POISSON | + | |[[Documentation/SL/How_Tos/Calc: funkcija POISSON|'''POISSON''']] |
|Calculates values for a Poisson distribution. | |Calculates values for a Poisson distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PROB | + | |[[Documentation/SL/How_Tos/Calc: funkcija PROB|'''PROB''']] |
|Returns a result from a list of probabilities. | |Returns a result from a list of probabilities. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STANDARDIZE | + | |[[Documentation/SL/How_Tos/Calc: funkcija STANDARDIZE|'''STANDARDIZE''']] |
|Converts a random variable to a normalized value. | |Converts a random variable to a normalized value. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TDIST | + | |[[Documentation/SL/How_Tos/Calc: funkcija TDIST|'''TDIST''']] |
|Returns the t-distribution. | |Returns the t-distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TINV | + | |[[Documentation/SL/How_Tos/Calc: funkcija TINV|'''TINV''']] |
|Returns the inverse of the t-distribution. | |Returns the inverse of the t-distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TTEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija TTEST|'''TTEST''']] |
|Returns the probability associated with a Student's t-Test. | |Returns the probability associated with a Student's t-Test. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: WEIBULL | + | |[[Documentation/SL/How_Tos/Calc: funkcija WEIBULL|'''WEIBULL''']] |
|Returns the values of the Weibull distribution. | |Returns the values of the Weibull distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ZTEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija ZTEST|'''ZTEST''']] |
|Returns the two-tailed P value of a z test with standard distribution. | |Returns the two-tailed P value of a z test with standard distribution. | ||
Line 194: | Line 194: | ||
|colspan="2"|'''<big>Correlation and line fitting</big>''' | |colspan="2"|'''<big>Correlation and line fitting</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CORREL | + | |[[Documentation/SL/How_Tos/Calc: funkcija CORREL|'''CORREL''']] |
|Returns the correlation coefficient between two data sets. | |Returns the correlation coefficient between two data sets. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COVAR | + | |[[Documentation/SL/How_Tos/Calc: funkcija COVAR|'''COVAR''']] |
|Returns the covariance of the product of paired deviations. | |Returns the covariance of the product of paired deviations. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FORECAST | + | |[[Documentation/SL/How_Tos/Calc: funkcija FORECAST|'''FORECAST''']] |
|Extrapolates future values based on existing x and y values. | |Extrapolates future values based on existing x and y values. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: INTERCEPT | + | |[[Documentation/SL/How_Tos/Calc: funkcija INTERCEPT|'''INTERCEPT''']] |
|Calculates the point at which a line will intersect the y-values by using known x-values and y-values. | |Calculates the point at which a line will intersect the y-values by using known x-values and y-values. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PEARSON | + | |[[Documentation/SL/How_Tos/Calc: funkcija PEARSON|'''PEARSON''']] |
|Returns the Pearson product moment correlation coefficient r. | |Returns the Pearson product moment correlation coefficient r. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: RSQ | + | |[[Documentation/SL/How_Tos/Calc: funkcija RSQ|'''RSQ''']] |
|Returns the square of the Pearson correlation coefficient based on the given values. | |Returns the square of the Pearson correlation coefficient based on the given values. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SLOPE | + | |[[Documentation/SL/How_Tos/Calc: funkcija SLOPE|'''SLOPE''']] |
|Returns the slope of the linear regression line for a data set. | |Returns the slope of the linear regression line for a data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STEYX | + | |[[Documentation/SL/How_Tos/Calc: funkcija STEYX|'''STEYX''']] |
|Returns the standard error of the predicted y value for each x in the regression. | |Returns the standard error of the predicted y value for each x in the regression. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''see also (in the Array | + | |colspan="2"|'''see also (in the Array category)''' |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GROWTH | + | |[[Documentation/SL/How_Tos/Calc: funkcija GROWTH|'''GROWTH''']] |
|returns an array of values for an exponential least squares fit to known data pairs. | |returns an array of values for an exponential least squares fit to known data pairs. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LINEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija LINEST|'''LINEST''']] |
|returns an array of statistics for a straight line that best fits a data set. | |returns an array of statistics for a straight line that best fits a data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LOGEST | + | |[[Documentation/SL/How_Tos/Calc: funkcija LOGEST|'''LOGEST''']] |
|returns an array of statistics for an exponential curve that best fits a data set. | |returns an array of statistics for an exponential curve that best fits a data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TREND | + | |[[Documentation/SL/How_Tos/Calc: funkcija TREND|'''TREND''']] |
|fits a straight line to a data set using linear regression and returns points on that line. | |fits a straight line to a data set using linear regression and returns points on that line. | ||
Line 235: | Line 235: | ||
|colspan="2"|'''<big>Ranking</big>''' | |colspan="2"|'''<big>Ranking</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LARGE | + | |[[Documentation/SL/How_Tos/Calc: funkcija LARGE|'''LARGE''']] |
|Returns the n<sup>th</sup> largest value in a list of numbers. | |Returns the n<sup>th</sup> largest value in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MAX | + | |[[Documentation/SL/How_Tos/Calc: funkcija MAX|'''MAX''']] |
|Returns the maximum value in a list of arguments. | |Returns the maximum value in a list of arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MAXA | + | |[[Documentation/SL/How_Tos/Calc: funkcija MAXA|'''MAXA''']] |
|Returns the maximum value in a list of arguments including text. | |Returns the maximum value in a list of arguments including text. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MIN | + | |[[Documentation/SL/How_Tos/Calc: funkcija MIN|'''MIN''']] |
|Returns the minimum value in a list of arguments. | |Returns the minimum value in a list of arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MINA | + | |[[Documentation/SL/How_Tos/Calc: funkcija MINA|'''MINA''']] |
|Returns the minimum value in a list of arguments, including text. | |Returns the minimum value in a list of arguments, including text. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERCENTILE | + | |[[Documentation/SL/How_Tos/Calc: funkcija PERCENTILE|'''PERCENTILE''']] |
|Returns a specified percentile in a list of numbers. | |Returns a specified percentile in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERCENTRANK | + | |[[Documentation/SL/How_Tos/Calc: funkcija PERCENTRANK|'''PERCENTRANK''']] |
|Returns the percentage rank of a number in a list of numbers. | |Returns the percentage rank of a number in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: QUARTILE | + | |[[Documentation/SL/How_Tos/Calc: funkcija QUARTILE|'''QUARTILE''']] |
|Returns a specified quartile in a list of numbers. | |Returns a specified quartile in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: RANK | + | |[[Documentation/SL/How_Tos/Calc: funkcija RANK|'''RANK''']] |
|Returns the rank of a number in a list of numbers. | |Returns the rank of a number in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SMALL | + | |[[Documentation/SL/How_Tos/Calc: funkcija SMALL|'''SMALL''']] |
|Returns the n<sup>th</sup> smallest value in a list of numbers. | |Returns the n<sup>th</sup> smallest value in a list of numbers. | ||
Revision as of 19:39, 20 July 2008
Seznam statističnih funkcij za Calc
Statistične funkcije omogočajo statistično analizo podatkov.
Measures of Central Tendency | |
AVEDEV | Returns the average of the absolute deviations of values from their mean. |
AVERAGE | Returns the average of the arguments, ignoring text. |
AVERAGEA | Returns the average of the arguments, including text (valued as 0). |
COUNT | Prešteje števila v seznamu argumentov, prezre besedilne vnose. |
COUNTA | Prešteje ne prazne vnose v seznamu argumentov. |
GEOMEAN | Returns the geometric mean of the arguments. |
HARMEAN | Returns the harmonic mean of the arguments. |
MEDIAN | Returns the median of a set of numbers. |
MODE | Returns the most common value in a set of numbers. |
TRIMMEAN | Returns the mean of a set of numbers, ignoring a proportion of high and low values. |
Measures of dispersion / spread | |
DEVSQ | Returns the sum of squares of deviations from the mean. |
KURT | Returns the kurtosis, a measure of how peaked or flat a distribution is. |
SKEW | Returns a measure of how skewed a distribution is. |
STDEV | Returns the sample standard deviation. |
STDEVA | Returns the sample standard deviation (allowing text and logical values). |
STDEVP | Returns the population standard deviation. |
STDEVPA | Returns the population standard deviation (allowing text and logical values). |
VAR | Returns the sample variance. |
VARA | Returns the sample variance (allowing text and logical values). |
VARP | Returns the population variance. |
VARPA | Returns the population variance (allowing text and logical values). |
Probability and statistics | |
B | Calculates probabilities for a binomial distribution. |
BETADIST | Calculates the cumulative distribution of a beta distribution. |
BETAINV | Calculates the inverse of the BETADIST. |
BINOMDIST | Calculates probabilities for a binomial distribution. |
CHIDIST | Calculates values for a χ2-distribution. |
CHIINV | Calculates the inverse of the CHIDIST. |
CHITEST | Returns a measure of χ2 'goodness of fit'. |
CONFIDENCE | Returns a confidence interval. |
CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
EXPONDIST | Calculates values for an exponential distribution. |
FINV | Returns the inverse of the F probability distribution. |
FISHER | Calculates values for the Fisher transformation. |
FISHERINV | Calculates the inverse of the FISHER transformation. |
FDIST | Calculates the values of an F distribution. |
FTEST | Returns the result of an F test. |
GAMMAINV | Calculates the inverse of the cumulative GAMMADIST. |
GAMMALN | Returns the natural logarithm of the gamma. |
GAMMADIST | Calculates values for a gamma distribution. |
GAUSS | Returns the standard normal cumulative distribution. |
HYPGEOMDIST | Calculates values for a hypergeometric distribution. |
LOGINV | Returns the inverse of the lognormal distribution. |
LOGNORMDIST | Returns the cumulative lognormal distribution. |
NEGBINOMDIST | Calculates probabilities for a negative binomial distribution. |
NORMINV | Returns the inverse of the normal cumulative distribution. |
NORMDIST | Calculates values for a normal distribution. |
NORMSINV | Returns the inverse of the standard normal cumulative distribution. |
NORMSDIST | Calculates values for the standard normal cumulative distribution. |
PERMUT | Returns the number of permutations for a given number of objects. |
PERMUTATIONA | Returns the number of permutations for a given number of objects (repetition allowed). |
PHI | Calculates values for the standard normal probability distribution. |
POISSON | Calculates values for a Poisson distribution. |
PROB | Returns a result from a list of probabilities. |
STANDARDIZE | Converts a random variable to a normalized value. |
TDIST | Returns the t-distribution. |
TINV | Returns the inverse of the t-distribution. |
TTEST | Returns the probability associated with a Student's t-Test. |
WEIBULL | Returns the values of the Weibull distribution. |
ZTEST | Returns the two-tailed P value of a z test with standard distribution. |
Correlation and line fitting | |
CORREL | Returns the correlation coefficient between two data sets. |
COVAR | Returns the covariance of the product of paired deviations. |
FORECAST | Extrapolates future values based on existing x and y values. |
INTERCEPT | Calculates the point at which a line will intersect the y-values by using known x-values and y-values. |
PEARSON | Returns the Pearson product moment correlation coefficient r. |
RSQ | Returns the square of the Pearson correlation coefficient based on the given values. |
SLOPE | Returns the slope of the linear regression line for a data set. |
STEYX | Returns the standard error of the predicted y value for each x in the regression. |
see also (in the Array category) | |
GROWTH | returns an array of values for an exponential least squares fit to known data pairs. |
LINEST | returns an array of statistics for a straight line that best fits a data set. |
LOGEST | returns an array of statistics for an exponential curve that best fits a data set. |
TREND | fits a straight line to a data set using linear regression and returns points on that line. |
Ranking | |
LARGE | Returns the nth largest value in a list of numbers. |
MAX | Returns the maximum value in a list of arguments. |
MAXA | Returns the maximum value in a list of arguments including text. |
MIN | Returns the minimum value in a list of arguments. |
MINA | Returns the minimum value in a list of arguments, including text. |
PERCENTILE | Returns a specified percentile in a list of numbers. |
PERCENTRANK | Returns the percentage rank of a number in a list of numbers. |
QUARTILE | Returns a specified quartile in a list of numbers. |
RANK | Returns the rank of a number in a list of numbers. |
SMALL | Returns the nth smallest value in a list of numbers. |