lab1_demo5 - Comments The Statistics of Throwing Two Dice...

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

View Full Document Right Arrow Icon
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 he Sum column. ountif function. "= someValue". Page 2 dieValues Die1 1 4 3 5 1 6 5 1 2 2 2 3 5 1 6 2 4 6 1 5 3 5 3 6 4 6 4 1 1 3 6 5 3 3 2 4 6 6 3 6 1 5 3 1 6 2 2 3 5 2 6 Die2 1 6 6 2 5 5 5 5 5 4 2 3 2 4 2 5 6 5 6 4 1 4 2 6 5 2 5 3 2 2 6 5 3 4 4 2 5 3 2 6 1 6 5 5 3 3 6 1 5 5 1 Sum 2 10 9 7 6 11 10 6 7 6 4 6 7 5 8 7 10 11 7 9 4 9 5 12 9 8 9 4 3 5 12 10 6 7 6 6 11 9 5 12 2 11 8 6 9 5 8 4 10 7 7 Page 3 dieValues 5 2 1 3 5 1 2 3 6 5 2 2 4 3 1 5 2 3 5 3 3 2 1 6 1 1 5 1 4 2 5 3 6 3 4 3 3 5 2 3 3 6 1 3 3 2 4 2 2 1 4 6 6 6 4 5 1 4 4 3 2 3 2 6 4 1 5 3 5 1 3 6 4 4 5 5 6 5 3 3 3 3 4 6 1 5 5 6 1 4 4 5 3 4 1 6 4 5 1 4 3 4 6 3 11 8 5 8 6 5 6 6 8 8 4 8 8 4 6 8 7 4 8 9 7 6 6 11 7 6 8 4 7 5 9 9 7 8 9 9 4 9 6 8 6 10 2 9 7 7 5 6 5 5 10 9 Page 4 dieValues 1 4 3 5 4 1 4 3 2 1 1 2 6 2 5 4 1 1 1 3 4 4 2 1 3 2 4 6 5 1 3 1 4 1 2 4 1 6 6 5 2 5 3 3 6 3 6 6 6 3 3 5 1 5 3 1 6 5 5 4 6 4 5 2 3 2 4 2 5 1 4 6 5 4 2 6 3 2 4 3 3 2 3 4 4 2 5 4 5 1 2 1 2 6 6 5 1 3 3 4 4 6 1 6 2 9 6 6 10 6 9 7 8 5 6 4 9 4 9 6 6 2 5 9 9 8 4 7 6 4 8 9 8 3 6 5 8 3 7 8 6 7 8 6 4 11 9 8 7 6 9 10 10 9 4 11 Page 5 dieValues 6 5 6 2 3 1 5 6 5 1 1 3 6 6 5 6 4 4 1 5 5 3 2 1 5 6 6 5 1 1 4 3 4 4 4 3 2 5 2 5 6 6 6 5 3 5 6 1 1 3 1 1 4 5 6 4 2 1 6 3 4 3 5 6 6 5 2 5 4 4 4 5 4 6 3 3 1 1 6 2 6 5 5 1 1 6 5 3 3 6 4 6 1 4 6 4 6 6 6 1 4 5 5 5 10 10 12 6 5 2 11 9 9 4 6 9 12 11 7 11 8 8 5 10 9 9 5 4 6 7 12 7 7 6 9 4 5 10 9 6 5 11 6 11 7 10 12 9 9 11 12 2 5 8 6 6 Page 6 dieValues 4 1 5 5 3 4 3 3 2 5 2 5 3 6 5 1 5 2 5 2 5 3 1 5 6 3 2 3 2 2 2 3 2 4 5 1 3 3 3 6 4 3 4 3 1 6 6 3 1 1 5 2 3 6 5 5 4 5 3 3 5 1 1 5 2 1 4 6 3 1 4 1 1 5 1 5 2 3 1 2 4 2 1 2 1 5 6 5 3 4 4 1 3 3 5 5 6 4 2 3 1 6 5 2 7 7 10 10 7 9 6 6 7 6 3 10 5 7 9 7 8 3 9 3 6 8 2 10 8 6 3 5 6 4 3 5 3 9 11 6 6 7 7 7 7 6 9 8 7 10 8 6 2 7 10 4 Page 7 dieValues 5 5 5 4 6 1 6 3 1 2 5 6 4 5 2 3 4 3 5 4 1 2 6 5 6 6 5 5 6 3 3 2 6 2 4 2 2 4 1 3 3 6 1 3 1 2 5 4 1 2 4 2 1 4 2 4 2 1 4 3 6 3 6 4 6 1 2 6 1 1 2 6 4 4 6 4 1 1 5 6 2 4 2 6 1 4 4 5 4 3 2 3 1 2 1 4 1 6 4 4 4 6 5 4 6 9 7 8 8 2 10 6 7 5 11 10 10 6 4 9 5 4 7 10 5 6 12 9 7 7 10 11 8 7 5 8 7 6 8 7 6 7 3 6 4 8 2 7 2 8 9 8 5 8 9 6 Page 8 dieValues 1 2 2 1 6 5 4 2 6 2 6 2 5 5 1 3 6 2 3 5 3 3 4 4 1 1 6 1 6 2 6 3 3 1 1 1 2 3 6 1 1 6 4 5 6 5 4 5 4 4 4 2 6 5 1 4 4 6 1 1 5 3 4 6 1 4 3 1 2 5 1 3 2 3 6 4 3 6 6 3 5 6 1 4 6 4 5 5 3 3 5 1 6 2 6 1 4 6 6 1 6 5 5 4 7 7 3 5 10 11 5 3 11 5 10 8 6 9 4 4 8 7 4 8 5 6 10 8 4 7 12 4 11 8 7 7 9 5 6 6 5 6 11 2 7 8 10 6 10 11 10 6 10 9 9 6 Page 9 dieValues 6 3 5 6 5 6 5 6 3 4 4 5 1 1 6 3 6 5 3 4 3 4 1 6 2 3 5 2 4 4 4 3 6 2 6 4 2 3 6 5 5 6 3 2 3 4 5 3 2 6 4 2 5 5 6 4 6 5 3 4 4 4 6 2 2 3 5 2 6 6 5 4 2 3 2 4 3 3 6 2 5 2 4 6 3 2 3 6 2 2 3 3 1 2 3 2 1 5 6 1 4 5 1 4 11 8 11 10 11 11 8 10 7 8 10 7 3 4 11 5 12 11 8 8 5 7 3 10 5 6 11 4 9 6 8 9 9 4 9 10 4 5 9 8 6 8 6 4 4 9 11 4 6 11 5 6 Page 10 dieValues 6 2 1 6 2 3 6 6 3 3 3 6 4 5 3 6 6 1 1 6 5 2 6 1 3 4 2 4 2 6 3 6 6 2 6 3 3 2 4 5 6 1 4 1 6 3 5 4 3 4 1 6 6 5 5 1 6 5 5 4 3 3 2 5 4 5 1 1 2 1 1 6 3 2 5 1 3 3 6 3 5 2 4 5 2 6 6 2 4 4 3 3 1 2 2 5 5 6 3 3 4 6 2 6 12 7 6 7 8 8 11 10 6 6 5 11 8 10 4 7 8 2 2 12 8 4 11 2 6 7 8 7 7 8 7 11 8 8 12 5 7 6 7 8 7 3 6 6 11 9 8 7 7 10 3 12 Page 11 dieValues 3 6 4 2 5 5 6 2 5 2 1 6 5 4 3 2 5 6 4 5 3 5 3 1 4 4 2 1 1 5 2 2 6 1 3 6 4 6 5 1 4 1 2 5 5 5 2 6 3 5 6 3 3 2 1 4 4 2 3 5 6 4 3 6 3 3 5 4 6 1 2 1 3 4 2 1 1 3 5 4 6 5 3 6 6 2 4 6 5 5 6 1 3 5 5 1 2 3 6 1 2 1 5 5 6 8 5 6 9 7 9 7 11 6 4 12 8 7 8 6 11 7 6 6 6 9 5 2 5 7 7 5 7 10 5 8 12 3 7 12 9 11 11 2 7 6 7 6 7 8 8 7 5 6 11 8 Page 12 dieValues 3 3 3 3 2 5 4 6 1 2 5 4 1 5 1 4 4 3 5 1 3 4 3 1 1 6 4 6 6 5 5 3 4 3 5 2 3 1 2 3 4 1 5 5 3 5 5 4 1 4 3 6 4 3 1 4 1 3 4 4 2 4 3 1 1 3 1 2 3 1 1 6 1 6 6 3 4 3 5 4 4 4 6 3 3 6 2 3 1 5 5 1 2 2 1 6 5 3 2 1 3 1 6 6 7 6 4 7 3 8 8 10 3 6 8 5 2 8 2 6 7 4 6 7 4 10 9 4 5 9 9 10 10 9 11 6 7 9 7 5 4 6 7 4 6 3 6 11 8 8 7 5 4 5 9 12 Page 13 dieValues 5 4 1 2 2 5 1 6 6 5 5 1 3 4 4 5 4 1 3 3 3 5 5 1 2 3 3 5 2 6 6 6 1 2 3 2 5 3 4 2 3 6 1 5 6 1 1 1 1 4 6 2 5 6 6 1 5 2 1 3 4 4 5 3 5 5 6 4 2 3 5 2 5 2 4 4 4 6 6 4 6 2 5 4 3 1 3 4 5 1 4 3 6 4 5 4 2 4 5 6 2 2 3 6 10 10 7 3 7 7 2 9 10 9 10 4 8 9 10 9 6 4 8 5 8 7 9 5 6 9 9 9 8 8 11 10 4 3 6 6 10 4 8 5 9 10 6 9 8 5 6 7 3 6 9 8 Page 14 dieValues 6 2 1 3 1 2 5 3 4 3 3 6 6 6 3 4 4 5 2 2 3 4 4 6 3 5 6 3 1 4 2 5 6 5 5 4 4 3 1 3 4 3 5 1 1 3 5 2 5 6 6 4 5 4 4 3 4 2 1 1 5 3 4 4 3 4 5 1 2 6 5 1 3 4 2 6 1 2 6 4 5 2 4 1 6 4 2 6 1 1 2 2 4 1 3 5 6 5 3 2 5 1 3 4 11 6 5 6 5 4 6 4 9 6 7 10 9 10 8 5 6 11 7 3 6 8 6 12 4 7 12 7 6 6 6 6 12 9 7 10 5 4 3 5 8 4 8 6 7 8 8 4 10 7 9 8 Page 15 dieValues 5 5 1 3 2 1 4 1 6 6 5 3 2 6 6 5 3 4 5 1 5 1 2 6 4 4 6 5 1 4 5 1 2 4 4 4 2 4 3 2 3 5 4 3 6 6 1 2 1 2 9 11 6 4 6 6 5 3 10 10 9 5 6 9 8 8 8 8 8 7 11 2 4 7 6 Page 16 Countif Total 2 3 4 5 6 7 8 9 10 11 12 Frequency 22 26 57 63 118 103 98 83 60 48 22 Frequency Counts of the Sum of the Dice 120 100 80 Count 60 40 20 0 2 3 4 5 6 7 8 9 10 11 12 Sum of Dice Page 17 ...
View Full Document

This note was uploaded on 02/13/2012 for the course CSE 1520 taught by Professor Kemeny during the Fall '08 term at York University.

Ask a homework question - tutors are online