Treating this like a Linear Regression, follow the dataset and show the appropri

Question

Treating this like a Linear Regression, follow the dataset and show the appropriates steps to complete the following problem (This description is what is given at the top of the paper, nothing else is missing; thanks) analytical chem

Linear regression. For the lonowmb Sample Caffeine (ppm) Response 210 422 Standaro Standard Standard Standard 0 0 0 10 10 10 20 20 20 50 50 50 100 100 100 23 1200 1345 925 2521 2010 1921 6280 7022 6890 13021 14509 14231 Standard Standard Standard Standard Standard Standard Standard Standard Standard Standard Standard a. Find the linear regression equation for the calibration curve. X + b. Use LINEST to find Sy and use it to calculate Ux. Sy c. An unknown sample was analyzed once and the caffeine response was 8124. Please calculate the amount of caffeine in the sample. Amount of caffeine in Unknown Sample d. And fina 95% confidence interval 99% confidence interval ly, please calculate the confidence intervals about that amount. From to From to

Explanation / Answer

Steps-

1) Calculate Mx, My, Sx, Sy and Sxy

2) Regression coefficients, b1= Sxy/Sx^2

3) b0= My-b1*Mx

Here is the result-

X Values
= 540
Mean = 36
(X - Mx)2 = SSx = 19560

Y Values
= 72530
Mean = 4835.333
(Y - My)2 = SSy = 386504285.333

X and Y Combined
N = 15
(X - Mx)(Y - My) = 2738360

b1= 2738360/19560= 139.99

b0= 4835.33-139.99*36= -204.51

So, regression equation is -204.59+139.99*X where X is response

R^2 = 0.9918

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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