In MS-Excel 2007, STDEV[numberl, number 2, ...] is a statistical funct

In MS-Excel 2007, STDEV[numberl, number 2, …] is a statistical function that

[amp_mcq option1=”estimates standard deviation based on a sample by ignoring logical values and text in the sample” option2=”estimates standard deviation based on a sample by including logical values and text in the sample” option3=”calculates standard deviation based on the entire population by ignoring logical values and text” option4=”calculates standard deviation based on the entire population by including logical values and text” correct=”option1″]

This question was previously asked in

UPSC CISF-AC-EXE – 2019

Download PDF Attempt Online

The correct option is A.

In MS-Excel 2007 (and later versions with STDEV.S), the STDEV function (or STDEV.S) calculates the standard deviation based on a *sample*. It measures the dispersion or spread of data points around the mean. Importantly, the standard STDEV function in Excel ignores logical values (TRUE/FALSE) and text within the range of numbers provided as arguments when calculating the standard deviation.

Excel has other standard deviation functions: STDEVP (STDEV.P) for calculating the standard deviation of an *entire population*, which also ignores text and logical values; STDEVA for sample standard deviation that *includes* text (counted as 0) and logical values; and STDEVPA for population standard deviation that *includes* text and logical values. The question specifically asks about `STDEV`.

More similar MCQ questions for Exam preparation:-