Forum

Notifications
Clear all

Standard deviation by group

2 Posts
2 Users
0 Reactions
180 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hey,

I need a function of standard deviation
That you know how to take numbers for each group individually
I have run the STDEV function but it requires me to mark the numbers
And in the attachment I have 2 groups - H P
How do you automatically calculate a standard deviation for each group individually ??
(Similar to SUMIF which knows how to summarize each group separately?)

 
Posted : 18/02/2022 7:13 am
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

Hello,

Easiest solution is to use Pivot Table, see attached. If you don't want to show the Pivot Table, you can use GETPIVOTDATA to fetch the information in the table.

Br,
Anders

 
Posted : 18/02/2022 3:23 pm
Share: