🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Average value and SD of attributes

User: "jean_claude_van"
New Altair Community Member
Updated by Jocelyn

Hello

 

I have a dataset in which I would like

i) to select automatically all the attributes having a name starting by letter C,

ii) then calculate the average value and standard deviation of the values of each attribute,

ii) get a final table with the name of the attributes and their average values and standard deviations.

Do you now operators I could use for that. I spent the afternoon without any success.

 

Jean Claude

Find more posts tagged with

Sort by:
1 - 2 of 21

    Hi,

     

    you can use Select Attributes with regular expression C.+

     

    Afterwards, you use Aggregate and activate the "default aggregation" which uses all attributes.

     

    Best,

    Martin 

    User: "Telcontar120"
    New Altair Community Member

    Or you can use "Loop Attributes" and do a similar Aggregate operation inside the loop and then feed the results out to a dataset that you append together at the end.