Copy of lab1_demo5

# Copy of lab1_demo5 - Comments The Statistics of Throwing...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Comments The Statistics of Throwing Two Dice This model demonstrates the features of a spreadsheet which help with analysing fairly large amounts of data in simple ways. The dieValues worksheet. The raw data in this case is simply the values of two dice which are "rolled" ­ that is the roll of the dice is simulated ­ by the values produced by the function RAND. The function RAND simply produces a random value greater than or equal to 0 and and less than1. To obtain a value that is either 1, 2, 3, 4, 5, or 6 the value produced by RAND is multiplied by 6 and then rounded up using the ROUNDUP function. The two values are then added ­ the result being in the Sum column. This is done 700 times to simulate 700 throws of the two dice. The Countif worksheet This worksheet summarises the sum column of the dieValues worksheet by using the countif function. This function takes a criteria value ­ in this case the value under the Sum column and counts how many times that value occurs in the Sum column of the dieValues worksheet ­ that is it counts the entry in the dieValues worksheet if it is equal to the criteria value. Criteria can be specified in a variety of ways ­ "< someValue" or "> someValue" for example. In this case it is simple "= someValue". In addition a bar (column) chart is produced in order to represent the data visually. Page 1 Comments e Sum column. untif function. = someValue". Page 2 dieValues Die1 5 1 2 5 2 1 4 3 6 3 2 1 2 5 6 3 2 5 5 6 1 5 2 4 5 2 3 3 4 2 5 6 1 3 2 6 2 2 6 4 5 3 2 5 2 2 5 6 6 5 4 Die2 5 5 2 2 3 4 5 2 5 3 2 3 4 1 5 4 4 3 3 4 1 1 5 2 1 6 6 3 4 2 3 5 6 5 5 2 3 4 3 6 4 5 1 6 5 1 6 2 6 2 2 Sum 10 6 4 7 5 5 9 5 11 6 4 4 6 6 11 7 6 8 8 10 2 6 7 6 6 8 9 6 8 4 8 11 7 8 7 8 5 6 9 10 9 8 3 11 7 3 11 8 12 7 6 Page 3 dieValues 5 2 2 6 5 5 6 1 5 5 1 1 4 3 3 6 5 2 3 6 5 1 4 2 3 2 5 4 3 4 6 1 6 5 3 2 2 6 4 1 2 4 4 2 2 6 4 5 3 4 6 2 4 6 1 1 6 5 1 6 4 2 6 4 1 1 3 6 2 2 1 1 1 4 4 2 2 1 4 3 2 6 6 4 4 3 2 4 2 3 5 2 1 2 1 2 1 6 1 1 3 3 6 5 9 8 3 7 11 10 7 7 9 7 7 5 5 4 6 12 7 4 4 7 6 5 8 4 5 3 9 7 5 10 12 5 10 8 5 6 4 9 9 3 3 6 5 4 3 12 5 6 6 7 12 7 Page 4 dieValues 2 6 3 5 2 5 4 6 6 5 6 6 5 3 2 1 4 2 6 4 3 6 3 4 5 5 6 1 1 4 6 5 4 4 6 5 4 2 4 2 3 6 4 6 4 6 1 1 4 1 6 6 2 1 5 1 5 3 5 6 5 6 3 3 3 3 5 4 3 6 6 1 2 3 6 6 2 3 5 4 5 3 2 4 4 6 3 2 3 5 6 6 2 6 2 1 4 4 3 4 4 5 4 5 4 7 8 6 7 8 9 12 11 11 9 9 8 6 7 5 7 8 12 5 5 9 9 10 7 8 11 5 6 7 8 9 8 10 9 7 7 7 10 8 5 12 6 7 8 10 4 5 8 6 10 11 Page 5 dieValues 3 4 1 2 5 5 2 5 2 2 2 6 1 3 5 4 4 1 1 1 4 1 5 4 4 3 1 5 2 2 3 6 1 4 3 1 5 5 2 3 1 5 1 2 5 1 2 1 1 4 4 3 4 2 6 5 4 2 2 5 5 5 3 2 6 6 1 2 1 2 4 3 6 6 5 6 1 5 6 2 1 1 6 6 6 1 2 5 6 2 3 2 6 5 1 4 2 3 1 1 3 5 3 4 7 6 7 7 9 7 4 10 7 7 5 8 7 9 6 6 5 3 5 4 10 7 10 10 5 8 7 7 3 3 9 12 7 5 5 6 11 7 5 5 7 10 2 6 7 4 3 2 4 9 7 7 Page 6 dieValues 6 5 3 6 1 4 2 3 2 1 4 5 6 1 1 6 4 6 6 3 4 1 5 4 5 3 6 6 4 3 3 4 6 1 3 4 3 6 6 1 2 1 5 6 1 6 3 4 1 6 2 5 2 1 1 2 3 5 1 5 6 3 3 2 4 3 4 3 6 4 6 6 6 6 5 3 6 5 2 2 5 1 4 2 1 4 5 4 1 4 1 4 5 3 1 1 2 2 4 4 2 5 4 4 8 6 4 8 4 9 3 8 8 4 7 7 10 4 5 9 10 10 12 9 10 7 10 7 11 8 8 8 9 4 7 6 7 5 8 8 4 10 7 5 7 4 6 7 3 8 7 8 3 11 6 9 Page 7 dieValues 1 6 1 6 3 3 6 3 4 3 6 3 5 4 6 5 6 1 4 2 6 6 1 5 5 4 2 3 2 1 2 2 3 1 2 5 1 6 1 5 5 3 2 1 6 5 1 2 2 2 5 4 5 4 1 6 3 6 1 2 6 2 1 1 6 2 1 2 1 4 6 6 6 5 5 3 4 2 4 6 1 1 2 5 1 2 6 3 1 5 1 4 6 2 1 6 4 2 1 6 3 3 3 1 6 10 2 12 6 9 7 5 10 5 7 4 11 6 7 7 7 5 10 8 12 11 6 8 9 6 6 9 3 2 4 7 4 3 8 8 2 11 2 9 11 5 3 7 10 7 2 8 5 5 8 5 Page 8 dieValues 6 1 1 6 1 6 1 6 3 1 3 6 5 1 3 3 1 3 1 6 4 3 1 5 6 6 2 1 6 4 5 4 2 6 2 3 5 4 2 2 2 3 5 4 4 6 1 1 3 4 6 3 6 3 1 5 6 2 2 1 1 4 3 3 5 2 3 4 2 3 1 2 1 6 5 2 3 6 2 5 1 1 2 6 6 6 2 6 5 6 5 2 1 1 4 3 5 1 2 4 2 1 4 1 12 4 2 11 7 8 3 7 4 5 6 9 10 3 6 7 3 6 2 8 5 9 6 7 9 12 4 6 7 5 7 10 8 12 4 9 10 10 7 4 3 4 9 7 9 7 3 5 5 5 10 4 Page 9 dieValues 6 4 2 1 6 1 6 3 5 4 6 1 6 6 5 4 3 5 1 2 3 4 1 4 3 5 1 4 4 5 6 1 4 6 6 4 4 3 2 3 2 6 1 2 6 1 3 1 1 5 2 2 5 6 1 5 4 3 4 5 3 3 6 5 2 5 6 3 5 2 5 6 6 3 2 6 6 2 2 6 6 4 3 3 2 6 5 2 2 2 4 1 4 1 3 3 4 1 5 2 1 1 1 3 11 10 3 6 10 4 10 8 8 7 12 6 8 11 11 7 8 7 6 8 9 7 3 10 9 7 3 10 10 9 9 4 6 12 11 6 6 5 6 4 6 7 4 5 10 2 8 3 2 6 3 5 Page 10 dieValues 5 3 6 4 6 4 5 4 6 3 6 3 4 1 5 5 1 2 5 2 2 5 4 4 6 5 4 5 3 1 2 3 5 2 4 3 2 5 2 2 3 1 1 2 5 5 2 2 6 5 1 2 5 5 6 5 2 3 6 5 5 4 2 4 1 2 6 3 3 1 6 5 5 5 6 2 3 1 5 2 2 6 1 5 2 5 4 4 5 1 5 2 2 6 1 6 4 3 6 1 1 4 4 1 10 8 12 9 8 7 11 9 11 7 8 7 5 3 11 8 4 3 11 7 7 10 10 6 9 6 9 7 5 7 3 8 7 7 8 7 7 6 7 4 5 7 2 8 9 8 8 3 7 9 5 3 Page 11 dieValues 1 1 3 5 2 5 4 1 4 2 6 5 6 3 4 2 5 2 4 5 5 2 4 4 1 6 1 5 1 6 5 3 3 4 4 5 6 4 3 5 6 2 2 1 1 1 1 2 1 3 1 6 2 1 3 2 5 5 3 1 2 5 5 3 5 3 6 5 5 2 1 6 5 4 2 2 1 5 6 4 1 1 5 1 3 4 6 2 2 1 4 1 3 4 1 6 3 6 5 3 3 5 5 2 3 2 6 7 7 10 7 2 6 7 11 8 11 6 10 7 10 4 5 11 10 6 6 6 2 11 7 9 2 7 10 4 6 8 10 7 8 5 7 6 9 6 3 7 4 7 6 5 4 8 6 8 Page 12 dieValues 2 4 4 6 5 4 1 2 4 6 6 2 6 5 5 6 1 4 5 2 4 3 4 5 1 6 5 6 6 4 2 5 6 1 5 1 2 6 2 1 2 2 3 3 6 6 4 3 5 2 6 5 6 3 4 2 4 1 6 4 1 3 5 1 1 4 6 4 1 3 5 3 3 6 4 5 2 4 6 2 4 4 5 4 3 2 5 3 2 3 6 4 2 1 6 2 2 1 1 4 4 4 3 2 8 7 8 8 9 5 7 6 5 9 11 3 7 9 11 10 2 7 10 5 7 9 8 10 3 10 11 8 10 8 7 9 9 3 10 4 4 9 8 5 4 3 9 5 8 7 5 7 9 6 9 7 Page 13 dieValues 5 2 2 2 4 2 5 1 5 5 4 5 5 5 2 1 1 1 5 4 5 1 5 1 1 5 6 6 4 4 1 1 6 3 3 6 1 4 1 2 3 5 4 1 2 2 2 4 3 6 1 5 2 4 6 3 3 3 6 5 4 6 2 2 2 1 5 3 1 2 2 2 2 6 3 1 3 5 4 4 5 4 6 4 2 1 5 1 1 6 5 4 2 1 2 4 2 4 3 2 2 1 5 5 7 6 8 5 7 5 11 6 9 11 6 7 7 6 7 4 2 3 7 6 7 7 8 2 4 10 10 10 9 8 7 5 8 4 8 7 2 10 6 6 5 6 6 5 4 6 5 6 5 7 6 10 Page 14 dieValues 5 6 6 1 1 4 3 6 3 2 4 6 6 4 4 1 5 2 1 1 1 5 3 3 1 2 3 3 6 2 3 6 3 6 4 4 3 2 1 4 1 5 6 6 2 4 4 5 5 3 3 6 1 3 6 1 2 5 5 5 5 2 4 6 6 5 1 3 3 6 5 2 1 4 4 5 5 4 4 2 2 1 4 3 1 2 3 6 4 3 5 4 2 5 4 1 6 1 4 4 1 4 2 1 6 9 12 2 3 9 8 11 8 4 8 12 12 9 5 4 8 8 6 3 2 9 7 8 6 6 7 5 8 3 7 9 4 8 7 10 7 5 6 8 3 10 10 7 8 5 8 9 6 7 5 7 Page 15 dieValues 3 5 4 5 1 2 4 1 2 3 1 6 5 1 3 1 1 3 1 3 4 2 5 6 6 6 1 4 2 5 3 1 1 5 4 6 1 5 3 1 6 5 5 5 1 2 4 2 2 1 9 6 8 7 6 5 5 2 7 7 7 7 10 4 4 7 6 8 6 4 6 6 7 8 7 Page 16 Countif Total 2 3 4 5 6 7 8 9 10 11 12 Frequency 24 43 56 73 91 137 91 66 62 36 21 Frequency Counts of the Sum of the Dice 140 120 100 80 60 40 20 0 2 3 4 5 6 7 8 9 10 11 12 Sum of Dice Count Page 17 ...
View Full Document

## This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Ask a homework question - tutors are online