• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Does Excel 2000 do numerical integration?

S

Sukhoi

Elite Member
I think I remember hearing that it does, but I can't find the function for it. 🙁😱 Am I mistaken here?
 
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.
 
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.
 


<< 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.
 
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.
 
Yes. After the 1978 Supreme Court decision, all the black numbers had to be bussed to the white number's schools and vis-versa.
 
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.
 
That is quite simple after thinking about it. 😱🙂 I already got the project done and turned in so it doesn't matter anymore. hehe
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top