integrate in excel

Discussion in 'Math' started by praondevou, Oct 25, 2012.

  1. praondevou

    Thread Starter AAC Fanatic!

    Jul 9, 2011
    2,936
    488
    Anybody knows how to obtain a graph integrating this signal in EXCEL? The same I would get passing it through an Opamp integrator...

    I read some tutorials, but seriously, I don't get it, maybe because they are not adapted to electronics?

    Thanks

    [​IMG]
     
    • int.PNG
      int.PNG
      File size:
      12.7 KB
      Views:
      82
  2. bertus

    Administrator

    Apr 5, 2008
    15,638
    2,343
  3. HonT

    New Member

    Oct 25, 2012
    14
    2
    Can you also attach the excel file? I'll see what can be done.
     
    praondevou likes this.
  4. WBahn

    Moderator

    Mar 31, 2012
    17,715
    4,788
    To the best of my knowledge, Excel has no direct integration capability. Instead, what you would need to do is integrate the function numerically by breaking it into many small pieces (the more the better, though for some function you can get sufficiently good results with surprisingly few), calculate the area of each, and then sum them together.
     
    praondevou likes this.
  5. panic mode

    Senior Member

    Oct 10, 2011
    1,318
    304
    just use Riemann Sum, this is how integrals are defined. in this case i used right sum but about the same result is obtained using left sum (if dx is very small they become same). if you are picky, use midpoint or trapezoid.

    integral is lim of f(x)*dx where dx-->0

    if dx is not small (like in my example where x is incremented in larger steps) you get good approximation rather than exact integral. your data series has a lot of samples so your results will be even better. you will have to change what your dx or dt is to get meaningful result (otherwise you will get something that looks like integral but it is scaled wrong in y direction).
     
    Last edited: Nov 1, 2012
    praondevou likes this.
  6. panic mode

    Senior Member

    Oct 10, 2011
    1,318
    304
    ok here is an example that also includes signal that more or less looks like yours and it uses midpoint.
     
    praondevou likes this.
Loading...