How to display statistical result considering the batch effect in triplicate experiment.

[Yeonkyu]

Hi 

I'm struggling with displaying statistical result of triplicate experiments. 

I've done treatment to cells three time(three batch).

As I just made an average of these three data, the tendency follows the most odd one. 

So I want to make the statistical result considering batch effect and display the result in graph. 

May I ask for the code? 

Following is the usual sas code I use. 

data test1;
input extract$ cellviability;
cards;

a 104.9455984
a 97.67556874
a 94.78239367
a 100.049456
a 98.71414441
a 103.8328388

b 53.23936696
b 51.31058358
b 61.69634026
b 65.25717112
b 43.00197824
b 64.44114738

c 47.30464886
c 47.23046489
c 46.26607319
c 53.83283877
c 50.04945598
c 48.78832839

d 17.77942631
d 12.8090999
d 12.58654797
d 13.77349159
d 13.47675569
d 15.55390702

e 3.165182987
e 3.610286845
e 3.536102868
e 3.461918892
e 4.352126607
e 2.72007913
run;
proc anova;
class extract;
model cellviability=extract;
means extract;
means extract/duncan;
run;

Following is the usual graph I use. Making the graph by excel according to SAS result.

Following is my data. 

[Ksharp]

You really should post it at ODS Graphic forum. It is not about Stat question,it is about Stat Graphic.



data test1;
input extract$ cellviability;
cards;
a 104.9455984
a 97.67556874
a 94.78239367
a 100.049456
a 98.71414441
a 103.8328388
b 53.23936696
b 51.31058358
b 61.69634026
b 65.25717112
b 43.00197824
b 64.44114738
c 47.30464886
c 47.23046489
c 46.26607319
c 53.83283877
c 50.04945598
c 48.78832839
d 17.77942631
d 12.8090999
d 12.58654797
d 13.77349159
d 13.47675569
d 15.55390702
e 3.165182987
e 3.610286845
e 3.536102868
e 3.461918892
e 4.352126607
e 2.72007913
;
run;
proc sgplot data=test1;
vbar extract /response=cellviability LIMITSTAT=stddev stat=mean datalabel;
run;