Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Geometry And Analysis Of Fractals Hong Kong, December 2012

Authors: De Jun Feng, Ka Sing Lau

1st Edition

3662439204, 9783662439203

More Books

Students also viewed these Mathematics questions

Question

How would you support more positive behaviors and help

Answered: 1 week ago