- #REAL STATISTICS RESOURCE PACK FOR EXCEL MAC 2016 TRIAL#
- #REAL STATISTICS RESOURCE PACK FOR EXCEL MAC 2016 SERIES#
Returns the minimum value in a list of arguments Returns the maximum value among cells specified by a given set of conditions or criteria Returns the maximum value in a list of arguments, including numbers, text, and logical values Returns the maximum value in a list of arguments Returns the inverse of the lognormal cumulative distribution Returns the cumulative lognormal distribution Returns the parameters of an exponential trend Returns the k-th largest value in a data set Returns the intercept of the linear regression line Returns values along an exponential trend Returns 0.5 less than the standard normal cumulative distribution Returns the natural logarithm of the gamma function, Γ(x) Returns the inverse of the gamma cumulative distribution Returns a frequency distribution as a vertical array Returns a future value based on existing values
#REAL STATISTICS RESOURCE PACK FOR EXCEL MAC 2016 SERIES#
Returns a statistical value as a result of time series forecasting Returns the length of the repetitive pattern Excel detects for the specified time series Returns a confidence interval for the forecast value at the specified target date Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
Note: In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions. Returns the inverse of the Fisher transformation Returns the inverse of the F probability distribution Returns the sample covariance, the average of the products deviations for each data point pair in two data sets Returns covariance, the average of the products of paired deviations Returns the correlation coefficient between two data setsĬounts how many numbers are in the list of argumentsĬounts how many values are in the list of argumentsĬounts the number of blank cells within a rangeĬounts the number of cells within a range that meet the given criteriaĬounts the number of cells within a range that meet multiple criteria Returns the confidence interval for a population mean, using a Student's t distribution
Returns the confidence interval for a population mean Returns the inverse of the one-tailed probability of the chi-squared distribution Returns the one-tailed probability of the chi-squared distribution Returns the cumulative beta probability density function Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
#REAL STATISTICS RESOURCE PACK FOR EXCEL MAC 2016 TRIAL#
Returns the probability of a trial result using a binomial distribution Returns the individual term binomial distribution probability Returns the inverse of the cumulative distribution function for a specified beta distribution Returns the beta cumulative distribution function Returns the average (arithmetic mean) of all cells that meet multiple criteria Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria Returns the average of its arguments, including numbers, text, and logical values Returns the average of the absolute deviations of data points from their mean For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions. These functions aren't available in earlier versions. Note: Version markers indicate the version of Excel a function was introduced.
0 kommentar(er)
