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

estimates standard deviation based on a sample by ignoring logical values and text in the sample

estimates standard deviation based on a sample by including logical values and text in the sample

calculates standard deviation based on the entire population by ignoring logical values and text

calculates standard deviation based on the entire population by including logical values and text

Answer is Right!

Answer is Wrong!

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`.

Join Our Telegram Channel

More similar MCQ questions for Exam preparation:-