Data table options

There are seven options for reporting data

  1. total count of answers listed with each question (pdf)

  2. total count as percentages listed with each question (pdf)

Examples of data tables with percentages explained

3. data table with counts only

gpa safe counts

return to top

4. data table counts with base percentages

table base percentage

Base percentages are part divided by the entire whole. The part is any quantity that is specified. In this example, the answers are disaggregated according to GPA. If you just want to know the percentages based on total number answered, you indicate to us when we do the analysis that you want "base" percentages..

Example: 281/ 1006 x 100 = 28%

This means that 28% of the students answering this question identify themselves as having a GPA of A- to A+.

and 25/1006 x 100 = 2%

This means that of the 1006 students who took the test, only 2% indicated that they have a GPA of A- to A+ and they strongly disagree with the statement, "I feel safe at school."

 

 

return to top

5. data table counts with analysis percentages

counts only table

Analysis percentages are calcuated based on numbers going across a row. The percentage number is # of people in the category on the left side divided among the choices going across the top. For example: 25/281 x 100 = 9%. This means that nine percent of the students who identify themselves as having an A- to A+ average strongly disagree that they feel safe at school.

To request data analysis in this orientation, you would request "analysis" percentage when we work with you to create data tables for your school.

return to top

6. data table counts with break percentages

table break percentages

Break percentages work with the numbers vertically. The "part" is the number in the chart that is separated by category along the left divided by the "whole" which is found at the top of the column as the base number.

For example 25/134 x 100 = 19%.

This means that of the students who chose "strongly disagree", 19 % are students who identified themselves as having a GPA of A- to A+.

return to top

7. example of data table with counts and all three percentages

table all 3 percentages

A word of caution: when choosing percentages to use, keep in mind that in questions where more than one answer could be chosen, the percentages may give a misleading point of view.

 

 

Back to top