project 1 stat

Sampling Procedures for Project 1

On the course portal webpage there is a file called “Project 1 Data.” This is the data file you want.

1. Save the Project 1 Data to your I:/ drive. Open the file in Excel.

2. Find the name closest to your last name on the list. This is the first member of your sample. In my case this is Deandre Bell.

3. Select the entire row using the row tag on the left end.

4. Start counting with the next name on the list. Count down three names. While holding the “Ctrl” key , select the row by clicking on the row tag. You now have two non-adjacent rows selected. Count down three more lines and select the next member of your sample. Repeat this procedure until you have thirty players. If you reach the bottom of the list go to the top and continue.

5. “Copy” the selection. Now go to the “Blank” worksheet and “Paste” the selection. You will now have your sample of thirty players in its own sheet for analysis.