Does Excel 2000 do numerical integration?

[Sukhoi]

I think I remember hearing that it does, but I can't find the function for it. Am I mistaken here?

 

[Sukhoi]

Bump!

 

[chansen]

It does, but you have to install that option from the CD. It's not installed by default. I always found that to be annoying.

Let me go look for where it is.

 

[chansen]

Whoops, looks like it doesn't. If you're looking for simple Trapezoid Rule or Simpson's 1/3 Rule templates, I found them here.

Alternatively, do a Google search.

 

[Nitemare]

Never heard of excel doing that before. I use maple for all my integration needs

 

[hoihtah]

excuse my ignorance...
but what is numerical integration?

 

[jpsj82]

<< excuse my ignorance...
but what is numerical integration? >>

my guess is that it is just a function that will intergrate numbers and expressions. if you don't know what an integral is, wait for calculus.

 

[Sukhoi]

Thanks for the link to that site. I tried doing a Google search last night but couldn't find too much.

I have all the answers in a chart on my TI-89, so I know what they are. I was hoping I could just put the formula into Excel and integrate it because I need to do it 32 times.

Numerical integration is just doing an integral, but using limits of integration so you get an number out rather than another function.

 

[Amused]

Yes. After the 1978 Supreme Court decision, all the black numbers had to be bussed to the white number's schools and vis-versa.

 

[dullard]

I just timed myself. I took 35.1 seconds to have Excel numerically integrate a function. Here is what I did:

1) Create a cell named dx. I gave it a small value.
2) Create a column named x. The first row had the initial integration point. The rest of the rows are equal to the row above + dx. Copy and paste until x reaches the final point.
3) Create a column named y(x). Here I typed the function I wanted to integrate.
4) Create a column named y(x)*dx. This column multiplies y(x) times dx.
5) Create a cell that sums the last column.

Learn to do it yourself, and you'd be surprized how easy it is.

 

[Sukhoi]

That is quite simple after thinking about it. I already got the project done and turned in so it doesn't matter anymore. hehe