In excel, using Open Calc but I assume they're the same.
Is their a way to put variables value into summing formulas. I wanted to sum from A1 to an A cell which is numbered A1+F4. So if F4 = 100 I'd want to SUM(A1:A101)
I tried SUM(A1:A(1+F4)) but it gives a number error
Had an attempt at the Taylor series and it looked like it was just going to make it more complex. I've plotted it in excel and get a nice semi-ellipse then I'll just use simpsons rule to solve for the area.
Homework Statement
Trying to solve a Lagrangian, got down this integral. Unfortunately the zeroth-solution isn't good enough since the constant k is close to 1 for our experimental set-up.
\int_{0}^{x}dx(\frac{xsin(x)}{1+kcos^2(x)}})^\frac{1}{2}
Any hints? I'm not sure where to get...
Homework Statement
Context is cosmology but not really relevant to the integration.
I've managed to integrate it using substitution but it didn't seem that neat. Coming back after two-years off and I'm a bit rusty at spotting the best substitutions (wasn't great to start with :))...