Question

What is the difference between stdev.s and stdev.p?

Answer 1

STDEV.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the standard deviation usingSTDEV.P. The standard deviation is calculated using the "n-1" method. Arguments can either be numbers or names, arrays, or references that contain numbers.