# Pivot Solution

Used a pivot table for this - the variances are completely different. Can someone let me know why? Also - seems like the totals for the Over 35+Below 35 is 175 in the video/solution - but there should only be 174?

4 answers ( 0 marked as helpful)

Hey Bianca,

Do you want to share a screenshot of your work, please?

Thanks!

I only added the age grouping...

Thank you!

Well, I would recomend you use VARPA formula it good to go to find variance for any approbiate value how to use it easy

=VARPA(IF(Dataset!$E$5:$L$178="Female",Dataset!$K$5:$K$178))

=VARPA(IF(Dataset!$E$5:$L$178="Male",Dataset!$K$5:$K$178))

=VARPA(If(enter yourrange="Female", target column)) now **you have to hit (ctl + shift + Enter)** and you will get the same results hopefully that help you