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!