Question: 4. a) Use the RANDBETWEEN function in Excel to generate the following. Set 1 consists of 20 random numbers between 1 and 200 (use RANDBETWEEN(1,200)).
4. a) Use the RANDBETWEEN function in Excel to generate the following.
Set 1 consists of 20 random numbers between 1 and 200 (use RANDBETWEEN(1,200)).
Set 2 consists of 25 random numbers between 50 and 150 (use RANDBETWEEN(50,150)).
Set 2 consists of 25 random numbers between 40 and 120 (use RANDBETWEEN(40,120)).
Copy and paste these numbers into your Word document.
b) Create a side by side by side set of box plots for the three data sets. The box plots can be created either by hand, Excel or R.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
