View source for Documentation/SL/How Tos/Calc: Statistične funkcije

From Apache OpenOffice Wiki

← Documentation/SL/How Tos/Calc: Statistične funkcije

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page:

{{DISPLAYTITLE:Statistične funkcije}} ==Seznam statističnih funkcij za Calc== Statistične funkcije omogočajo statistično analizo podatkov. {| border="0" cellpadding="0" cellspacing="10" align="left" |-valign="top" |colspan="2"|'''<big>Measures of Central Tendency</big>''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija AVEDEV|'''AVEDEV''']] |Returns the average of the absolute deviations of values from their mean. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija AVERAGE|'''AVERAGE''']] |Returns the average of the arguments, ignoring text. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija AVERAGEA|'''AVERAGEA''']] |Returns the average of the arguments, including text (valued as 0). |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija COUNT|'''COUNT''']] |Prešteje števila v seznamu argumentov, prezre besedilne vnose. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija COUNTA|'''COUNTA''']] |Prešteje ne prazne vnose v seznamu argumentov. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GEOMEAN|'''GEOMEAN''']] |Returns the geometric mean of the arguments. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija HARMEAN|'''HARMEAN''']] |Returns the harmonic mean of the arguments. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MEDIAN|'''MEDIAN''']] |Returns the median of a set of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MODE|'''MODE''']] |Returns the most common value in a set of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija TRIMMEAN|'''TRIMMEAN''']] |Returns the mean of a set of numbers, ignoring a proportion of high and low values. |-valign="top" |colspan="2"|'''<big>Measures of dispersion / spread</big>''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija DEVSQ|'''DEVSQ''']] |Returns the sum of squares of deviations from the mean. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija KURT|'''KURT''']] |Returns the kurtosis, a measure of how peaked or flat a distribution is. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija SKEW|'''SKEW''']] |Returns a measure of how skewed a distribution is. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STDEV|'''STDEV''']] |Returns the sample standard deviation. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STDEVA|'''STDEVA''']] |Returns the sample standard deviation (allowing text and logical values). |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STDEVP|'''STDEVP''']] |Returns the population standard deviation. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STDEVPA|'''STDEVPA''']] |Returns the population standard deviation (allowing text and logical values). |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija VAR|'''VAR''']] |Returns the sample variance. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija VARA|'''VARA''']] |Returns the sample variance (allowing text and logical values). |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija VARP|'''VARP''']] |Returns the population variance. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija VARPA|'''VARPA''']] |Returns the population variance (allowing text and logical values). |-valign="top" |colspan="2"|'''<big>Probability and statistics</big>''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija B|'''B''']] |Calculates probabilities for a binomial distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija BETADIST|'''BETADIST''']] |Calculates the cumulative distribution of a beta distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija BETAINV|'''BETAINV''']] |Calculates the inverse of the BETADIST. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija BINOMDIST|'''BINOMDIST''']] |Calculates probabilities for a binomial distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija CHIDIST|'''CHIDIST''']] |Calculates values for a &chi;²-distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija CHIINV|'''CHIINV''']] |Calculates the inverse of the CHIDIST. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija CHITEST|'''CHITEST''']] |Returns a measure of &chi;² 'goodness of fit'. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija CONFIDENCE|'''CONFIDENCE''']] |Returns a confidence interval. |-valign="top" |[[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. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija EXPONDIST|'''EXPONDIST''']] |Calculates values for an exponential distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FINV|'''FINV''']] |Returns the inverse of the F probability distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FISHER|'''FISHER''']] |Calculates values for the Fisher transformation. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FISHERINV|'''FISHERINV''']] |Calculates the inverse of the FISHER transformation. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FDIST|'''FDIST''']] |Calculates the values of an F distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FTEST|'''FTEST''']] |Returns the result of an F test. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GAMMAINV|'''GAMMAINV''']] |Calculates the inverse of the cumulative GAMMADIST. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GAMMALN|'''GAMMALN''']] |Returns the natural logarithm of the gamma. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GAMMADIST|'''GAMMADIST''']] |Calculates values for a gamma distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GAUSS|'''GAUSS''']] |Returns the standard normal cumulative distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija HYPGEOMDIST|'''HYPGEOMDIST''']] |Calculates values for a hypergeometric distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija LOGINV|'''LOGINV''']] |Returns the inverse of the lognormal distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija LOGNORMDIST|'''LOGNORMDIST''']] |Returns the cumulative lognormal distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija NEGBINOMDIST|'''NEGBINOMDIST''']] |Calculates probabilities for a negative binomial distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija NORMINV|'''NORMINV''']] |Returns the inverse of the normal cumulative distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija NORMDIST|'''NORMDIST''']] |Calculates values for a normal distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija NORMSINV|'''NORMSINV''']] |Returns the inverse of the standard normal cumulative distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija NORMSDIST|'''NORMSDIST''']] |Calculates values for the standard normal cumulative distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PERMUT|'''PERMUT''']] |Returns the number of permutations for a given number of objects. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PERMUTATIONA|'''PERMUTATIONA''']] |Returns the number of permutations for a given number of objects (repetition allowed). |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PHI|'''PHI''']] |Calculates values for the standard normal probability distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija POISSON|'''POISSON''']] |Calculates values for a Poisson distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PROB|'''PROB''']] |Returns a result from a list of probabilities. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STANDARDIZE|'''STANDARDIZE''']] |Converts a random variable to a normalized value. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija TDIST|'''TDIST''']] |Returns the t-distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija TINV|'''TINV''']] |Returns the inverse of the t-distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija TTEST|'''TTEST''']] |Returns the probability associated with a Student's t-Test. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija WEIBULL|'''WEIBULL''']] |Returns the values of the Weibull distribution. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija ZTEST|'''ZTEST''']] |Returns the two-tailed P value of a z test with standard distribution. |-valign="top" |colspan="2"|'''<big>Correlation and line fitting</big>''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija CORREL|'''CORREL''']] |Returns the correlation coefficient between two data sets. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija COVAR|'''COVAR''']] |Returns the covariance of the product of paired deviations. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija FORECAST|'''FORECAST''']] |Extrapolates future values based on existing x and y values. |-valign="top" |[[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. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PEARSON|'''PEARSON''']] |Returns the Pearson product moment correlation coefficient r. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija RSQ|'''RSQ''']] |Returns the square of the Pearson correlation coefficient based on the given values. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija SLOPE|'''SLOPE''']] |Returns the slope of the linear regression line for a data set. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija STEYX|'''STEYX''']] |Returns the standard error of the predicted y value for each x in the regression. |-valign="top" |colspan="2"|'''see also (in the Array category)''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija GROWTH|'''GROWTH''']] |returns an array of values for an exponential least squares fit to known data pairs. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija LINEST|'''LINEST''']] |returns an array of statistics for a straight line that best fits a data set. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija LOGEST|'''LOGEST''']] |returns an array of statistics for an exponential curve that best fits a data set. |-valign="top" |[[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. |-valign="top" |colspan="2"|'''<big>Ranking</big>''' |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija LARGE|'''LARGE''']] |Returns the n^th largest value in a list of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MAX|'''MAX''']] |Returns the maximum value in a list of arguments. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MAXA|'''MAXA''']] |Returns the maximum value in a list of arguments including text. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MIN|'''MIN''']] |Returns the minimum value in a list of arguments. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija MINA|'''MINA''']] |Returns the minimum value in a list of arguments, including text. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PERCENTILE|'''PERCENTILE''']] |Returns a specified percentile in a list of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija PERCENTRANK|'''PERCENTRANK''']] |Returns the percentage rank of a number in a list of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija QUARTILE|'''QUARTILE''']] |Returns a specified quartile in a list of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija RANK|'''RANK''']] |Returns the rank of a number in a list of numbers. |-valign="top" |[[Documentation/SL/How_Tos/Calc: funkcija SMALL|'''SMALL''']] |Returns the n^th smallest value in a list of numbers. |} <br style="clear:both;" /> <!-- why on earth is this necessary? --> ==Glejte tudi== '''[[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]''' [[Category: SL/Documentation/Reference/Calc]]

Return to Documentation/SL/How Tos/Calc: Statistične funkcije.