Charting Statistical Distributions in Excel 2008

[Ed]

I've been able to chart in Excel 2008 for a Normal Curve using the
NORMDIST function and other calculated cells. It is a thing of beauty.

I'd also like to draw continuous data charts with negative and
positive skews, F Distributions, t Distributions, and Chi-Square
Distribution. Does anyone know how I might do this things. I've search
online and haven't not found what I need.

Thanks,

Ed

 

[Mike Middleton]

Ed -

The NORMDIST function provides both the height of the density function f(x)
and the cumulative function F(x). So, it's easy to obtain the bell-shaped
curve (by entering many values of x, using the function to get the
corresponding height f(x), and creating an XY Scatter chart type).

Unfortunately, the FDIST, TDIST, and CHIDIST functions provide only the
cumulative function. To approximate the density, you could use
equally-spaced x values (..., x17,x18,...)and compute the difference between
successive cumulative function values (...,F(x18)-F(x17),...). Then create
the plot.

- Mike

http://www.MikeMiddleton.com