thank you...however one more question...i tried graphing the normaldist using
the name, define routines..i.e.creating a graph using formulas..

when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a
reference error..

in other words, i cannot, YET, make it work..

i believe my formulas are all entered correctly in the name, define section,
but the chart wizard will Not accept my X value.

Can you be of more assistance?

thanks

"Mangesh Yadav" wrote:

> Hi,
>
> First of all I want to clarify that this is not my site. It belongs to
> Tushar Mehta (http://www.tushar-mehta.com).
>
> I haven't checked the addin, but follow the method on his site by entering
> the range -4 to 4 in column A, you could skip column B for mean=0 and
> stdev=1. In C, enter the formula for Normdist as mentioned on the site.
>
> Now the extra part. In column D, enter
> =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0)
> or
> =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0)
> where K1 has a z value, the left of which you want the portion blackened.
>
> Now plot both the columns (C and D) in an area chart with no fill for the C
> plot, and a black fill for the D part.
>
> E.g. The cell K1 will have a z value like say -1, and in the area chart will
> have the area left of -1 blackened.
>
> Using TRUE in column C formula will give you the cummulative distribution.
>
>
> Mangesh
>
>
>
>
>
> "FLKULCHAR" <FLKULCHAR@discussions.microsoft.com> wrote in message
> news:6881BFA9-7DDA-4270-824B-1CC241FF33B0@microsoft.com...
> > I do not know who you are, but I am very impressed. I am a
> > Calculus/Statistics instructor; I only wish to apply my extensive
> > mathematical skills with EXCEL; your site is certainly great...
> >
> > Next, can you possibly help me with the (integral..under the curve)...I
> > believe we insert true...,etc?
> >
> > "FLKULCHAR" wrote:
> >
> > > I know EXCEL has functions for both the NORMAL DISTRIBUTION and the
> > > cumulative value thereof...
> > >
> > > but is it possible to graph this data..
> > >
> > > (I imagine if I sort the data and then calculate the ***. distributions
> into
> > > a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?)
> > >
> > > thank you,
> > >
> > > FLKULCHAR
>
>
>