Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

How to compare 20 samples?


  • Please log in to reply
6 replies to this topic

#1 acute

acute

    member

  • Awaiting Authorisation
  • Pip
  • 21 posts
0
Neutral

Posted 04 November 2009 - 03:19 AM

Hi all,
I have 20 samples and 4tests each. How can I present it in my paper? I tried the bar chart, but it seems that my samples are too many to be presented clearly.
I have found the attached chart but I donot know how to draw it.
any suggestion?
Many thanks in advance

Attached Thumbnails

  • Chart.png


#2 lab rat

lab rat

    Why does a science forum not have pictures of mice and rats?

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 245 posts
7
Neutral

Posted 04 November 2009 - 08:08 AM

What program are you using?
42..."An immutable fixed-precision number of unlimited magnitude." <a href="http://en.wikipedia....amming_language)" target="_blank">http://en.wikipedia....amming_language)</a>, accessed 25June2009.

#3 acute

acute

    member

  • Awaiting Authorisation
  • Pip
  • 21 posts
0
Neutral

Posted 04 November 2009 - 10:02 AM

What program are you using?

hi
I use excel 2007 for my statistical works, but I donot know , by what program is this chart drawed

#4 hobglobin

hobglobin

    Growing old is mandatory, growing up is optional...

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 5,545 posts
104
Excellent

Posted 04 November 2009 - 11:56 AM

Do you need all 20 samples (though I'm not sure what you mean exactly with sample and tests) shown in your graph? Why not means or medians? Box-and-whisker plots are good and have lots of information that describe the data...
You could also try to show a relationship by a correlation or regression analysis...then you have a scatter-plot and a regression line showing the relation...

Edited by hobglobin, 04 November 2009 - 11:59 AM.

One must presume that long and short arguments contribute to the same end. - Epicurus
...except casandra's that belong to the funniest, most interesting and imaginative (or over-imaginative?) ones, I suppose.

That is....if she posts at all.


#5 acute

acute

    member

  • Awaiting Authorisation
  • Pip
  • 21 posts
0
Neutral

Posted 05 November 2009 - 01:22 AM

Do you need all 20 samples (though I'm not sure what you mean exactly with sample and tests) shown in your graph? Why not means or medians? Box-and-whisker plots are good and have lots of information that describe the data...
You could also try to show a relationship by a correlation or regression analysis...then you have a scatter-plot and a regression line showing the relation...


dear hobglobin,
thanks for your reply.I have 20 patient samples and 4 treatments of a drug per each sample. therefore I need to show all samples as dots, just like the attached chart (in this chart there was 7 samples and 3 treatments). what is this type of chart called?I couldnot find it in the chart types of excel.
thanks for your suggestions

#6 almost a doctor

almost a doctor

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 244 posts
15
Good

Posted 05 November 2009 - 01:56 AM

hi acute,

I think the graphs you are showing as an example have been made on PrismGraph which in my opinion is a great program.

To do this in excel (as far as I know) you need to "trick" the program a bit, but is doable. You need to draw a Scatter plot, basically an XY graph without lines. Plot your data in different columns by treatment, and each patient data in one row (for each corresponding column). Select all your data and insert Scatter plot, the first options (just dots). You then have to select "design" and swith row/column for it to look like you want. Finally, to get your mean or median plotted you need to calculate this on excel (average or median respectively) and then edit that data series and make it look like a line rather than a dot. Also, you can edit all your data points if you'd like to, so they all just look the same.

attached is a very simplistic example of what I'm trying to say. Hope the explanation makes some sense and helps.

Cheers.

Attached Files



#7 acute

acute

    member

  • Awaiting Authorisation
  • Pip
  • 21 posts
0
Neutral

Posted 05 November 2009 - 07:12 AM

hi acute,

I think the graphs you are showing as an example have been made on PrismGraph which in my opinion is a great program.

To do this in excel (as far as I know) you need to "trick" the program a bit, but is doable. You need to draw a Scatter plot, basically an XY graph without lines. Plot your data in different columns by treatment, and each patient data in one row (for each corresponding column). Select all your data and insert Scatter plot, the first options (just dots). You then have to select "design" and swith row/column for it to look like you want. Finally, to get your mean or median plotted you need to calculate this on excel (average or median respectively) and then edit that data series and make it look like a line rather than a dot. Also, you can edit all your data points if you'd like to, so they all just look the same.

attached is a very simplistic example of what I'm trying to say. Hope the explanation makes some sense and helps.

Cheers.


many thaaaaaaaaaaaaanks
worked very well:):D




Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.