[R] creating standard curves for ELISA analysis

Thu Dec 25 16:26:46 CET 2008

Thank you for your suggestions,  I am sorry that 
http://www.nabble.com/file/p21168216/ds2_panelA_p8_B3_dil4x.csv
ds2_panelA_p8_B3_dil4x.csv I forgot to include the concentration of Standard
to use. the first standard (A1, A2) is 67000 and dilution series is created
by diluting it 1/3. i am reposting the full Absorbance data once again to
have a full idea about the output file created by the ELISA software. I am
also uploading the sample file for a better understanding,  serum samples in
this case are diluted 4 times

Location	 Sample	ENA-78(37)	FgF(54)	G-CSF(58)	GM-CSF(71)	IFNg(75)	IL-10(50)
IL-17(20)	IL-1b(6)	IL-1ra(16)	IL-2(17)	IL-4(21)	IL-5(09)	IL-6(32)	IL-8(36)
MCP1(78)	MIP-1a(59)	MIP-1b(74)	TNFa(77)	VEGF(52)
A1	s1	6923	12667.5	4644	3247	11878	11648	4142.5	6536.5	5409	7057.5	5146
10921	5437	7968	6590.5	11497.5	8358	8088.5	7721
B1	s2	4093	9680	2535.5	2000.5	8392	7017	2135	3913	3162	4226.5	2757	8132.5
2907	6416	6216	8332	5625.5	4364	4225
C1	s3	1689.5	4586	929	1020	4313	3549.5	961.5	2220.5	992	1585	1289.5	4309
1294	3748	4315	2780.5	2504	2043	1268
D1	s4	642	1440	352	418	1769	1327.5	318.5	824	409	528	399	1384	664	1693	1461
651	803	576.5	720
E1	s5	228.5	319.5	141	143	741	590.5	170	385	155	230	114	503.5	218	701	493
237	245	236	320
F1	s6	94	42	65	67	301	271	60	147	78	99.5	28	156.5	106	397	128	74	65	108	154
G1	s7	43	11	36	36	109	94	30.5	60.5	39	52	8	48	28	163	39	46	28	37	73.5
H1	b	15	2	12	15	7	4	3	4	19	6	2.5	0	0.5	78	23	12	16.5	3	30
A2	s1	6317	12543.5	4743	3757	10073.5	11016	4432	6990	5019	6687	4578	9856
5589.5	7265	6533	11368.5	7486	7503	7823
B2	s2	4487	9343.5	2114	2029	8300	6541	2027.5	4099	2986.5	3826	2857	7192.5
3197	5786	6386	7741	5086.5	4560.5	4409
C2	s3	1577	4024.5	942	1041	4035	3093.5	1098	1943	1133	1672	1263	3706	1421
3223	3729	2681	2065	1717	1453.5
D2	s4	609	1371.5	366.5	421.5	1884	1397	361	944	422	631	496	1442	535	1646
1523	766	791	718	723
E2	s5	234	304.5	143	165	760	541.5	160	358.5	163.5	249.5	111	459	222.5	765
416	188	215	235	281
F2	s6	90	44	64	68	268.5	218	55	135	73.5	102	25	140	101	304	104	72.5	57	87
120.5
G2	s7	39	9	34	35	90	90	31.5	57	38	47.5	9	42.5	25	133	38	42	29	33	70.5
H2	b	12	1.5	14	12	8	5	3	5	15	5	1.5	0	0.5	79.5	23.5	8	15	1	33
A3	1	683	5	23	23	16	10	16	9	66	10	6	4	12	653	641.5	23	22	14	182.5
B3	2	523	7	23	18	19.5	11	11	16	59.5	15.5	6	2	8.5	1789	369.5	26	28	16	140
C3	3	686.5	4	26	18	12	6	15.5	18.5	118	17	4	2	10	2040.5	714.5	20	28	17.5
123.5
D3	4	1640.5	5	71	17	17	9	13	16	564.5	13	5	4	18	1258	957	31	164	24.5	291
E3	5	158.5	5	34.5	20	15.5	8	13	13.5	75	13	4.5	4	50.5	1075	330	20.5	23	11	87
F3	6	862	5	21	22	18	10	14.5	12	58	18	4	2	7	2207	555.5	23	27	19	124
G3	7	710	6	30	16.5	19	6	13	14.5	105	17	6	2	12	1755.5	557	23	32	13	135
H3	8	1047	4	41	20	16	10.5	14	12	111	11	4.5	4	10.5	1690.5	404.5	23	50.5	23
212
A4	9	512.5	6.5	22	22	18	11	11	30	167	13	4	3	5	2729	1420	37	48	18	333
B4	10	979.5	5	20	27	19	2	18	15	122	14	4	2	7	1581	496	18	35	20	94
C4	11	270	6	23	20.5	19.5	9	14.5	68	656	15	3	4	79	5995	2964	50	40.5	17	198.5
D4	12	207	4	27	21	19	10	14	11	39	16	5	3	6.5	1622.5	311	25	25	15	181
E4	13	367	7.5	25	21	19	12	10	13	50	12	7	1	8.5	1395.5	718.5	24	30	19	219
F4	14	462	5	23	20	19	7.5	14	10	107	14	4	0	10	1715.5	484.5	23	22	19	265
G4	15	441.5	5	19	20	18	7	16	29	271	12	5	1	10	6917	6325	24.5	32	15.5	156
H4	16	521	7	38	22	18	10	14	11	164	16	4	3	23	1967	744	25	34.5	15	202
A5	17	759	5	18	21	16.5	10	10	10	55	11	4	1.5	16	1731.5	752	19	30	12	288
B5	18	624	6	22.5	20	21	12.5	11	12	52	12.5	4	2	8	2329.5	533	23	30.5	15	125
C5	19	735	5	21	19	14	10	17	11.5	291.5	9	5	3	10	773	1682.5	26	33	17.5	67
D5	20	450	5	25	16	15.5	8	17	12	65	12	5	3.5	9	1970	335	20	23	14	110
E5	21	405	5	21	18	14	7	12	10	139	13.5	5	0	8.5	1318	433	25.5	33.5	14	89
F5	22	155	3.5	12.5	10	12	4	35	6	24	4.5	3	2	8.5	391	257	19	114.5	8	104
G5	23	472	6	23	17	18	6	12	38.5	348	11	3	2	7	2764	1612	39	967	20	197
H5	24	326	5.5	20	19	17	7.5	13.5	11	44	13	5	3	66	1579	272.5	24	24	13	152.5
A6	25	341	5	24	22	15	8	13.5	13	68.5	12	4	2	7	1591	483	22	34	11	84
B6	26	460.5	5	21	23	16	10	11	160	677.5	11	5	2	23	5326	1495	46.5	62	19	138
C6	27	454	4	32.5	16.5	15	9	10.5	14	104.5	10.5	3	1	50	1468	1459	25.5	38	17
142
D6	28	604	6	27	18	16.5	7	14.5	37	950.5	12.5	5	4	14	5643	5980	24	36	18	324.5
E6	29	491	7	22.5	18	19	8	13.5	23	240	17	4	1	11	3802.5	1902	30.5	47.5	20	297
F6	30	414	4	24.5	20	20.5	9	13	14	39	16	3	3	6	1384.5	585.5	23	32	13	95
G6	31	423	5.5	21	19.5	19	9	16	299	1428	15	5	2	49	6343	6018	160.5	335	11.5
211
H6	32	286	6	28	18	10	9	14	13	108	13.5	3	2	27.5	1369	808	20	32	237	70
A7	33	874.5	6	23.5	20	16	8	12.5	65	588	6	5.5	3	17	5915	5098	36	81	23	229
B7	34	1211	3	23	20	16	33	12	9.5	78	9	4.5	2	8	2097	693.5	16.5	28	13	274.5
C7	35	257	4.5	25.5	17	16.5	9	12	10	52	10	5	3	7	1456	750	24	23	11	70.5

Thanks for the help

1Rnwb wrote:
> 
> Hello R guru's
> 
> I am a newbie to R, In my research work I usually generate a lot of ELISA
> data in form of absorbance values. I ususally use Excel to calculate the
> concentrations of unknown, but it is too tedious and manual especially
> when I have 100's of files to process. I would appreciate some help  in
> creating a R script to do this with minimal manual input. s A1-G1 and
> A2-G2 are standards serially diluted H1 and H2 are Blanks. A3 to H12 are
> serum samples. I am pasting the structure of my data below:
> 
> 
> 
> A1		14821
> B1		11577
> C1		5781
> D1		2580
> E1		902
> F1		264
> G1		98
> H1		4
> A2		14569.5
> B2		11060
> C2		5612
> D2		2535
> E2		872
> F2		285
> G2		85
> H2		3
> A3		1016
> B3		2951.5
> C3		547
> D3		1145
> E3		4393
> F3		4694
> G3		1126
> H3		1278
> A4		974.5
> B4		3112.5
> C4		696.5
> D4		2664.5
> E4		184.5
> F4		1908
> G4		108.5
> H4		1511
> A5		463.5
> B5		1365
> C5		816
> D5		806
> E5		1341
> F5		1157
> G5		542.5
> H5		749
> 
> 

-- 
View this message in context: http://www.nabble.com/creating-standard-curves-for-ELISA-analysis-tp20917182p21168216.html
Sent from the R help mailing list archive at Nabble.com.