A ANDREW MC Oct 20, 2004 #1 Are there any good websites that deal with doing descriptive statistics with Excel? Like graphing normal distributions?
Are there any good websites that deal with doing descriptive statistics with Excel? Like graphing normal distributions?
J Jerry W. Lewis Oct 21, 2004 #2 If you want a normal probability plot, Mike Middleton has a downloadable paper on this at http://www.usfca.edu/~middleton/data.htm see also http://www.peltiertech.com/Excel/Charts/ProbabilityChart.html If you want to draw the normal distribution's bell-shaped curve, see http://www.tushar-mehta.com/excel/charts/normal_distribution/ If you want to draw a histogram of actual data, there is a histogram tool in the Analysis ToolPak; see also http://www.peltiertech.com/Excel/Charts/Histograms.html http://www.peltiertech.com/Excel/Charts/Histogram.html If you want to draw a box and whisker plot of data, see http://www.peltiertech.com/Excel/Charts/BoxWhiskerH.html http://www.peltiertech.com/Excel/Charts/BoxWhiskerV.html http://www.peltiertech.com/Excel/Zips/BoxCharter.zip Look around on these sights and also www.stfx.ca/people/bliengme for other tips. Jerry
If you want a normal probability plot, Mike Middleton has a downloadable paper on this at http://www.usfca.edu/~middleton/data.htm see also http://www.peltiertech.com/Excel/Charts/ProbabilityChart.html If you want to draw the normal distribution's bell-shaped curve, see http://www.tushar-mehta.com/excel/charts/normal_distribution/ If you want to draw a histogram of actual data, there is a histogram tool in the Analysis ToolPak; see also http://www.peltiertech.com/Excel/Charts/Histograms.html http://www.peltiertech.com/Excel/Charts/Histogram.html If you want to draw a box and whisker plot of data, see http://www.peltiertech.com/Excel/Charts/BoxWhiskerH.html http://www.peltiertech.com/Excel/Charts/BoxWhiskerV.html http://www.peltiertech.com/Excel/Zips/BoxCharter.zip Look around on these sights and also www.stfx.ca/people/bliengme for other tips. Jerry
