L 5. Calculating standard error of regression First calculate (ŷ) the value of (y) estimated from the regression for each concentration of the standards (x;) using the regression equation we have now established: Ут Y2 92 Yo Y4 43 Ys 94 Y6 95 96 ŷi = 0.01416x + 0.0264 STEP 1 ŷi (y = a + bx) Standard Concentration [chloride] mmol/L X1 X2 684 456 X3 342 X4 X5 228 114 У1 Y2 y3. 芝 Y4 y5 S Reading for AgNO3 (mL) 9.686ml 6.450ml 4.836ml 3.215m 1.617m1 X6 57 Y6 0.871ml או 3.135 y 4.446

Appl Of Ms Excel In Analytical Chemistry
2nd Edition
ISBN:9781285686691
Author:Crouch
Publisher:Crouch
Chapter2: Basic Statistical Analysis With Excel
Section: Chapter Questions
Problem 12P
icon
Related questions
Question

QUESTION: Answer Question 5: 'Calculating standard error of regression' STEP 1 by filling in all the empty green boxes

*The values are all provided in the photo attached*

L
5. Calculating standard error of regression
First calculate (ŷ) the value of (y) estimated from the regression for each concentration of the standards (x;)
using the regression equation we have now established:
Ут
Y2
92
Yo
Y4
43
Ys
94
Y6
95
96
ŷi = 0.01416x + 0.0264
STEP 1
ŷi (y = a + bx)
Transcribed Image Text:L 5. Calculating standard error of regression First calculate (ŷ) the value of (y) estimated from the regression for each concentration of the standards (x;) using the regression equation we have now established: Ут Y2 92 Yo Y4 43 Ys 94 Y6 95 96 ŷi = 0.01416x + 0.0264 STEP 1 ŷi (y = a + bx)
Standard Concentration [chloride] mmol/L
X1
X2
684
456
X3
342
X4
X5
228
114
У1
Y2
y3.
芝
Y4
y5
S
Reading for AgNO3 (mL)
9.686ml
6.450ml
4.836ml
3.215m
1.617m1
X6
57
Y6
0.871ml
או
3.135
y
4.446
Transcribed Image Text:Standard Concentration [chloride] mmol/L X1 X2 684 456 X3 342 X4 X5 228 114 У1 Y2 y3. 芝 Y4 y5 S Reading for AgNO3 (mL) 9.686ml 6.450ml 4.836ml 3.215m 1.617m1 X6 57 Y6 0.871ml או 3.135 y 4.446
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage
Fundamentals Of Analytical Chemistry
Fundamentals Of Analytical Chemistry
Chemistry
ISBN:
9781285640686
Author:
Skoog
Publisher:
Cengage
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Principles of Modern Chemistry
Principles of Modern Chemistry
Chemistry
ISBN:
9781305079113
Author:
David W. Oxtoby, H. Pat Gillis, Laurie J. Butler
Publisher:
Cengage Learning
Chemistry & Chemical Reactivity
Chemistry & Chemical Reactivity
Chemistry
ISBN:
9781337399074
Author:
John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:
Cengage Learning