Needed: A Quick Integration Routine

  • Thread starter Thread starter Mike Connolly
  • Start date Start date
M

Mike Connolly

Hi All,
I offten want to get an integrated average value of some time / temperature
data. Time is usually in col 1 and temps are in the other columns. I'd
like to select an arbitrary period of time /temperatures points and find the
intgrated average temperature value. Does someone have a good way of doing
this, perferably with worksheet functions but some VBA code would also work
?

Thanks,
Mike
 
Are you using the word 'integration in the mathematical sense?
My site (ExcelTips) has an example of using the trapezoid rule to do a
numerical integration
My book has further examples
 
Back
Top