Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?
A)STDEVA
B)STDEV.P
C)STDEV.S
D)STDEVPA

Question

Quizplus · Accepted Answer

STDEVA is the best choice because it includes logical values and text in its calculation. STDEV.P and STDEV.S are both suited for numeric values only, while STDEVPA is a deprecated function and not recommended for use.

Which of the Following Functions Is Best Suited to Determine