How do I chart a distribution curve for 300 samples in four groups in Excel?

BloodCenter
BloodCenter used Ask the Experts™
on
I am doing data analysis using Excel. The data are fluorescent intensity of each sample. I have 300 samples, divided into 4 group. I’d like to compare how different among these group. I am thinking of drawing a distribution curve for each group with x-axis of fluorescent intensity and y-axis as number of samples, but I don’t know how to do it in Excel. Do you know how to do it, or is there another way to show the data?

More info: I have a chart showing four groups, Positive, Negative, False positive, and Indeterminate. Right now the x-axis is the column A on the table. I don’t really care the column A, because I want to show a chart with the distribution of fluorescent intensity over the frequency (the number of samples from all runs together).

I have attached the file.  Another way of explaining what I am trying to do is to imagine a distribution curve chart with the heights of men and women, with the Y axis being the number of people at each height, and the X axis being the heights.

Can someone please help?  Thank you!
Validate-End-Point-Fluorescent-I.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Not sure if this was what you wanted, but here goes.

On your Data worksheet I made a matrix to get counts by bucket for your data series.  For example, if starting in M2 I have the lower bound for each bucket and in N2 the upper bound (assuming lower <= X < upper), then in O2 I concatenate them into a label, and then in P2:S2 I use SUMPRODUCT to get a count:

=SUMPRODUCT((B$2:B$61>=$M2)*(B$2:B$61<$N2)*(B$2:B$61<>""))

I then made a column chart based on that matrix, on the Chart1 sheet of the attached file below.
Q-27244411.xls

Author

Commented:
Beautiful!  Thank you so much!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial