How to calculate average in excel (or other spreadsheet)
In a spreadsheet like excel, we can use the build-in mathematical function AVERAGE().
The AVERAGE function can be used with a series of parameters like
=AVERAGE( number_1, number_2, ... number_255 )
Calculate average of a range (excel)
The AVERAGE function can be used with a range of cells as parameter like
= AVERAGE(A2 : A10) , which will calculate the average of all values from cell A2 to cell A10.
Calculate Standard deviation in excel
Use the build-in statistical function STDEV() to calculate the standard deviation of a set of data in excel.
The STDEV() function can be used with a set of values or with a range of cells as parameter.
=STDEV( number_1, number_2, ... number_255 )
=STDEV(A1 : A99)