Bio-Rad Experion Protein Analysis Kits User Manual
Page 25
Fig. 2.4. Excel spreadsheet showing Test 2 data sorted by peak number.
8.
Insert a column between columns H and I, and label it
Exp Conc (Expected
Concentration). Enter the expected concentration for each well.
9.
Click on cell I1 (Exp Conc) and select Data > Sort to sort the data by expected
concentration (Figure 2.5).
Fig. 2.5. Excel spreadsheet showing Test 2 data sorted by expected concentration.
10. Insert 3 columns after column J, and label them
Mean Conc, Stdev, and %CV. Use
Excel software to determine the mean, standard deviation, and %CV for each set of
replicates (each concentration examined) (Figure 2.6).
Fig. 2.6. Excel spreadsheet showing example of calculation of mean, standard deviation, and %CV.
21
10010511A.qxp 2/28/2008 7:14 AM Page 21