Question: Generate the following 5 distributions each using the randbetween function, then use Histogram (this can be found under the insert tab in Excel) to plot

Generate the following 5 distributions each using the randbetween function, then use Histogram (this can be found under the "insert" tab in Excel) to plot the resulting sample distribution. d6 = six sided die

Sheet 1: d6 Sheet, Make the histograms of 1-6 rolls.

1. d6 6 rolls

2. d6 18 rolls

3. d6 200 rolls

4. d6 + 2 200 rolls (Essentially add 2 to all the numbers)

5. Advantage: do the d6 and d6 +2 columns, but instead of rolling one number roll keep the higher of two rolls. Use the MAX function to work on this.

I just need help in formatting the correct formulas in order to get the data. You don't need to work in excel just help me with using the correct functions. Thanks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!