Compute Mean, Median & Mode of 1D Array

In VBA:
- Are there any in-built array functions to compute Median, Mode and Mean values of one-dimensional integer arrays?
- If not, is there a simple way of computing these, without copying values to the worksheet cells?
- Also, is there a simple way to sort Array elements in ascending or descending order? i.e. return a sorted array.