Creating Graph/Chart for some Data

Hi guys,

I have never posted here before. I am in college and in a biology lab. Basically, my group did an experiment where we tested termite attraction to certain products. We pit 2 products against each other in 2 opposite chambers, put the termite in the middle, and recorded where the termite went.

Here is the data:

Day 1:
Round 1:
paint v water = paint
paint v Termite Killer (TK) = paint
paint v bleach = paint
bleach v TK = TK
bleach v water = water
TK v water = TK

Round 2:
paint v water = neither
paint v Termite Killer = TK
paint v bleach = paint
bleach v TK = TK
bleach v water = water
TK v water = TK



Day 2
Round 3: WITH TIME
paint (0:00) v water (0:00) = unresponsive
paint (0:00) v Termite Killer (4:37) = TK
paint (0:00) v bleach (1:41) = bleach
bleach (0:00) v TK (4:50) = TK
bleach (0:00) v water (0:00) = unresponsive
TK (4:15) v water (0:24) = TK

Round 4: WITH TIME
paint (0:00) v water (0:00) = unresponsive
paint (0:10) v Termite Killer (4:24) = TK
paint (0:00) v bleach (1:15) = bleach
bleach (0:00) v TK (4:36) = TK
bleach (0:00) v water (0:00) = unresponsive
TK (4:21) v water (0:00) = TK


The times for Day 2 were a change in our experiment. We just timed the termite for how long it spent with 1 of the products during a 5 minute period.

I was hoping I could make 2 graphs/charts/some graphical representation of my data but have no idea how. Any help?

Thanks

HI dilip, thanks for the help. I starred you.

The information is in the first post. It is the same info as in the picture. Does this make sense? If not, I can make another chart.

Thanks. I will try this. Do you know how I could create standard deviations for the averages of the data?

Thanks

Thanks for help. Solved I believe.