Gender Frequency

Open the file FALL $2022$ MATH $1680$ Census Data.

Add a new sheet named "Gender"

Copy column D of Sheet $1$ to column A and column C of the new sheet

Make row $1$ bold and centered

Highlight column $\text{'}$C$,$ then select Data $>$ Data Tools $>$ Remove Duplicates

In cell D$1,$ type "Frequency"

In cell D$2,$ enter the formula $=$COUNTIF$($A:A$,$ "Male"$)$

In cell D$3,$ enter the formula $=$ COUNTIF$($A:A$,$ "Female"$)$

In cell D$4,$ enter the formula $=$ COUNTIF$($A:A$,$ "Other"$)$

In cell C$5,$ type "Total"

In cell D$5,$ enter the formula $\frac{?}{S}=UM(D2$:$D4)$

Make the cell range $C5$:$D5$ bold