sample

Hello,

I have a excel sheet with about 1000 rows and 60 columns. in each row, the first column is a UserID and the rest of the columns have some information for that UserID. I want make a sample of 500 of 1000 records. how can I do it?
example:
say this is my dataset before sampling:

userID spsID Name
668 41089 Playing
2329 41627 Eating
681 38411 Driving
674 38481 Drinking
674 38459 Sleeping
672 41736 Reading
672 41228 Sitting
731 38867 Driving
672 38323 Sitting
749 39044 Driving

after sampling I want to have something like this:
userID spsID Name
674 38481 Drinking
749 39044 Driving
2329 41627 Eating
668 41089 Playing
672 38323 Sitting
Note: I have also downloaded Data analysis for my excel.

Thanks a lot

you can use the "rand" function

Insert a column for Random Serial No.

add the formula like bellowing

Please Login or Register  to view this content.

Then select all your data together with the Serial No column
Sot by the Serial No.