CENGAGE Essentials of Modern Business Statistics with Microsoft by David R Anderson, Dennis J Sweeney, Thomas A Williams, Jeffrey D Camm, James J Cochran, Michael J Fry, Jeffrey W Ohlmann

¢ ~ CENGAGE

, Digitized by the Internet Archive
in 2022 with funding from
Kahle/Austin Foundation




httops://archive.org/details/essentialsofmodeQ000ande_m3g8

, Microsoft® Office Excel® Functions
Function Description
AVERAGE Returns the arithmetic mean of a range its arguments.
BINOM.DIST Returns the individual term binomial distribution probability.
CHISQ.DIST Returns a probability from the chi-squared distribution.
CHISQ.DIST.RT Returns the one-tailed probability of the chi-squared distribution.
CHISQ.INV Returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.TEST Returns the value from the chi-squared distribution for the statistic and the degrees
of freedom.
CONFIDENCE.NORM Returns the confidence interval for a population mean using the normal distribution.
CORREL Returns the correlation coefficient between two data sets.
COUNT Returns the number of cells in the range that contain numbers.
COUNTA Returns the number of non-blank cells in the range.
COUNTIF Returns the number of cells in a range that meet the specified criterion.
COVARIANCE.S Returns the sample covariance.
EXPON.DIST Returns a probability from the exponential distribution.
EDISTERT Returns the right-tailed probability from the F distribution.
GEOMEAN Returns the geometric mean of a range of cells.
HYPGEOM.DIST Returns a probability from the hypergeometric distribution.
MAX Returns the maximum value of the values in a range of cells.
MMEDIAN Returns the median value of the values in a range of cells.
MIN Returns the minimum value of the values in a range of cells.
MODE.SNGL Returns the most-frequently occurring value in a range of cells.
NORM.S.DIST Returns a probability from a standard normal distribution.
NORM.S.INV Inverse of the standard normal distribution.
PERCENTILE.EXC Returns the specified percentile of the values in a range of cells.
POISSON.DIST Returns a probability from the poisson distribution.
POWER Returns the result of a number raised to a power.
QUARTILE.EXC Returns the specified quartile of the values in a range of cells.
RAND Returns a real number from the uniform distribution between 0 and 1.
SQRT Returns the positive square root of its argument.
STDEV:S Returns the sample standard deviation of the values in a range of cells.
SUM Returns the sum of the values in a range of cells.
SUMPRODUCT Returns the sum of the products of the paired elements of the values in two ranges of cells.
TDIST, Returns a left-tailed probability of the t distribution.
T.INV.2T Returns the two-tailed inverse of the student's t-distribution.
VAR.S Returns the sample variance of the values in a range of cells.

,