lab3_demo3

# lab3_demo3 - Comments The Statistics of Throwing Two Dice...

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 3 4 6 5 3 6 3 2 1 5 6 4 4 5 5 6 6 3 1 1 2 2 5 2 3 5 6 5 3 2 3 3 5 2 1 2 2 1 1 6 3 5 6 5 1 3 1 1 5 5 3 Die2 2 1 1 4 2 1 5 5 3 6 6 6 4 1 5 6 2 3 5 2 4 6 5 4 6 1 2 2 3 4 2 2 3 6 5 2 3 4 6 2 3 4 2 4 2 6 4 6 6 2 6 Sum 5 5 7 9 5 7 8 7 4 11 12 10 8 6 10 12 8 6 6 3 6 8 10 6 9 6 8 7 6 6 5 5 8 8 6 4 5 5 7 8 6 9 8 9 3 9 5 7 11 7 9 Page 3 dieValues 2 4 4 4 1 1 1 3 2 5 2 5 5 3 3 3 4 6 4 4 3 4 4 2 4 4 1 6 6 2 3 6 5 1 2 2 3 1 5 5 3 1 5 2 2 6 3 4 4 5 4 2 6 4 2 4 3 6 6 6 5 4 5 6 2 4 3 6 4 1 2 3 5 4 3 6 6 1 5 3 5 3 2 5 6 5 3 5 4 6 6 3 3 3 3 6 4 4 5 5 2 5 5 6 8 8 6 8 4 7 7 9 7 9 7 11 7 7 6 9 8 7 6 7 8 8 7 8 10 5 6 9 11 5 5 11 11 6 5 7 7 7 11 8 6 4 8 8 6 10 8 9 6 10 9 8 Page 4 dieValues 5 5 4 6 6 4 6 2 3 6 6 1 3 1 4 5 5 6 1 3 6 5 5 6 2 6 3 4 4 4 2 4 6 2 4 1 3 2 6 3 1 2 2 2 5 1 3 6 2 2 4 2 6 2 4 4 1 6 5 5 2 2 5 4 3 5 6 3 3 4 2 6 1 6 5 1 1 6 2 6 5 5 2 3 6 4 6 4 3 5 2 2 1 2 4 6 6 6 6 5 2 1 5 2 11 7 8 10 7 10 11 7 5 8 11 5 6 6 10 8 8 10 3 9 7 11 10 7 3 12 5 10 9 9 4 7 12 6 10 5 6 7 8 5 2 4 6 8 11 7 9 11 4 3 9 4 Page 5 dieValues 1 2 5 1 6 3 2 1 4 6 5 2 6 6 6 4 4 6 4 1 3 5 1 5 6 5 3 5 4 6 5 3 3 5 3 4 3 3 1 2 5 4 1 4 6 6 6 1 5 3 5 5 1 3 6 4 5 3 2 4 1 1 6 5 1 4 4 1 6 6 3 1 4 3 4 5 5 4 4 1 3 4 3 3 3 3 1 6 5 2 3 1 6 6 2 2 4 3 5 3 3 6 1 6 2 5 11 5 11 6 4 5 5 7 11 7 7 10 10 5 10 12 7 2 7 8 5 10 11 9 7 6 7 10 8 6 6 8 4 10 8 5 4 3 11 10 3 6 10 9 11 4 8 9 6 11 Page 6 dieValues 2 4 2 3 6 1 2 3 1 6 5 3 6 4 5 5 4 3 2 5 5 6 3 2 5 4 2 1 5 5 6 4 6 2 6 2 5 5 4 5 3 6 2 5 3 4 1 6 3 1 2 1 1 2 3 6 6 6 6 4 2 3 1 1 3 5 4 3 1 3 5 5 1 5 1 3 4 2 4 6 1 4 4 4 4 1 1 6 5 2 2 1 2 3 4 6 1 4 3 2 6 2 3 2 3 6 5 9 12 7 8 7 3 9 6 4 9 9 9 8 5 6 7 10 6 11 4 5 9 6 6 7 6 9 10 8 10 3 7 8 10 7 6 6 5 9 6 11 4 8 4 8 9 3 5 3 Page 7 dieValues 3 2 1 2 3 6 6 5 2 6 5 2 2 4 4 3 4 6 5 1 3 6 5 5 1 2 4 1 5 2 3 2 3 5 3 3 6 1 6 5 4 1 4 1 6 5 1 2 1 5 5 2 1 6 6 1 3 1 5 5 3 3 2 6 2 2 3 5 6 5 5 2 1 1 3 5 1 5 6 4 5 5 2 5 1 2 2 5 5 2 5 6 1 1 2 2 3 3 2 6 4 6 4 2 4 8 7 3 6 7 11 10 5 9 7 8 4 6 7 8 10 11 10 3 4 7 8 10 2 7 10 5 10 7 5 7 4 7 5 8 11 3 11 11 5 2 6 3 9 8 3 8 5 11 9 4 Page 8 dieValues 4 3 3 4 2 2 6 1 5 6 5 3 1 3 3 3 2 3 6 4 5 6 2 3 6 5 4 4 2 3 5 4 5 4 1 5 6 4 4 1 3 1 1 4 4 6 6 3 4 2 6 3 4 3 4 1 1 5 5 3 5 6 5 1 6 1 5 5 6 5 4 1 1 6 5 1 6 3 4 1 4 1 5 6 6 6 4 1 6 4 1 6 3 6 6 4 2 6 3 4 4 6 4 6 8 6 7 5 3 7 11 4 10 12 10 4 7 4 8 8 8 8 10 5 6 12 7 4 12 8 8 5 6 4 10 10 11 10 5 6 12 8 5 7 6 7 7 8 6 12 9 7 8 8 10 9 Page 9 dieValues 3 1 6 4 1 2 2 3 5 2 6 2 4 1 3 3 4 6 4 5 1 5 5 1 4 1 6 6 5 6 4 1 5 3 3 1 2 5 6 2 1 5 4 4 5 3 6 2 3 1 1 3 6 6 1 2 2 4 1 5 6 3 4 4 3 3 3 4 6 3 3 3 4 6 2 1 3 3 3 2 3 1 1 3 1 6 3 2 3 5 6 5 3 2 1 5 2 4 2 3 5 5 6 1 9 7 7 6 3 6 3 8 11 5 10 6 7 4 6 7 10 9 7 8 5 11 7 2 7 4 9 8 8 7 5 4 6 9 6 3 5 10 12 7 4 7 5 9 7 7 8 5 8 6 7 4 Page 10 dieValues 6 1 6 1 4 1 4 3 2 4 3 1 5 5 2 6 2 5 2 1 4 6 6 4 2 4 1 3 4 3 3 5 2 4 2 3 5 2 5 6 1 4 1 6 2 3 6 1 5 5 3 1 2 1 5 2 1 6 1 5 3 6 2 6 6 1 5 1 1 6 1 5 5 2 2 3 2 2 4 4 5 2 5 3 4 4 4 4 6 2 5 6 6 4 2 1 4 3 4 2 1 5 1 1 8 2 11 3 5 7 5 8 5 10 5 7 11 6 7 7 3 11 3 6 9 8 8 7 4 6 5 7 9 5 8 8 6 8 6 7 11 4 10 12 7 8 3 7 6 6 10 3 6 10 4 2 Page 11 dieValues 3 6 2 6 3 3 4 1 6 4 6 6 3 5 4 1 2 6 6 5 4 5 5 1 3 3 3 6 6 5 4 4 4 3 4 5 3 2 3 6 6 1 4 2 5 2 5 2 2 6 6 5 2 3 1 6 2 4 3 3 6 4 5 5 4 4 5 6 6 6 3 6 2 2 1 6 5 5 2 3 6 5 4 5 6 4 4 1 1 4 2 2 6 2 3 1 4 6 3 5 3 5 5 4 5 9 3 12 5 7 7 4 12 8 11 11 7 9 9 7 8 12 9 11 6 7 6 7 8 8 5 9 12 10 8 9 10 7 8 6 4 6 5 8 12 3 7 3 9 8 8 7 5 11 11 9 Page 12 dieValues 2 3 2 3 4 4 4 6 6 5 5 6 5 6 3 6 4 1 5 2 1 4 5 1 4 2 1 3 6 3 6 6 5 4 4 5 4 3 6 1 3 5 4 2 3 5 6 6 6 6 2 2 2 6 4 2 2 4 2 6 3 1 4 1 1 5 4 5 4 3 6 4 3 6 5 3 5 6 3 2 5 2 3 2 4 1 3 5 5 3 3 3 3 3 3 1 3 4 3 5 4 4 4 5 4 9 6 5 6 8 6 12 9 6 9 7 6 11 7 11 8 4 11 6 4 10 10 4 9 8 4 5 11 5 9 8 9 5 7 10 9 6 9 4 6 8 7 3 6 9 9 11 10 10 6 7 Page 13 dieValues 1 2 1 2 5 6 2 5 4 6 3 1 3 5 6 5 5 6 3 2 2 3 1 1 5 2 1 2 3 2 1 2 6 3 3 4 6 1 1 5 1 6 3 4 1 2 5 6 5 1 1 5 6 4 6 3 3 1 2 1 4 4 4 6 2 1 5 1 6 1 5 2 1 1 3 1 5 1 1 3 3 1 3 6 5 2 3 5 4 6 1 1 5 1 1 1 6 6 2 4 5 3 1 4 7 6 7 5 8 7 4 6 8 10 7 7 5 6 11 6 11 7 8 4 3 4 4 2 10 3 2 5 6 3 4 8 11 5 6 9 10 7 2 6 6 7 4 5 7 8 7 10 10 4 2 9 Page 14 dieValues 4 1 6 3 6 1 3 2 4 5 1 2 6 6 6 1 3 2 1 2 1 2 1 1 6 2 3 5 6 4 2 3 6 6 3 6 4 2 4 3 1 3 2 1 6 6 3 6 1 3 6 1 1 5 5 5 6 3 2 5 4 3 3 4 5 3 1 4 4 2 2 5 6 3 4 3 5 6 6 3 3 5 6 5 5 5 1 1 4 1 4 2 3 5 4 2 1 5 2 3 3 6 4 3 5 6 11 8 12 4 5 7 8 8 4 6 11 9 7 5 7 4 3 7 7 5 5 4 11 8 9 8 9 9 8 8 11 11 4 7 8 3 8 5 4 8 6 3 7 11 5 9 4 9 10 4 Page 15 dieValues 4 1 4 4 2 3 2 4 2 3 5 2 1 3 1 4 6 5 3 2 2 1 2 3 2 4 2 1 4 5 6 3 4 1 3 5 2 6 5 1 4 4 5 4 2 4 5 3 5 4 8 3 5 8 7 9 5 8 3 6 10 4 7 8 2 8 10 10 7 4 6 6 5 8 6 Page 16 Countif Total 2 3 4 5 6 7 8 9 10 11 12 Frequency 13 38 59 76 92 113 105 68 61 55 20 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

Ask a homework question - tutors are online