使用列号计算列中数字的平均值

I am trying to find a way of calculating the average of numbers in a column using the column's number. For example, I know that the average of numbers in column E can be obtained using the formula AVERAGE(E:E), but what if I need to use the column number (in this case 5) to calculate that average?I am trying to find a way of calculating the av