CHIDIST

Function Type: Compatibility Description: Returns the one-tailed probability of the chi-squared distribution. In Excel 2007, this is a Statistical function. Function Structure: =CHIDIST(x, deg_freedom). Argument Breakdown: x – The value at which the chi-square distribution is to be evaluated (must be ≥ 0). deg_freedom – The number of degrees of freedom (must be an integer between 1Continue reading “CHIDIST”

BINOMDIST

Function Type: Compatibility Description: Returns the individual term binomial distribution probability. In Excel 2007, this is a Statistical function. Function Structure: =BINOMDIST(number_s, trials, probability_s, cumulative) Argument Breakdown: number_s – The number of successes. trials – The number of independent trials. probability_s – The probability success on each trial. cumulative – TRUE = cumulative distribution function,Continue reading “BINOMDIST”