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

Homework Help: Standard Deviation (bell graph) in excel

  1. Feb 19, 2010 #1
    1. The problem statement, all variables and given/known data

    1. The problem statement, all variables and given/known data

    Hello everyone!
    I have been having trouble with cumulative frequency graphs in excel for some time now. I wonder how you make the "bell graph" or cumulative frequency graphs or standard deviation graphs in microsoft excel. I have excel for mac. I know how to find the mean and the standard deviation but i dont know how to express all the results in a graph.
    I have 80 different measurements of cone populations and i would like to express them.

    Please guys and girls, i wonder how i go about in doing this?

    -Niklas

    2. Relevant equations



    3. The attempt at a solution

    I have tried to organize it according to frequency but cant seem to arrange it in the right order, as said i can find mean and sd.
    2. Relevant equations



    3. The attempt at a solution
    1. The problem statement, all variables and given/known data



    2. Relevant equations



    3. The attempt at a solution
     
  2. jcsd
  3. Feb 19, 2010 #2
    I dont know if this is the right place to post this but i assumed so. If not please tell me where.

    Niklas
     
  4. Feb 20, 2010 #3

    LCKurtz

    User Avatar
    Science Advisor
    Homework Helper
    Gold Member

    If you have access to usenet, there is a very helpful forum microsoft.public.excel. Also Microsoft has an excel board at msnews.microsoft.com called m.p.excel. You will almost certainly get an answer in hours, especially at the microsoft one.
     
  5. Feb 20, 2010 #4
    Thank you, i will look into it!
     
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook