Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Excel Statistical Functions Cheat Sheet, Cheat Sheet of MS Microsoft Excel skills

Framingham State UniversityMS Microsoft Excel skills

excel has long list of built in functions, this document only lists all the statistical functions

Typology: Cheat Sheet

2020/2021
On special offer
30 Points
Discount

Limited-time offer

Uploaded on 04/26/2021

maya090
maya090 🇺🇸

4.3

(23)

287 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Statistical Functions
Function
Description
AVEDEV
Returns the average of the absolute deviations of data points from their
mean
AVERAGE
Returns the average of its arguments
AVERAGEA
Returns the average of its arguments, including numbers, text, and logical
values
AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a
given criteria
AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple
criteria.
CORREL
Returns the correlation coefficient between two data sets
COUNT
Counts how many numbers are in the list of arguments
COUNTA
Counts how many values are in the list of arguments
COUNTBLANK
Counts the number of blank cells within a range
COUNTIF
Counts the number of cells within a range that meet the given criteria
COUNTIFS
Counts the number of cells within a range that meet multiple criteria
DEVSQ
Returns the sum of squares of deviations
FISHER
Returns the Fisher transformation
FISHERINV
Returns the inverse of the Fisher transformation
FREQUENCY
Returns a frequency distribution as a vertical array
GAMMALN
Returns the natural logarithm of the gamma function, Γ(x)
GEOMEAN
Returns the geometric mean
GROWTH
Returns values along an exponential trend
HARMEAN
Returns the harmonic mean
HYPGEOM.DIST
Returns the hypergeometric distribution
INTERCEPT
Returns the intercept of the linear regression line
KURT
Returns the kurtosis of a data set
LARGE
Returns the k-th largest value in a data set
LINEST
Returns the parameters of a linear trend
LOGEST
Returns the parameters of an exponential trend
MAX
Returns the maximum value in a list of arguments
MAXA
Returns the maximum value in a list of arguments, including numbers, text,
and logical values
MEDIAN
Returns the median of the given numbers
MIN
Returns the minimum value in a list of arguments
MINA
Returns the smallest value in a list of arguments, including numbers, text,
and logical values
PEARSON
Returns the Pearson product moment correlation coefficient
PERMUT
Returns the number of permutations for a given number of objects
pf2
Discount

On special offer

Partial preview of the text

Download Excel Statistical Functions Cheat Sheet and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity!

Statistical Functions

Function Description

AVEDEV

Returns the average of the absolute deviations of data points from their mean AVERAGE Returns the average of its arguments AVERAGEA Returns the average of its arguments, including numbers, text, and logical values AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria. CORREL Returns the correlation coefficient between two data sets COUNT Counts how many numbers are in the list of arguments COUNTA Counts how many values are in the list of arguments COUNTBLANK Counts the number of blank cells within a range COUNTIF Counts the number of cells within a range that meet the given criteria COUNTIFS Counts the number of cells within a range that meet multiple criteria DEVSQ Returns the sum of squares of deviations FISHER Returns the Fisher transformation FISHERINV Returns the inverse of the Fisher transformation FREQUENCY Returns a frequency distribution as a vertical array GAMMALN Returns the natural logarithm of the gamma function, Γ(x) GEOMEAN Returns the geometric mean GROWTH Returns values along an exponential trend HARMEAN Returns the harmonic mean HYPGEOM.DIST Returns the hypergeometric distribution INTERCEPT Returns the intercept of the linear regression line KURT Returns the kurtosis of a data set LARGE Returns the k-th largest value in a data set LINEST Returns the parameters of a linear trend LOGEST Returns the parameters of an exponential trend MAX Returns the maximum value in a list of arguments MAXA Returns the maximum value in a list of arguments, including numbers, text, and logical values MEDIAN Returns the median of the given numbers MIN Returns the minimum value in a list of arguments MINA Returns the smallest value in a list of arguments, including numbers, text, and logical values PEARSON Returns the Pearson product moment correlation coefficient PERMUT Returns the number of permutations for a given number of objects

PROB Returns the probability that values in a range are between two limits RSQ Returns the square of the Pearson product moment correlation coefficient SKEW Returns the skewness of a distribution SLOPE Returns the slope of the linear regression line SMALL Returns the k-th smallest value in a data set STANDARDIZE Returns a normalized value STDEVA Estimates standard deviation based on a sample, including numbers, text, and logical values STDEVPA Calculates standard deviation based on the entire population, including numbers, text, and logical values STEYX Returns the standard error of the predicted y-value for each x in the regression TREND Returns values along a linear trend TRIMMEAN Returns the mean of the interior of a data set VARA Estimates variance based on a sample, including numbers, text, and logical values VARPA Calculates variance based on the entire population, including numbers, text, and logical values