Creating excel function/formula to automatically calculate aggregate median, range, and studies.

Hello,   I would like to seek your support to answer another query if possible. The excel community's support has been extremely helpful to making it more efficient and really fascinating to learn ...