Question: how to calculate the standard deviation in excel 2016?
Answer: Let's say you have a column full of data. All you need to do to calculate the standard deviation is select an empty cell on your spreadsheet, type =stdev(a1:a20) and you'll get your answer instantly. This assumes that your data is numerical values in cells A1 to A20.