Which of the following statements is (are) false regarding the numbers generated
ID: 3315258 • Letter: W
Question
Which of the following statements is (are) false regarding the numbers generated by the RAND function in Excel?
Question 10 options:
Approximately 10% of the numbers will be between 0.0 and 1.0
Approximately 20% of the numbers will be between 0.50 and 0.70
Approximately 40% of the numbers will be between 0.20 and 0.60
Approximately 60% of the numbers will be between 0.15 and 0.75
Approximately 10% of the numbers will be between 0.0 and 1.0
Approximately 20% of the numbers will be between 0.50 and 0.70
Approximately 40% of the numbers will be between 0.20 and 0.60
Approximately 60% of the numbers will be between 0.15 and 0.75
Explanation / Answer
RAND function generates a random number between 0 and 1.
Therefore, there will be approximately 100% numbers between 0.0 and 0.1.
The incorrect answer is the first one i.e:
Approximately 10% of the numbers will be between 0.0 and 1.0.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.