The Excel formula for the standard deviation of a sample array named Data is:
A)=STDEV.S(Data).
B)=STANDEV(Data).
C)=STDEV.P(Data).
D)=SUM(Data)/(COUNT(Data)-1).

Question

Quizplus · Accepted Answer

The formula for the standard deviation of a sample array in Excel is STDEV.S(Data). STDEV.P(Data) is used for a population array and SUM(Data)/(COUNT(Data)-1) is not the correct formula for standard deviation.

The Excel Formula for the Standard Deviation of a Sample