| 查看: 1667 | 回复: 4 | |||
yyc12596新虫 (著名写手)
|
[交流]
ELISA standards curve(excel做elisa的标准曲线)
|
|
from: http://blog.sina.com.cn/s/blog_721358b20100ou1f.html Step 1. After Optical Densities (ODs) have been collected, enter each standard OD into a worksheet as shown. Step 2. Take the averages of the duplicate values either by adding them up and dividing by two on a calculator, or entering the formula =AVERAGE(A2+B2). Note: change the cell location from A2 and B2 to the desired cell location of each Standard OD. Step 3. Enter the Standard concentrations that each OD should represent next to their corresponding OD average. Creating a Standard Curve Step 1. Highlight your data range and click on the "Chart Wizard" icon in the excel tool bar. Step 2. Choose XY (Scatter) and click "Next" Step 3. Click on "Series" located at the top of the Chart Wizard Window. Make sure that your X Values are your concentrations and your Y values are your Average OD values. Name your Series or add another Series if you want to compare Standard Curves Click "Next" Step 4. Add information to your chart such as titles and axis labels. Once you customize the chart to your preferences, click "Next". Step 5. Place your chart on a new Excel sheet or insert into your current worksheet. Step 6. Double click on the x-acis values and a "Format Axis" window will pop up. Click on the "Scale" tab on the top of the window. Check the "logarithmic scale" box. Step 7. Do the same to the y-axis Step 8. Highlight data points by clicking on one of them. Click on the "Chart" tab and on the top menu bar click on "Add Trendline". Step 9. A "Add Trendline" window will appear. Select Linear under "Trend/Regression type". Step 10. Go to the "Options" tab on the top of the window and Select "Display equation on chart" and "Display R-squared value on chart" Step 11. Click "OK" to view your chart with equations. Analyzing Data Now that you have your equation, you can solve for "x" and enter your sample OD values as Y. You can do this by using a calculator and manually solving for "X" or by inputing a formula as shown. Use Excel Equation: y=0.062x+0.1579 Enter Formula: =(G7-0.1579)/0.0062) where G7 is your OD value (select the appropriate cell for your data) Note: Linear regression on Excel should only be used if software that can create a 4-Parameter (4-PL) logistic curve fit is unavailable. Please keep in mind that values that are represented at the low end of your curve will not be as reliable as values at the higher end of your curve. |
» 猜你喜欢
logP 6.1 的羧酸怎么配母液:GSK 650394 的溶解窗口与稀释顺序
已经有0人回复
从"水不溶"到 71 mg/mL:雷特格韦的 pH 依赖溶解与螯合色谱边界
已经有0人回复
化学工程及工业化学论文润色/翻译怎么收费?
已经有209人回复
133 Ų 的极性表面积,如何决定 TNG462 的母液配制与色谱条件
已经有0人回复
两个氟原子与一段氨基甲酸甲酯:BLU-5937 的母液配制与稳定性边界
已经有0人回复
司美那非(TPN171):从嘧啶酮母核到工艺放大的结构、色谱与质控参数解析
已经有0人回复
同一瓶粉末,核磁却跑出两套峰:PF-07976016 的结构与母液笔记
已经有0人回复
诚挚招收全日制博士!!!中国农业科学院麻类研究所谭志坚研究员课题组招收博士
已经有23人回复
从片段筛选到公斤级工艺:PF-07293893 的 γ3 选择性结构解析
已经有0人回复
从噁唑酮母核到分子胶界面:BMS-986482 的结构、色谱与质控参数解析
已经有0人回复
yyc12596
新虫 (著名写手)
- 应助: 10 (幼儿园)
- 金币: 10852.3
- 散金: 2230
- 红花: 34
- 帖子: 2271
- 在线: 355.1小时
- 虫号: 2034994
- 注册: 2012-09-28
- 性别: MM
- 专业: 血液系统疾病诊疗新技术
2楼2013-10-04 13:53:56
yyc12596
新虫 (著名写手)
- 应助: 10 (幼儿园)
- 金币: 10852.3
- 散金: 2230
- 红花: 34
- 帖子: 2271
- 在线: 355.1小时
- 虫号: 2034994
- 注册: 2012-09-28
- 性别: MM
- 专业: 血液系统疾病诊疗新技术
3楼2013-10-08 09:12:06
yyc12596
新虫 (著名写手)
- 应助: 10 (幼儿园)
- 金币: 10852.3
- 散金: 2230
- 红花: 34
- 帖子: 2271
- 在线: 355.1小时
- 虫号: 2034994
- 注册: 2012-09-28
- 性别: MM
- 专业: 血液系统疾病诊疗新技术
4楼2013-10-08 09:14:06
yyc12596
新虫 (著名写手)
- 应助: 10 (幼儿园)
- 金币: 10852.3
- 散金: 2230
- 红花: 34
- 帖子: 2271
- 在线: 355.1小时
- 虫号: 2034994
- 注册: 2012-09-28
- 性别: MM
- 专业: 血液系统疾病诊疗新技术
|
Standards OD2 AVE-OD OD-Blank Concentrations 98XXXXX 98XXXXX 9855480 9577760 250 632XXXX 620XXXX 6264305 5986585 125 380XXXX 380XXXX 3804495 3526775 62.5 226XXXX 222XXXX 2243600 1965880 31.25 134XXXX 131XXXX 1329150 1051430 15.6 840XXX 810XXX 825535 547815 7.8 555XXX 567XXX 561300 283580 3.9 277XXX 278XXX 277720 0 0 这个是比较稳定的标准曲线值了。 |
5楼2013-10-08 09:24:40










回复此楼