Standard Deviation

[DPD011]

Hello,

Im working on calculating the z score based on work type, finding the standard deviation based on the work type has proven difficult.
On column E I have the work type example Basic, Advanced, Medium, on column F I have the scores. How would I calculate the standard deviation based on each work type.
Thank you

 

[AhoyNC]

This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	E	F	G	H	I
1	Basic	403			Std. Dev
2	Advanced	218		Basic	174.48
3	Medium	329		Advanced	122.32
4	Medium	122		Medium	134.64
5	Basic	188
6	Advanced	265
7	Medium	215
8	Basic	210
9	Basic	481
10	Advanced	272
11	Advanced	98
12	Medium	418
13	Basic	482
14	Medium	177
15	Advanced	438
16	Medium	452
17	Basic	65
Sheet

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=STDEV(IF(E2:E400="basic",F2:F400))