Tag Archives: Excel

Function Type: Compatibility Description: Returns the standard normal cumulative distribution. In Excel 2007, this is a Statistical function. Function Structure: =NORMSDIST(z). Argument Breakdown: z – The value for which you want the distribution. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.Continue reading “NORMSDIST”

Version Availability: Desktop version starting Excel 2010 Function Type: Compatibility Description: Returns the inverse of the normal cumulative distribution. Note: In Excel 2007, this is a Statistical function. Function Structure: =NORM.INV(probability, mean, standard_dev). Argument Breakdown: probability – The probability of an event occuring below a threshold. mean – The mean of the distribution. standard_dev –Continue reading “NORM.INV”

Function Type: Compatibility Description: Returns the normal cumulative distribution. In Excel 2007, this is a Statistical function. Function Structure: =NORMDIST(x, mean, standard_dev, cumulative). Argument Breakdown: x – The value for which you want the distribution. mean – The arithmetic mean of the distribution. standard_dev – The standard deviation for the distribution. cumulative – A logicalContinue reading “NORMDIST”

Function Type: Compatibility Description: Returns the negative binomial distribution. In Excel 2007, this is a Statistical function. Function Structure: =NEGBINOMDIST(number_f, number_s, probability_s). Argument Breakdown: number_f – The number of failures. number_s – The number of successes. probability_s – The probability of a success. Example: Still need help with Excel and Google Sheets? Get Instant ExpertContinue reading “NEGBINOMDIST”

Function Type: Compatibility Description: Returns the most common value in a data set. Function Structure: =MODE(number1, [number2]). Argument Breakdown: number1 – A number or cell reference that refers to numeric value. number2 – A number or cell reference that refers to numeric value. Example: Still need help with Excel and Google Sheets? Get Instant ExpertContinue reading “MODE”

Function Type: Compatibility Description: Returns the cumulative lognormal distribution. Function Structure: =LOGNORMDIST(x, mean, standard_dev). Argument Breakdown: x – The value at which you want to evaluate the log-normal distribution function. mean – The arithmetic mean of In(x). standard_dev – The standard deviation of In(x). Example: Still need help with Excel and Google Sheets? Get InstantContinue reading “LOGNORMDIST”

Function Type: Compatibility Description: Returns the inverse of the lognormal cumulative distribution. Function Structure: =LOGINV(probability, mean, standard_dev). Argument Breakdown: probability – A probability associated with the lognormal distribution. mean – The mean of In(x). standard_dev – The standard deviation of In(x). Example: Still need help with Excel and Google Sheets? Get Instant Expert Help inContinue reading “LOGINV”

Function Type: Compatibility Description: Returns the hypergeometric distribution. In Excel 2007, this is a Statistical function. Function Structure: =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop). Argument Breakdown: sample_s – The number of successes in the sample. number_sample – The size of the sample. population_s – The number of successes in the population. number_pop – The size of population.Continue reading “HYPGEOMDIST”

Function Type: Compatibility Description: Returns the inverse of the gamma cumulative distribution. In Excel 2007, this is a Statistical function. Function Structure: =GAMMAINV(probability, alpha, beta). Argument Breakdown: probability – The probability value for which you want to evaluate the inverse Gamma Cumulative Distribution Function (must be between 0 & 1). alpha – A parameter ofContinue reading “GAMMAINV”