For my calibration curve, I have wide range of concentration, 5 ng-500 ng/ml. So, I would like to do the regression analysis of my standard curve by weighted method for regression analysis in SigmaPlot. But I have no idea how to use it. So, please help me if anyone have idea how to use it, with basic information of weighted method of regression analysis
You can find the equation for weighted linear regression in the following document:
w3.uniroma1.it/chemo/ftp/7004x0993.pdf
This is an IUPAC guideline for calibration experiments. The equation is really easy to employ, you only need Microsoft Excel or a similar application for the evaluation.
Can you recommend any statistical software that I can use for weighted regression analysis for calibration curve???
One can use Microsoft Excel to perform weighted regression.
If X-values are entered in cells A1:A5, Y-values are in B1:B5, and uncertainties of Y, u(Y), are in C1:C5, then weighted linear least squares fit, with weights W = u(Y)^(-2), can be obtained as follows:
=LINEST(B2:B5*C2:C5^-1,IF({1,0},1,A2:A5)*C2:C5^-1,FALSE,TRUE)
Note: enter the formula over a 2x2 array using ctrl+shift+enter. This also provides the regression parameter uncertainties.
- Badges
- Science method