formula for variance (Practical example. Hypothesis testing. Gender bias in Spark Fortress))

Hi,

how to calculate variance for female and male groups using formula? The given formula in Excel homework does not work in  and variance given in lecture and solution to homework differs.