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