View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How to do numerical integrarion in Excel

A1=Starting value
A2=End value
Example function:
f(x) = x+20

=((A2-A1)/6)*((A1+20)+4*((A1+A2)/2+20)+(A2+20))

The trick is inputting the function correctly.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dee" wrote:

I need to implement the Simpson's rule for numerical integration using Excel
hence determining an approximate solution