My question is the two boxes I left blank LAB 3: DATE SHEET INTRODUCTION TO ExCE
ID: 3126263 • Letter: M
Question
My question is the two boxes I left blank LAB 3: DATE SHEET INTRODUCTION TO ExCEL ConSten t a e sl. Lab Section. Name: Ntennhers: There are three graphs that oust be astached to the Data Sheet Project 1 & 2: Preparing a Standard Curve for Starch and Using a Standard Curve to Estimate Concentration Table 1 Starch Cone. (mg/ml.) 0.2 0.4 0.6 0.8 01P0-046 0234 0232 0 100 0 995 331 OCS | q Calculated value for skpe (m or .) Line equation (above) Line equation (Project 5) 0 .40 y: o.bo2x Table 2: Unknown Starch Sample Starch Conc. (mg/mL)UNK A (x value) Least Squares- Calculated calculate using the least squares method. Proyect 2 #10. Accepted value. Calculate using line equation from Excel graph, Project 5 #19. Lab 3: Introduction To Excel- Page 65 Spring 2016 65
Explanation / Answer
The numbers that you have missed need to be filled by you on the basis of experiment that you performed.
From the above samples you get a regression equation of a line in the form of:
Y = a + bX
Where Y is the wavelength values and X is the concentration values.
You have already determined the values of a and b in your table (or Bo and B1).
Put the X value for the unknown sample solution. in the equation Y = a + bX and get the value of Y. That value will come in the Least Squares box.
Then,
experimentally find out the starch concentration via plotting the points on a graph. That will come in the box next to calculated knowing the value of X.
Hope this helps. Ask if you have doubts.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.