Question: d ar ne v a si o a oje X A 1 Toss # 2 3 4 5 6 1 2 3 4 5 B
d ar ne v a si o a oje X A 1 Toss # 2 3 4 5 6 1 2 3 4 5 B Face 1 D Face 3 C Face 2 =RANDBETWEEN(0,1) E Face 4 - 6 down the side Image description: We have columns A - E across the top of the Excel sheet and rows 1 of the Excel sheet. Across the first row we have labels. Cell A1 contains "Toss #". Cell B1 contains "Face 1". Cell CI contains "Face 2". Cell D1 contains "Face 3". Cell El contains "Face 4". Down the first column we have our list of what set of tosses we are studying. Cell A2 contains "1". Cell A3 contains "2". Cell A4 contains "3". Cell A5 contains "4", and Cell A6 contains "5". Cell B2 begins our data generation with the function =RANDBETWEEN(0,1). You will enter the =RANDBETWEEN(0,1) function for all cells needed in the table. In your data, each row represents one experiment. One experiment is flipping 4 fair coins. Notice that every time you hit enter, the values in columns B-E change. This is the randomness in action. When we graph this, though, we will want a set of data that doesn't change
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
