How to do a finite series in Excel in one row?

  • Thread starter Thread starter h1a8
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
The discussion revolves around calculating the sum of a specific mathematical expression in Excel, specifically the sum of the cube root of the exponential of the sine of the arctangent of a logarithmic function from x=1 to x=1,000,000. The solution involves using the "=SUMPRODUCT" function combined with the "ROW" function to generate the range for x. The final formula provided is: =SUMPRODUCT(POWER(EXP(SIN(ATAN(LN(3*POWER(ROW(1:1000000),2)+2*ROW(1:1000000)-3)))),1/3)). This effectively computes the desired sum over the specified range.
h1a8
Messages
86
Reaction score
4
I totally forgot how to do this (it's been a long while). I'm thinking it was "=sumproduct" feature? Anyway I'm trying to find the sum of cuberoot(exp(sin(arctan(3x^2+2x-3))))) from x=1 to x=1,000,000 in excel. I believe you input ranges for the variable x. I'm not sure. I accidentally deleted my work.
 
Last edited:
Computer science news on Phys.org
nvm, i figured it out.
I use "=SUMPRODUCT". In the place of "x" just put "ROW(1:1,000,000)"
So for Sum([e^sin(atan(ln(3x^2+2x-3)))]^(1/3),x,1,1,000,000) just do:

=SUMPRODUCT(POWER(EXP(SIN(ATAN(LN(3*POWER(ROW(1:1000000),2)+2*ROW(1:1000000)-3)))),1/3))
 
A new phenomenon is AI-generated news videos pretending to be by well-known professors Jeffery Sachs and John Mearsheimer. The amazing thing is that they both seem very tolerant of this. Youtube will block these if they request it but this has been going on for months and such blocks never seem to happen. The other surprise is that while they may be visually ugly or even grotesque the news analysis is quite good. If given the sound alone I don't believe I could tell it from the real...

Similar threads

  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 5 ·
Replies
5
Views
499
  • · Replies 2 ·
Replies
2
Views
12K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 7 ·
Replies
7
Views
564
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
14K
Replies
4
Views
2K
Replies
9
Views
2K
  • · Replies 1 ·
Replies
1
Views
5K