Excel의 추세선을 이용한 표준곡선 검증

Standard Curve Validation using Trendlines in Excel

Purpose Using a regression formula of the trendline near the coefficient of determination (R2) “1” by substituting the dependent variable of the standard curve to calculate the values of the independent variable. To determine the suitability of a regression equation by comparing the difference between the independent variables of the standard curve and the predicted independent variables . Materials and Methods Perkin Elmer Gamma-Counter machine was used for Standard curve of regression methods. TSH. TG-Ag (Thyroglobulin Antigen), Insulin that used materials and method test to compare the result from the Excel trendline of the regression formula. Results Each of the value of coefficient of determination (R²) and Trendline R²=1, Polynomial Trendline for TSH , R²=1, Polynomial Trendline for TG-Ag, R2=0.9994, Polynomial Trendline for Insulin. Conclusion We confirmed that IRMA immune method is found to the nearest trends elected a standard curve using polynomial trendline . The independent variables to predict the trend by using a polynomial trendline formula containing the error was a limitation .