In: Statistics and Probability
Excel Homework:
We are going to start working on sample statistics—that is, on measures we can sue to describe a sample. The two that we will learn about today are histograms, and 5 number summaries (which can be represented using box-plots).
1. You are designing a game, and considering having players roll a six-sided die and a 20-sided die, and add the values of each die. To get a picture of what happens when someone rolls dice like that, you decide to collect a sample of size 30, and see what it looks like.
**I understand you would use “=randbetween(1,6)” in excel for the six sided die but this problem is also asking to do it with a 20 sided die as well and add the values but I don’t know how**
randbetween(a,b) gives random integer between a and b inclusive
now
for 6-sided, we use =randbetween(1,6)
for 20-sided die, we can use =randbetween(1,20)
x1 | x2 | sum |
5 | 13 | 18 |
6 | 14 | 20 |
4 | 17 | 21 |
1 | 20 | 21 |
4 | 11 | 15 |
6 | 14 | 20 |
4 | 11 | 15 |
6 | 3 | 9 |
4 | 2 | 6 |
2 | 1 | 3 |
6 | 19 | 25 |
5 | 3 | 8 |
1 | 18 | 19 |
3 | 18 | 21 |
4 | 5 | 9 |
2 | 8 | 10 |
6 | 16 | 22 |
6 | 7 | 13 |
4 | 1 | 5 |
4 | 18 | 22 |
5 | 19 | 24 |
4 | 8 | 12 |
1 | 10 | 11 |
3 | 20 | 23 |
3 | 3 | 6 |
2 | 1 | 3 |
2 | 5 | 7 |
3 | 20 | 23 |
5 | 5 | 10 |
6 | 16 | 22 |