Use this ABC Data Analysis Spreadsheet to convert your ABC data into behavior rates, antecedent and consequence percentages, and bar/pie graphs. This tool can help translate direct observation data into functional behavior assessment hypotheses.
This spreadsheet allows you to enter percentile rank scores for each assessment you use to provide a visual display of student performance. Each column spans 3 percentile ranks (i.e., 1st column=0, 1, 2; 2nd column=3, 4, 5; etc.) with the average