Hi, Thank you for all your useful suggestions and good knowledge. However, I am not a math/computer-science/software savvy, and have no access to Maple, Mathematica, etc. The tools like quadpack look all jargon to me, although it seems to be a very useful tool for many. Following your sound suggestion, I installed R with ease, but have not been able to install RExcel (that you suggested) yet, perhaps because its installation requires a chain of other packages. For now I have to move on to my other projects. But later on, I will let you know after I figure out how to install RExcel (with all its related packages, such as statconnDCOM, etc), how to use it, and how to do the integral in R, and then how to call R's integrate straight from the spreadsheet. Hi, Thank you for all your useful suggestions and good knowledge.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. The integral of (x)^(-1)dx is ln(x) + C The natural logarithm of a complex number may be evaluated. Convert the complex number to polar coordinate form and the angle remains the same but the radius from the origin is reduced to the natural log of the absolute value of the absolute value of the original radius.

However, I am not a math/computer-science/software savvy, and have no access to Maple, Mathematica, etc. The tools like quadpack look all jargon to me, although it seems to be a very useful tool for many. True crime new york city pc rip 1 link download. Following your sound suggestion, I installed R with ease, but have not been able to install RExcel (that you suggested) yet, perhaps because its installation requires a chain of other packages. For now I have to move on to my other projects. But later on, I will let you know after I figure out how to install RExcel (with all its related packages, such as statconnDCOM, etc), how to use it, and how to do the integral in R, and then how to call R's integrate straight from the spreadsheet. Best, As I've suggested, if you are interested in numerical integration you may be able to approximate fairly accurately the result using native Excel function(s). If you want to proceed with the R and RExcel installation, from the wikipedia page for RExcel: • has a master installer RandFriendsSetup which installs R, many R packages, RExcel, and the infrastructure needed to run RExcel (rscproxy, rcom, the statconnDCOM server) Tushar Mehta (MVP Excel 2000-2015) Excel and PowerPoint tutorials and add-ins www.tushar-mehta.com.

I thought it might be nice to write a function in VBA that would evaluate a definite integral, given a string that represents y as a function of x and the lower and upper limit. Here's what I came up with: Function INTEG(exp As String, min As Double, max As Double) Dim t As Double Dim x As Integer Dim range As Double Dim exparray(5000) As Double Dim dx As Double range = max - min dx = range / 5000 t = min x = 0 Do Until x = 5000 exparray(x) = Evaluate(Replace(exp, 'x', CStr(t))) * dx + 0.5 * dx * Abs(Evaluate(Replace(exp, 'x', CStr(t + dx))) - Evaluate(Replace(exp, 'x', CStr(t)))) t = t + dx x = x + 1 Loop INTEG = WorksheetFunction.Sum(exparray) End Function It works pretty well so far - it uses the trapezoid rule so it's pretty accurate. And it works with most integrated excel functions. For example: =INTEG('x^2+3*x+ln(x)',1,9) in a cell gives a value of 3. I just thought I'd share that with anyone who might be able to use it.