# integrate in excel

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

1. ### praondevou Thread Starter AAC Fanatic!

Jul 9, 2011
2,936
489
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

File size:
12.7 KB
Views:
82

Apr 5, 2008
15,806
2,389
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
18,088
4,917
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,329
305
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).

• ###### integral.zip
File size:
10.1 KB
Views:
12
Last edited: Nov 1, 2012
praondevou likes this.
6. ### panic mode Senior Member

Oct 10, 2011
1,329
305
ok here is an example that also includes signal that more or less looks like yours and it uses midpoint.

File size:
11.8 KB
Views:
17
• ###### integral2.jpg
File size:
52.6 KB
Views:
13
praondevou likes this.