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. For more information, watch the tutorial here (https://youtu.be/7MU2iwF9zd4).
Note: I have gotten many questions about how to unlock the cells. Only the non-shaded cells can be edited. The other cells have built-in formulas and text, and therefore, can not be edited.