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))
 
Thread 'ChatGPT Examples, Good and Bad'
I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...

Similar threads

  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 5 ·
Replies
5
Views
612
  • · Replies 2 ·
Replies
2
Views
12K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 7 ·
Replies
7
Views
715
  • · 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