Elisa data analysis excel4/16/2024 A 1:10 dilution of the PFS resulted in positive results for IBR, BVD and EBL. These PFS were used to simulate 18 pooled samples ranging from undiluted PFS to a dilution representing 1 positive in 1,000 animals using phosphate-buffered saline as diluent. Four positive field standards (PFS), one for each disease, were prepared by pooling highly positive herd-level samples diagnosed using commercially available ELISA tests. Therefore, this study aimed to evaluate the use of pooled serum samples as a herd-level surveillance tool for infectious production-limiting diseases: bovine viral diarrhoea (BVD), infectious bovine rhinotracheitis (IBR), enzootic bovine leukosis (EBL) and Neospora caninum (NC), by investigating the maximum number of samples one can pool to identify one positive animal, using commercial antibody-detection ELISAs. Nonetheless, there is limited information on the effect of pooling on test performance, and research is required to determine the appropriate number of samples which can be pooled. Sample Data comparing standard curve values using 4-PL vs Linear regression.Pooled samples are used in veterinary and human medicine as a cost-effective approach to monitor disease prevalence. 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. Note: Linear regression on Excel should only be used if software that can create a 4-Parameter (4-PL) logistic curve fit is unavailable. Where G7 is your OD value (select the appropriate cell for your data) You can do this by using a calculator and manually solving for "X" or by inputting a formula as shown. Now that you have your equation, you can solve for "x" and enter your sample OD values as Y. Go to the "Options" tab on the top of the window and Select "Display equation on chart" and "Display R-squared value on chart"Ĭlick "OK" to view your chart with equations. Select Linear under "Trend/Regression type". Click on the "Chart" tab and on the top menu bar click on "Add Trendline".Ī "Add Trendline" window will appear. Highlight data points by clicking on one of them. Click on the "Scale" tab on the top of the window. Place your chart on a new Excel sheet or insert into your current worksheet.ĭouble click on the x-acis values and a "Format Axis" window will pop up. Once you customize the chart to your preferences, click "Next".
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |