Change set
Pick exam & year, then Go.
Question map
Not attempted
Correct
Incorrect
★
Bookmarked
Loading…
Q145
(CISF/2019)
Science & Technology › ICT, AI, Cybersecurity & Emerging Tech
In MS-Excel 2007, STDEV(number1, number 2, ... ) is a statistical function that
Result
Your answer:
—
·
Correct:
A
Explanation
In MS-Excel 2007, the STDEV function is used to estimate the standard deviation based on a sample of a population. It is one of the most commonly used statistical functions for data analysis. Key characteristics include:
- Sample Basis: It assumes that its arguments are a sample of the population. If the data represents the entire population, the
STDEVPfunction should be used. - Exclusion: It ignores logical values (TRUE/FALSE) and text that appear in arrays or cell references.
- Calculation: It uses the "n-1" method (Bessel's correction) to calculate the square root of the variance.
If you need to include logical values and text in the calculation (treating TRUE as 1 and FALSE/text as 0), you would use the STDEVA function instead.
How others answered
Each bar shows the % of students who chose that option.
Green bar = correct answer, blue outline = your choice.
Community Performance
Out of everyone who attempted this question.
0%
got it right
✓ Thank you! We'll review this.