AVERAGE and MEDIAN: to pinpoint the central tendency of your data. STDEV.P and STDEV.S: for gauging standard deviation and understanding the spread around the mean. CORREL: to assess the relationship and degree of correlation between two variables. LINEST: for running linear regression analyses ...
Statisticians and scientists usually add one more step to produce a number that has the same units as each of the measurements. The step is to take the square root of the sum of squares. This number is the standard deviation, and it denotes the average amount each measurement deviated from ...