Create formula: mean of Col A for rows where Col B is minimum in group Col C?
Say I were using the Big Class dataset, and wanted to create a new column for the average weight of the shortest student of the same age - how do I set that up? I know how to do the first bit (find the height of the shortest student the same age,) that is just a Col Mean with a byVariable: Col Minimum( :height, :age ) But what I don't know how to do is to then take the average weight of those subs...