Average

no, that's not possible. you have to search your whole dataset for finding the max and the min value.

Yah if total number of variables is available. But not perfectly working for more than three or four variables.