Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Microsoft excel help

  1. Apr 24, 2007 #1
    this is rather embarrassing, but it's late, i have a headache and can't figure this out.

    so i have this complicated function i need to sum (not sum as in add up - sum as in sum a series).
    my formula that needs to be summed:
    (2/(n*pi))*sin(n*pi*z/L)*e^(-(n^2)*pi*pi*k*t/(L^2))

    pi, z, L, k, t are constants, i want sum n from 1 to 10... i looked through all the "sum" functions but i couldnt find a summation in which i could enter a function to be summed.

    help?
    Thanks
     
  2. jcsd
  3. Apr 25, 2007 #2

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    Set the first column to the numbers 1 thru 10, then in the second column, set up your formulas for each n and sum down the column.
     
  4. Apr 26, 2007 #3
    So, I was waiting for somebody to say it... :)

    In my opinion, spreadsheet is a braindead tool for any computation past what you'd jot on a piece of paper in a grocery store. If one doesn't intend to compute anything more complicated than that in the nearby future, spreadsheet might be a reasonable way to go.

    Otherwise, I recommend switching to a tool that could support exactly what OP originally had in mind (passing one function to another), and, say, doesn't require more than flicking one number in order to increase or decrease the number of terms in the summation. Which would be just about any tool, e.g. the ubiquitous Matlab.

    --
    Chusslove Illich (Часлав Илић)
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Microsoft excel help
  1. Excel Macros (Replies: 3)

  2. An Excel question (Replies: 4)

  3. Anti-Microsoft rant (Replies: 6)

Loading...