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

Normal distribution in excel

  1. Jan 26, 2005 #1
    For my lab i have to use my data that i recorded in excel and for that into a chart. The thing is, i have no clue where to even start. The chart is supposed to have the avg at the top of the curve and the standard deviations to the left and right of the avg. On the Y-axis is supposed to be the "Number of Operations" and on the X-axis is supposed to be x(cm). I attached the excel file on here.
    Please help me!

    Attached Files:

  2. jcsd
  3. Jan 26, 2005 #2
    To make a chart, click "Insert", "chart" and follow instruction. For the rest, try using "help" on the menu bar, type in "average" etc.
  4. Jan 26, 2005 #3
    i already tried messing with the chart millions of times
  5. Jan 26, 2005 #4
    Make your leftmost column, your x-axis. If by "number of operations", you mean i, put that next (this will be your y-axis). Highlight those two columns, data only, including the name of the columns. Then "insert", "chart, "XY scatter", next, next, name your axis, "as new sheet", "finish". To type something in the graph (avg, std dev etc.), type in the bar below the menu and press Enter, the text will appear in the graph.
  6. Jan 26, 2005 #5
    i already tried doing that. I'm supposed to have a distribution curve thing for the graph. So the top most peak will be my avg and it will look like an upside down V.
  7. Jan 27, 2005 #6
    here's the sample model

    Attached Files:

  8. Jan 27, 2005 #7
    Well apparently, your own data doesn't look like that. Your data tells me you measured the length of something 25 times, and that each time you measured it, it was longer than the previous time. Is that what happened? What exactly is the experiment about?
  9. Jan 27, 2005 #8
    Basically had a peice of carbon paper and graph paper on the floor. We rolled a ball off the table 25 times trying to hit this line. We are supposed to measure the distance of the ball hits and graph the average and show the standard deviations.
  10. Jan 27, 2005 #9
    Oh I see. Your columns are not right. What you need to do is count the number of "11cm" you have. You have 2, so your first row is then (11,2), then count the number of "12cm", you have 1, so (12,1). Your data points should be:


    You'll have a small bell-curve with this, with a very high std dev..
  11. Jan 27, 2005 #10
    OOOHHHH, ok cool! Thx a lot man! i owe ya!
  12. Jan 27, 2005 #11


    User Avatar
    Science Advisor

    What you really want to do is to create a histogram of your data (frequency distribution). You can do that a few ways. Excel has a data analysis add-in that you should have. If you got to TOOLS...Add-ins and then look for Data Analysis Package and make sure there is a check mark next to it. If you don't, check it and then click OK.

    Once you have the add-in you can simply go to TOOLS, Data Analysis. It will bring up a dialog box with a bunch of options, one of which is Histogram.

    Once you pick that the histogram, the rest should fall out for you. If you have any problems, look up the histogram tool under the help menu.
  13. Jan 27, 2005 #12
    thx i will have to try this too!
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook