Dear ex(cel)perts,
I have run into a problem analyzing some data from a questionnaire.
I would like to calculate the standard deviation for one variable - their weight, but they have to meet either of two conditions.
Or said in another way: In the questionnaire they have 3 options, but I only want to calculate the standard deviation of their weight if they have chosen option 1 or option 2, not option 3.
I have tried using the following formulas, but they did not work (even with ctrl+alt+enter):
=STDEV.P(IF(OR(Question Datarange="Option1",Question Datarange="Option2"),Weight Datarange))
=STDEV.P(IF(Question Datarange="Option1",Weight Datarange),IF(Question Datarange="Option2",Weight Datarange))
Anyone who can help me out here?
Best Regards
Knut
Bookmarks