Bell Curve in Graph formatting

[eroth76]

I was taught how to graph a bell curve in a basic bar graph. But at the end, when I formatted the Y-axis scale a bit smaller (0-20 instead of 0-25, the shape of my bell curve stayed exactly the same and did not change with my data. It seems to be a scaling issue with the seconadry axis along the right side of the graph (in which i hid the markers). I know this is difficult to explain...any ideas?

 

[Mark W.]

Apply a scaling factor to your data...

Book1
	A	B	C	D	E	F	G	H	I	J
1	X	Y		0.8
2	-3	0.003545
3	-2	0.043193
4	-1	0.193577
5	0	0.319154
6	1	0.193577
7	2	0.043193
8	3	0.003545
9
Sheet2

 

[eroth76]

Mark W-

Is the scaling factor *.08 in my NORMDIST formula? Is that an example or do I really use *.08?

Thanks, an amatuer....

 

[Mark W.]

On 2002-10-16 14:09, eroth76 wrote:
Mark W-

Is the scaling factor *.08 in my NORMDIST formula? Is that an example or do I really use *.08?

Thanks, an amatuer....

I just used NORMDIST to generate some values. Use your own values. I used 0.8 (or =20/25) as a scaling factor since you seemed interested in that reduction.

The point is: You affect the scaling in your data -- not via the Y-Axis Scale setting.
This message was edited by Mark W. on 2002-10-16 14:22