Exploring Probability with Spreadsheets

Jay Kesler

You can follow this presentation on your device at https://slides.com/d/TgYqYF8/live

Open https://sccd-my.sharepoint.com and sign in with your Sierra College account

...and open that new folder

Create a New Spreadsheet

Start a "Student" Column

Enter "Student" in cell A1

Enter the number 1 in cell A3

In cell A4, type =A3+1

=A3+1

Drag down to row 37 to Give your spreadsheet 35 students

Select cell A4 (the cell with "2" in it)

Coloring groups of cells helps you visually understand what the information is describing

In cell B1, Type "Classroom"

In cell C1, Type the number "1"

Group these together visually by giving them a color.

=RANDBETWEEN(1,365)

In cell C2, type =MODE(C3:C37)

=MODE(C3:C37)

to find anybody with the same birthday in this classroom.

In cell B2, type "Birthday Twins" and add some color to cells B2 and B3 by selecting both cells and using the paint bucket.

In cell D1, change the value from the number 1 to the formula =C1+1

=C1+1

Select cells D1 through D37 (click on D1 and drag down)

Drag the Magic Box to the right many many columns.

By jkesler

Use a spreadsheet to see how likely birthday twins are in a group of 35 people.