# Normal distribution in excel

1. Jan 26, 2005

### maverick99

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.

#### Attached Files:

• ###### physics.zip
File size:
2.7 KB
Views:
58
2. Jan 26, 2005

### Gonzolo

To make a chart, click "Insert", "chart" and follow instruction. For the rest, try using "help" on the menu bar, type in "average" etc.

3. Jan 26, 2005

### maverick99

i already tried messing with the chart millions of times

4. Jan 26, 2005

### Gonzolo

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.

5. Jan 26, 2005

### maverick99

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.

6. Jan 27, 2005

### maverick99

here's the sample model

#### Attached Files:

• ###### physics.JPG
File size:
24.2 KB
Views:
101
7. Jan 27, 2005

### Gonzolo

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?

8. Jan 27, 2005

### maverick99

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.

9. Jan 27, 2005

### Gonzolo

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:

(11,2)
(12,1)
(13,1)
(14,0)
(15,0)
(16,0)
(17,2)
...
(25,3)
...
(34,1)

You'll have a small bell-curve with this, with a very high std dev..

10. Jan 27, 2005

### maverick99

OOOHHHH, ok cool! Thx a lot man! i owe ya!

11. Jan 27, 2005

### FredGarvin

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.

12. Jan 27, 2005

### maverick99

thx i will have to try this too!