I am a biochemist and I am wanting to be able to plot immunoassay (ELISA)
data. In particular I want to be able to produce standard curves using a
4-parameter logistic curve fit and read the values of 'unknown' samples from
the curve.

Hi there! As a biochemist, I understand your need to plot immunoassay data and produce standard curves using a 4-parameter logistic curve fit. Here's a step-by-step guide on how to do it in Microsoft Excel:

1. First, you need to enter your standard curve data into Excel. This should include the concentration of your standard solutions and their corresponding absorbance or optical density (OD) values. Make sure to label your columns appropriately.
   
2. Once you have your data entered, select the entire dataset and click on the "Insert" tab at the top of the screen. From there, select "Scatter" and choose the scatter plot with smooth lines and markers.
   
3. Next, right-click on one of the data points on the chart and select "Add Trendline". In the "Format Trendline" window that appears, select "Logistic" as the trendline type and make sure the "Set Intercept" and "Display Equation on Chart" boxes are checked.
   
4. Click "Close" to apply the trendline to your chart. You should now see a curved line that fits your data points.
   
5. To read the values of unknown samples from the curve, simply plot their OD values on the same chart and use the trendline equation to calculate their corresponding concentrations. To do this, click on the chart to select it and then click on the "Layout" tab at the top of the screen. From there, select "Trendline" and then "More Trendline Options". In the "Format Trendline" window, check the box next to "Display Equation on Chart". The equation will appear on the chart and you can use it to calculate the concentrations of your unknown samples.

That's it! With these steps, you should be able to plot your immunoassay data and produce standard curves using a 4-parameter logistic curve fit in Microsoft Excel. Let me know if you have any questions or if there's anything else I can help you with.

I can show you how to fit a logistics curve using Solver - Write to my
private email - I
Also try Google with <ELISA curve and with <ELISA logistic Excel
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"trevor g" <trevor wrote in message
...
I am a biochemist and I am wanting to be able to plot immunoassay (ELISA)
data. In particular I want to be able to produce standard curves using a
4-parameter logistic curve fit and read the values of 'unknown' samples
from
the curve.

Try http://www.myassays.com/four-parameter-fit.assay

This has everything you need to do a 4PL with standards and unknowns and it's free. Also, there is an Add-in for Excel available at http://www.myassays.com/introducing-excel-add-in.html


On Tuesday, January 30, 2007 5:55 AM trevor wrote:

I am a biochemist and I am wanting to be able to plot immunoassay (ELISA)
data. In particular I want to be able to produce standard curves using a
4-parameter logistic curve fit and read the values of 'unknown' samples from
the curve.


On Tuesday, January 30, 2007 12:43 PM Bernard Liengme wrote:

I can show you how to fit a logistics curve using Solver - Write to my
private email - I
Also try Google with <ELISA curve and with <ELISA logistic Excel
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"trevor g" <trevor wrote in message
...

Hi Trevor,

I know this a "bit" late as a reply. But I hope this can help you and others who landed here. We have a FREE, easy to use online tool for ELISA analysis at www.readerfit.com. It is able to fit your standard curve with 4-parameter logistic and 5-parameter logistic as well. If you come to our site, we have great email/live support where we can walk you through a typical analysis.

Charles Ma
Technical Support
Hitachi Solutions America, Ltd.
MiraiBio Group
Website: http://www.MiraiBio.com

===
Check out our new online free ELISA analysis tool at http://www.ReaderFit.com
===

Hi Trevor,

I think IVDfit may be something for you. IVDfit is an Excel add-in. It can do 4PL and 5PL and it is specially made for ELISA data. You can also calculate your unknowns with it. It can be downloaded at www.ivdtools.com