In order to calculate a proportion (the next section in this tutorial), you will need to have calculated the total count (sum) of students with valid data in your student cohort.

5: Calculate the total number (sum) of students in your cohort with valid data for the variable sex 

• In your "calculations" worksheet, locate the appropriate cell to enter the total number (sum) of students who have entered data for the variable sex:

• With your mouse, select the cell in which you want to enter the total number of students.
• Type the following into the formula bar:

=sum(

• With your mouse, select the data range (column of data) for the n (count) of males and females (i.e., cell range B20:B21).
• Press the Enter key on your keyboard to complete the formula.

You have now calculated the total count (sum) of males and females within your student cohort.  Now SAVE your workbook!

Did you all get the same answer?