Statistical Functions in EXCEL

.xlsx

School

The City College of New York, CUNY *

*We aren’t endorsed by this school

Course

20350

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

59

Uploaded by MajorFang13470

Report
Statistical functions (reference) in EXCEL We will go over only some of these statistics Function https://support.microsoft.com/en-us/office/stati AVEDEV function AVERAGE function AVERAGEA function AVERAGEIF function AVERAGEIFS function BETA.DIST function BETA.INV function BINOM.DIST function BINOM.DIST.RANGE function BINOM.INV function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CHISQ.TEST function CONFIDENCE.NORM function CONFIDENCE.T function CORREL function COUNT function COUNTA function COUNTBLANK function COUNTIF function COUNTIFS function COVARIANCE.P function COVARIANCE.S function
DEVSQ function EXPON.DIST function F.DIST function F.DIST.RT function F.INV function F.INV.RT function F.TEST function FISHER function FISHERINV function FORECAST function FORECAST.ETS function FORECAST.ETS.CONFINT function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT function FORECAST.LINEAR function FREQUENCY function GAMMA function GAMMA.DIST function GAMMA.INV function GAMMALN function GAMMALN.PRECISE function GAUSS function GEOMEAN function GROWTH function
HARMEAN function HYPGEOM.DIST function INTERCEPT function KURT function LARGE function LINEST function LOGEST function LOGNORM.DIST function LOGNORM.INV function MAX function MAXA function MAXIFS function MEDIAN function MIN function MINIFS function MINA function MODE.MULT function MODE.SNGL function NEGBINOM.DIST function NORM.DIST function NORM.INV function NORM.S.DIST function NORM.S.INV function PEARSON function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK.EXC function PERCENTRANK.INC function PERMUT function
PERMUTATIONA function PHI function POISSON.DIST function PROB function QUARTILE.EXC function QUARTILE.INC function RANK.AVG function RANK.EQ function RSQ function SKEW function SKEW.P function SLOPE function SMALL function STANDARDIZE function STDEV.P function STDEV.S function STDEVA function STDEVPA function STEYX function T.DIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function T.TEST function
T.TEST function TREND function TRIMMEAN function VAR.P function VAR.S function VARA function VARPA function WEIBULL.DIST function Z.TEST function
s Description Returns the average of the absolute deviations of data points from their mean Returns the average of its arguments Returns the average of its arguments, including numbers, text, and logical values Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria Returns the average (arithmetic mean) of all cells that meet multiple criteria Returns the beta cumulative distribution function Returns the inverse of the cumulative distribution function for a specified beta distribution Returns the individual term binomial distribution probability Returns the probability of a trial result using a binomial distribution Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value Returns the cumulative beta probability density function Returns the one-tailed probability of the chi-squared distribution Returns the cumulative beta probability density function Returns the inverse of the one-tailed probability of the chi-squared distribution Returns the test for independence Returns the confidence interval for a population mean Returns the confidence interval for a population mean, using a Student's t distribution Returns the correlation coefficient between two data sets Counts how many numbers are in the list of arguments Counts how many values are in the list of arguments Counts the number of blank cells within a range Counts the number of cells within a range that meet the given criteria Counts the number of cells within a range that meet multiple criteria Returns covariance, the average of the products of paired deviations Returns the sample covariance, the average of the products deviations for each data point pair in two data sets tistical-functions-reference-624dac86-a375-4435-bc25-76d659719ffd
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help