Difference between revisions of "Documentation/SL/How Tos/Calc: Statistične funkcije"

From Apache OpenOffice Wiki
Jump to: navigation, search
(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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''BETADIST''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija BETADIST|'''BETADIST''']]
|Calculates the cumulative distribution function of a beta distribution.  
+
|Calculates the cumulative distribution of a beta distribution.  
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: BETAINV function|'''BETAINV''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija BETAINV|'''BETAINV''']]
|Calculates the inverse of the BETADIST function.
+
|Calculates the inverse of the BETADIST.
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: BINOMDIST function|'''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 function|'''CHIDIST''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija CHIDIST|'''CHIDIST''']]
 
|Calculates values for a &chi;<sup>2</sup>-distribution.   
 
|Calculates values for a &chi;<sup>2</sup>-distribution.   
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija CHIINV|'''CHIINV''']]
|Calculates the inverse of the CHIDIST function.  
+
|Calculates the inverse of the CHIDIST.  
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija CHITEST|'''CHITEST''']]
 
|Returns a measure of &chi;<sup>2</sup> 'goodness of fit'.
 
|Returns a measure of &chi;<sup>2</sup> 'goodness of fit'.
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: CONFIDENCE function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''GAMMAINV''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija GAMMAINV|'''GAMMAINV''']]
|Calculates the inverse of the cumulative GAMMADIST function.  
+
|Calculates the inverse of the cumulative GAMMADIST.  
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: GAMMALN function|'''GAMMALN''']]
+
|[[Documentation/SL/How_Tos/Calc: funkcija GAMMALN|'''GAMMALN''']]
|Returns the natural logarithm of the gamma function.
+
|Returns the natural logarithm of the gamma.
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: GAMMADIST function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 Function category)'''
+
|colspan="2"|'''see also (in the Array category)'''
 
|-valign="top"
 
|-valign="top"
|[[Documentation/How_Tos/Calc: GROWTH function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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 function|'''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.


Glejte tudi

Funkcije po kategorijah

Personal tools