Home > front end >  How can I group Standard Deviation of multiple sets
How can I group Standard Deviation of multiple sets

Time:01-31

I have a group of respondents (e.g. 4), each answering a few questions (e.g. 10 questions). The questions belong to 3 groups (Basic, Advanced, Other). I want to calculate the Standard deviation for each group (STDev for the Basic questions, STDev for the Advanced questions, STDev for the Other questions). How can I do that?

Here's an example google sheet, where A:K are the answers of the respondents and M:N is the grouping of the different questions. I want the Standard deviations, per group, in column Q using a formula. enter image description here

  • Related