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

  • Thread starter Thread starter h1a8
  • Start date Start date
  • Tags Tags
    Excel
AI Thread 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))
 
I have been idly browsing what Apple have to offer with their new iPhone17. There is mention of 'Vapour cooling' to deal with the heat generated. Would that be the same sort of idea that was used in 'Heat Pipes' where water evaporated at the processor end and liquid water was returned from the cool end and back along a wick. At the extreme high power end, Vapour Phase Cooling has been used in multi-kW RF transmitters where (pure) water was pumped to the Anode / or alternative Collector and...
Back
Top