Instructions on How to Select a random Sample for your Assignment In order to select a random sample for your assignment, go to the Survey Data Sheet and follow the following steps Step 1: Select the data from Cells A2 to J647 in the "Survey Data" worksheet Step 2: Go to Data>Sort and select Sort by "Random Number" Make sure the "My data has headers" option located on the top right is checked before you click OK This step will randomly change the order of the reponses. This is simple random sampling procedure you practiced in workshop 1 Step 3: Select the first 100 obseravtion as your sample Make sure you copy your selected sample into a new spreadsheet. To do this, select cells B1 toJ102, Press Ctrl+C (this command will copy the selected data) Press Ctrl+N (this command will open a new spreadsheet file) Press Ctrl+V (this command will paste your selected sample in the new spreadsheet) Make sure you save the new spreadsheet. Note: Please make sure you save your data file as everytime you repeat steps 1 to 3 above you will obtain a different sample. *You will have to submit this sample with your assignment so that your calculations are double checked. * If you are doing this assignnent in a group, only one student should select a sample as the above process will result in a different sample every time you follow steps 1 to 3. Need help with selecting a sample? See your tutor. See LMS for details of consultation hour. Make Sure you Submit the following information with your random Sample Tutorial Time: Tutor Name: Group Members Details Student NO Student Name Group Member 1 Group Member 2 Group Member 3