How to compute 'special' sum

  • Thread starter KLoux
  • Start date
Hello! I am trying to find a way to compute the following in an Excel spreadsheet without the use of a macro:


Can I manipulate this into some form that would make it easier to put in Excel? I'm pretty stuck and any suggestions would be much appreciated!



[EDIT] Just wanted to make it clearer - My goal is to have some formula in one cell that references just one other cell to get the result.
Unfortunately, I do not believe a closed-form solution exists for the summation

S = 1/1^2 + 1/2^2 + ... + 1/n^2 = Sum of 1/k^2 from 1 to n.

The whole thing converges to 1.644934066848226436472415166646, or pi^2 / 6, as n goes to infinity.

What sort of accuracy do you need? You can always plot a range of it, and then fit a curve to it to make it look "close".
Ahh, I was afraid of that. I'll just write the macro.

Thanks for your help!


Want to reply to this thread?

"How to compute 'special' sum" You must log in or register to reply here.

Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving

Top Threads