1. (20 pts) create two sets of Data. NOTE carefully the required parameters.

Use RAND, BANDARRAY or RANDBETWEEN to create this data as shown in the

webex/lecture.

a. Create a set of 6 random integer numbers between 0 and 100

b Create 5 SETS of 30 integer numbers (150 in total) between 0 and 500

Your DATA should look like THIS: (DATA will need to be UNIQUE (it should also be

NUMBERS) for each student - DON'T USE THIS DATA)

I should be able to see the formulas used to create the data - you may need to

cut and PASTE it to lock the numbers in a second group.

Part a Part b

95 125 279 5 421 52

Y A A A A A

Z A A A A A

P A A A A A

DA

QA

A

A A A A A

A A

A

A A

A A

A A

A

A A

A A

A A

A A

A A

A A

A A A A A

A A A A A

A A A A A

A A A A A

A A A A A

A A A A A

A

A A A A A

A A A A A

A

A A

A A A A A

A A A A A

A A A A A