you want to calculate the average for a column of figured you then want to present some findings to your colleague in a chart which type of productivity software would you work best in this solution
I think the best type of productivity software to use would be Microsoft Excel because you can input figures/data and generate various graphs and charts based upon it.