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
Get step-by-step solutions from verified subject matter experts
