Excel randomly choose Yes or No.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.
Transcript of the video:
How do we randomly choose between yes or no in Excel? Let's talk about RANDBETWEEN first.
RANDBETWEEN between 1, 2 will randomly generate the numbers one or two.
And then we send that whole thing into CHOOSE. So we get a one or two there, and then this is what we get. For 1 Yes.
For 2, No. Close paren.
And you see that we should be in general about 50/50.
What if you want less or more Yes? So then we say =IF( the RAND() is less than or equal to 20% then “Yes” otherwise “No”. Now this is not going to be perfect.
Over thousands of times it will work out to about 20%.
But like right here it won't. Five out of 20, so that's 25%.
Press F9 and two. If you like these videos, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments in the comments below.
RANDBETWEEN between 1, 2 will randomly generate the numbers one or two.
And then we send that whole thing into CHOOSE. So we get a one or two there, and then this is what we get. For 1 Yes.
For 2, No. Close paren.
And you see that we should be in general about 50/50.
What if you want less or more Yes? So then we say =IF( the RAND() is less than or equal to 20% then “Yes” otherwise “No”. Now this is not going to be perfect.
Over thousands of times it will work out to about 20%.
But like right here it won't. Five out of 20, so that's 25%.
Press F9 and two. If you like these videos, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments in the comments below.
