How do you calculate the LOL (limit of linearity) from excel regression data SUM

Question

How do you calculate the LOL (limit of linearity) from excel regression data

SUMMARY OUTPUT Regression Statistics Multiple R 0.985420026 R Square 0.971052628 Adjusted R Square 0.965263153 Standard Error 0.005844476 Observations 7 ANOVA df SS MS F Significance F Regression 1 0.005729211 0.005729 167.7272 4.89153E-05 Residual 5 0.000170789 3.42E-05 Total 6 0.0059 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.004874836 0.003497936 1.393632 0.222203 -0.004116894 0.013866566 -0.004116894 0.013866566 25 0.005924726 0.000457474 12.95096 4.89E-05 0.004748752 0.007100701 0.004748752 0.007100701

Explanation / Answer

Limit of Linearity is the concentration at which the calibration curve departs from linearity by a specified amount. A deviation of approximately 5% is usually considered the upper limit. Common at higher concentrations.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.