get average value from table column

get average value from table column

by Shree Khanal

HTML

<table id="tblavg">
  <tr>
    <td valign='top'>David</td>
    <td valign='top'>A bit dry</td>
    <td valign='top'>3</td>
  </tr>
  <tr>
    <td valign='top'>Susan</td>
    <td valign='top'>I liked it</td>
    <td valign='top'>4</td>
  </tr>
  <tr>
    <td valign='top'>Richard</td>
    <td valign='top'>Had better</td>
    <td valign='top'>2</td>
  </tr>
</table>

JavaScript

var sum = 0, rows = $('#tblavg tr');

rows.each(function() {
  sum += parseFloat($(this).children('td').eq(2).text());
});

rows.each(function() {
  var tds = $(this).children('td'), 
	value = parseFloat(tds.eq(2).text());
  $(this).children('td').eq(1).text((value/sum).toFixed(3));
});