title: Finding weighted average
body: <p>I am trying to figure out what my overall average speed is while on a bike.</p>
  <p>I have miles traveled in column 1 and then avg speed in miles per hour in column 2.</p>
  <p>The problem is that I have different distances associated with the differing speeds, so I cant juts average my all of the speeds to get an accurate average.</p>
  <p>How do I find the overall average speed, weighted, so that I have the actual avg speed?</p>
  <p>Distance
  9.82,
  8.69,
  8.43,
  9.07,
  8.16,
  12.41,
  7.22,
  3.13,
  10.28,
  9.79,
  10.44,</p>
  <p>Avg Speed
  18.4,
  12.8,
  16.7,
  18.1,
  16.2,
  19,
  13.5,
  16,
  10.9,
  16.8,
  15.6,</p>