Hi,

I have numeric data in an excel spreadsheet that I would like to disaggregate on a categorical variable and plot the resulting sets of data as probability distributions.

The worksheet contains about 1958 rows of data. The worksheet will be disaggregated on the dependent variable called "radon" (an integer) based on the categorical variable "code" (a text field). Both are highlighted in the attached spreadsheet. This will produce several sets of rows of data (I think there are about 20+ different "code" values). For each set of rows, each set corresponding to a different code, I need to compute the median, max, min, mean, and standard deviation for that set of rows, along with a plot of its probability distribution bell curve. This will be repreated for each of the disaggregated codes (that is, one set of statistics and one plot per code). Finally, all of the plots should be placed on top of one another to allow me to observe the spread of each of the datasets.

Attach is a spreadsheet with the data.

Thanks!

TC

expertexchange-radon-vs-code.xls