Tag: spreadsheet

MDM4U One-variable statistics activity

We’re going to be working on this activity today:

one-variable-statistics-spreadsheet-task

Here’s the data you’ll need – I already put in some stuff to help you organize your calculations. Remember that the goal here is to understand these measure and to learn how to perform these calculations. You can get help from other people, but you’re trying to learn to be independent as well!

https://docs.google.com/spreadsheets/d/1sfpPVoH2IU-kFPIA5D8WnRldCcXG7rer8vi4HlFWF5s/edit?usp=sharing

MDM4U More Binomial Distribution; beginning simulations 2016-04-18

We practised using binomial distributions using some textbook questions today (Page 386 #7, 8ab).

For homework you have Page 386 #10, and Page 406 #7-10.

We then spent about 30 minutes learning the basics of creating a dice simulation using a spreadsheet. Most people used Google Sheets. To generate a random die roll we used the formula

=randbetween(1,6)

We learned to sum cell values and fill formulas (by dragging the cursor or highlighting and pressing Ctrl+D).

Tomorrow we’ll continue with this work and develop some more complex simulations.

(Edit: Apparently I didn’t click the “Publish” button on this post, so it’s appearing just before noon on the 19th instead of 6pm on the 18th. Sorry folks!)

MDM4U Summarizing One-Variable Statistics – 2016-01-18

You’re going to start an assignment today in the Library computer lab. Here’s the task:

https://docs.google.com/document/d/1ew8ktz0ls5ObD2VQmrx0wp8kxLBp-r4UKYD7DEaAAaE/edit?usp=sharing

If you’re not 100% sure how to complete each part, here are a couple of videos along with some other sample data that can help you:

https://docs.google.com/spreadsheets/d/1ZUB-c2WR0lBx8Oe2zsw-qBMfZ1fPDQMkTGxVP1t9bfM/edit?usp=sharing