Statistical Analysis in Excel

=average

The sum of all the values divided by the number of values

=min

smallest number in a range

=max

highest number in a range

=sum

all values added together

=median

middle number when values are placed in ascending order

=range

The smallest value minus the largest value

=count

Counts the number of cells in a range that contains numbers

=counta

Counts the number of cells in a range that are blank

=countif

Counts a group of numbers based on a condition

=stdev

Works out the variation of data around the mean

=pearson

Pearsons correlation coefficient (r)

Standard deviation

a measure of spread of data

Pearson’s correlation

measures the strength of a linear association