0 0 analysis (e.g. Excel\'s best-fit analysis). I probably threatened that hand

Question

0 0 analysis (e.g. Excel's best-fit analysis). I probably threatened that hand calculations by hand, but I can't bring myself to making you do it; I'd rather see you work smarter than harder. I want you to use the LINEST (LINE STatistics) function in Excel to perform 5 to assist you with using the LINEST function in Excel. LINEST is very useful because it not only outputs the best-fit slope and y- intercept, it also provides the associated uncertainty with the slope 0 sure to report the uncertainty associated with both the y-intercept and slope propagate the uncertainty associated with the slope, y-intercept, and measured absorbance

Explanation / Answer

[a]

Model:   Absorbance = 0.2196 * Concentration + 0.0138

[b]

Uncertainity in absorbance = +- 0.098

COnfidence inteval = 94%

Slope 0.2196 y-Intercept 0.0138 Uncertainity in slope 0.0037 Uncertainity in y-intercept 0.0158

Related Questions

Navigate

• Browse (All)
• Browse
• Subjects

---

---

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