I'm taking a basic Excel course, and struggling to comprehend the difference between STDEV.S and STDEV.P. I get that one draws the standard deviation from a sample of the population and the other uses the entire data set, but how representative is the sample of the whole group? Is there information somewhere about how large of a sample Excel chooses to use for STDEV.S, relative to the total number of values?