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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started