EXERCISES FOR SECTION 3.2
1. Use the data set from Figure 3.2 (Chpt 3-1.xls) and do the following:
a. Use the =RAND() function to draw a random sample of five patients from the twenty patients given in the file.
b. Use the uniform distribution option in the Data Analysis add-in to generate random numbers between 0 and 1 and use these numbers to select a simple random sample of seven patients from the twenty in the file. Specify a random seed of 1325.
c. Use the normal distribution option in the Data Analysis add-in to generate random numbers with a m...
- CHAPTER 3 - DATA ACQUISITION: SAMPLING AND DATA PREPARATION
- from Statistics for Health Care Professionals: Working With Excel, 2nd Edition
- Publisher: Jossey-Bass
- Released: September 2009
Share this highlighthttp://www.safaribooksonline.com/a/statistics-for-health/3559/