Probability simulation using Google Sheets

Подписаться 921

Просмотров 8 тыс.

50% 1

This video explains how to simulate a random probability experiment using Google Sheets. I created this for my class as they had to compare theoretical and experimental probabilities for an assignment.
The commands used include randbetween(), ifs(), if(), counta() and countif(). I give six different examples of probability experiments.

Опубликовано:

16 май 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@emreulkucubh8774 2 года назад

Thank you! I was about to start a harder version based on the earlier part of the video (like doing a "randbetween(1,52)" and identifying what card each number represents)... ugh, glad I watched the end! BTW, you can hide full rows/columns by right-clicking on their headers (like where you'd select for filtering or resizing), but you'd have to move that other stuff at the top over to the right so it doesn't get hidden.

@YoruIkusane 3 года назад

1:00 Rolling Dice 4:05 Spinner 1 (Equal Chance) 6:06 Spinner 2 (Non-Equal Chance) 8:30 Marble Picker 9:53 Marble Picker (Replacing) 11:50 Pick a Card

@lamle9324 Год назад

Can I haev your file?

@mrhallatwork Год назад

Sorry. I don't have it in a shareable format anymore. Anyway, my aim was that my students would make their own and learn through the experience. It really won't take long to make your own. Plus you can customize it to your own questions and any pictures you already have. Good luck.

@jackmuir5314 Год назад

I got confused, you waffle way too much. I do not care about examples, how do I just get the simulation I want in the sheet to run it. I should not have to put in "game inputs" to set one up