search this site.

200623P - DATA SUMMARY USING EXCEL

Print Friendly and PDFPrint Friendly

Presented in the Biostatistics module of the Clinical Research Coordinators Course on June 23, 2020 11.00-12.00 by Professor Omar Hasan Kasule MB ChB (MUK), MPH (Harvard), DrPH (Harvard)  Professor of Epidemiology and Bioethics King Fahad Medical City


SUMMARY (AVERAGE) OF DISCRETE DATA 

Rates = events per time also called incidence rate. It is numerator/denominator per unit time

Hazard (to be defined in a higher course)

Proportion = number of events as a percentage of the total at a point in time


SUMMARY (AVERAGE) OF CONTINUOUS DATA

The arithmetic mean is the sum of the observations' values divided by the total number of observations

The mode is the value of the most frequent observation. 

The median is the value of the middle observation in a series ordered by magnitude. 


SUMMARY (VARIATION) OF DISCRETE DATA

Variance of a proportion


SUMMARY (VARIATION) OF CONTINUOUS DATA

Measures of variation based on the mean: variance, standard deviation (square root of variance)

Measures based on quartiles: Q1, Q3, The inter-quartile range Q3 - Q



ASSIGNMENTS

CLASSROOM DATA

We are going to generate a data set about ourselves called the classroom data. 


The class leader will prepare the template named CLASS DATA as follows. Click on the Microsoft Excel icon on your computer. You will see a blank Workbook in the top left-hand corner. Click on the workbook and you will see a table with columns and rows.  Type the following variable names on row 1 starting from left to right: AGE (in years), GENDER (male, female) REGION of birth (East, North, West, Central, West), ORDER in the family (first, second, third, higher), WEIGHT (in kilograms), HEIGHT (in centimeters), SHOE SIZE (in cm), wearing glasses (yes, no), COLOR preference (blue, red, green, yellow), number of BROTHERS, number of SISTERS, type of primary SCHOOL (private, public), type of UNIVERSITY (public, private),


The class leader will send the template to the class WhatsApp group. Each member will have a row in which to type information. For confidentiality, this information could be yours or someone you know who is not in the class. Each class member shall have a copy of the data set. We shall use it in classroom exercises.


CLASSROOM EXERCISES ON DATA SUMMARY

Compute summary statistics (mean, median, mode, minimum, maximum, 1st quartile, 3rd quartile) for AGE, WEIGHT, and HEIGHT.