You can do this with a formula (getting mean of minimum weights in age group):
Col Mean(If(:height == Col Min(:height, :age), :weight, .), :age)
Split the formula into two different formulas to make it a bit easier to understand:
Min weight values:
If(:height == Col Min(:height, :age),
:weight,
.
)
and then mean of that value:
Col Mean(:MinWeightVal, :age)
Col Mean will ignore missing values so this should work
With cars (not exactly sure how you want the data to look:
Max wt for make:
Col Max(:Wt, :Make)
Size for weight if you want it to just one row:
If(:Wt == :Max Wt for Make,:Size,"")
Same value for multiple rows, you can most likely drop some Col functions from there, but this was the easiest I came up quickly with:
:Size[Col Max(Col Max(Row(), If(:Wt == Col Max(:Wt, :Make), 1, 0), :Make), :Make)]
spit into multiple different formulas to see how it work
-Jarmo