Search results
Results From The WOW.Com Content Network
If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST. The equation for the normal density function (cumulative = FALSE) is: When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
Applies To. Returns the standard normal distribution (has a mean of zero and a standard deviation of one). Use this function in place of a table of standard normal curve areas. Syntax – Standard Normal Distribution. NORM.S.DIST (z,cumulative) The NORM.S.DIST function syntax has the following arguments: Z Required.
If mean = 0, standard_dev = 1, and cumulative = TRUE, NORM.DIST returns the standard normal distribution, NORM.S.DIST. The equation for the normal density function (cumulative = FALSE) is: When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
Statistical functions (reference) To get detailed information about a function, click its name in the first column. 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.
Sum values based on multiple conditions. Applies To. Let's say that you need to sum values with more than one condition, such as the sum of product sales in a specific region. This is a good case for using the SUMIFS function in a formula.
Syntax. BINOM.DIST (number_s,trials,probability_s,cumulative) The BINOM.DIST function syntax has the following arguments: Number_s Required. The number of successes in trials. Trials Required. The number of independent trials. Probability_s Required. The probability of success on each trial.
Syntax. BINOMDIST (number_s,trials,probability_s,cumulative) The BINOMDIST function syntax has the following arguments: Number_s Required. The number of successes in trials. Trials Required. The number of independent trials. Probability_s Required. The probability of success on each trial.
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Returns the cumulative lognormal distribution of x, where ln (x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.