The RAND() function in Excel returns a pseudo-random number between 0 and 1. If you enter this function into 1000 cells (i.e. enter the formula in one cell and copy it to 999 other cells), approximately how many of these cells will contain values less than or equal to 0.1

Question

10-11-2020
Computers and Technology

contestada

The RAND() function in Excel returns a pseudo-random number between 0 and 1. If you enter this function into 1000 cells (i.e. enter the formula in one cell and copy it to 999 other cells), approximately how many of these cells will contain values less than or equal to 0.1

Respuesta :

Otras preguntas

As water enters this plant cell structure, the cell becomes more turgid. This plant cell structure is the a. vacuole. b. cytoplasm. c. cell wall. d. chlorop

The sum of 3 consecutive numbers is 162. What is the smallest of the 3

Lauryn has128 marbles. kristin has 118 marble. who has more marbles?

0.6 as a mixed number

Which statement is the most accurate description of the middle colonies in the 1700s? A. They were home to diverse immigrants, they were a center of trade, and

In which two ways do extras function in a drama? a. They speak the majority of the dialogue and can be static, dynamic, or well-defined. b. They generally deliv

What is a real life example of limited government.

What forms when gas or liquid transfers heat as it moves

What are the partial products that result from multiplying 15x32?

What problems did the Patriots experience in the war in the South?

IfeanyiEze8899 IfeanyiEze8899 · Answer 1 · 2020-11-11T08:19:21+01:00

Answer:

To get this, filter the column with the condition "less than or equal 0.1" and check the number of returned rows at the bottom of the worksheet ( mine is 87 rows from 1000).

Explanation:

The RAND() function in Microsoft Excel is used to generate random numbers between zero and one. It can also be used to generate a range of numbers with decimal places by multiplying the stop number with the rand function