PHYSICS 1BB3 Lecture Notes - Lecture 13: Blackboard
Document Summary
The purpose of this exercise is twofold: it gives you a simple distribution to analyze and it gives you a bit of practice with excel. Rolling a pair of dice will produce an integer somewhere between 2 and 12. You are going to roll the pair of dice 36 times, record the integer sum of each trial in the spreadsheet, and then create a histogram to summarize your results. A possible way to proceed in excel is Record your raw data in column a, cells 1 to 36. (you can record your data directly on your spreadsheet, but just in case, have one member of your group record the values in a lab book. ) Sort the values in the column in ascending order. (click on the a of column a to choose the whole column. Then click on the data tab at the top of the sheet and choose the sort function. The default sort is usually smallest to largest.