Creating a random DataSet from a Set of Values

We will use Excel to create a Random DataSet from a list of values. The formula used is: =INDEX($B:$B,RANDBETWEEN(2,COUNTA($B:$B)),1)
B is the excel column that holds our data. We use $ to keep the formula on Column B while we drag the formula to the size we need.
Data Values start in Row 2, Row 1 is our header, hence the 2 as the first part of the RANDBETWEEN.
We will also use =AVERAGE( ) to calculate the average of each set of data.
The video below shows how to do this, it is about 5 minutes.