i) Write down the equation derived from your Excel generated standard curve , figure legend and describe its components; ii) provide the values of the absorbance data of the unknown sample (do NOT show the absorbance data of the glycine standards). Show all details of the working out of your calculation. Indicate all units! Provide the answer with two decimals precision

Essentials Health Info Management Principles/Practices
4th Edition
ISBN:9780357191651
Author:Bowie
Publisher:Bowie
Chapter10: Introduction To Coding And Reimbursement
Section10.1: Clinical Classification Systems
Problem 5E
icon
Related questions
Question
  1. i) Write down the equation derived from your Excel generated standard curve , figure legend and describe its components;
  2. ii) provide the values of the absorbance data of the unknown sample (do NOT show the absorbance data of the glycine standards). Show all details of the working out of your calculation. Indicate all units! Provide the answer with two decimals precision
Excel File Edit View Insert Format Tools Data Window Help
2.0
Formulas Data
Home
Paste
Chart 3
1 Sample
2 Blank
3 Standard 1
4 Standard 2
5 Standard 3
6 Standard 4
AutoSave OFF
Insert Draw Page Layout
Ready
A
X
7 Glycine Unknown
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
Sheet1
Calibri (Body)
B I U v
✓ fx
0
0.02
0.04
0.06
0.08
1
B
Glucose Conc. (mm)
0
0.02
0.04
0.06
0.08
V 16 V
Glucose Conc. (mm)
+
v
Accessibility: Investigate
| 4
V
Α΄ Α΄
Av
A570 (1)
0
0.11
0.196
0.303
0.39
0.393
C
Average A570
0
0.111
0.206
0.301
0.397
9
Review View
三 三 三
A570(2)
0
0.112
0.217
0.288
0.393
0.417
D
Absorbance (570nm)
0.45
0.4
0.35
0.3
0.25
0.2
0.15
0.1
0.05
Automate
A570(3)
0
0.11
0.206
0.312
0.41
0.405
0
General
E
Chart Design Format
V
%
A
Book1
0.02
F
Average A570
0
0.11
0.206
0.301
.00
←0
.00 →.0
0.397
0.405
Glucose Standard Curve
Absorbance 570nm= 5.0233 X glucose concentration (mm)
Tell me
Cell
Conditional Format
Formatting as Table Styles
W
0.04
Glucose concentration (mm)
0.06
G
X
0.08
P
DNN
Insert v
Delete v
Format v
H
0.1
*
G
WE
V
V
V
100%
APO
Sort & Find &
Filter Select
|
III
Comments
Analyse
Data
Sat 15 Apr 9:49 am
J
Sensitivity
%D
Share
+ 100%
K
Transcribed Image Text:Excel File Edit View Insert Format Tools Data Window Help 2.0 Formulas Data Home Paste Chart 3 1 Sample 2 Blank 3 Standard 1 4 Standard 2 5 Standard 3 6 Standard 4 AutoSave OFF Insert Draw Page Layout Ready A X 7 Glycine Unknown 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 Calibri (Body) B I U v ✓ fx 0 0.02 0.04 0.06 0.08 1 B Glucose Conc. (mm) 0 0.02 0.04 0.06 0.08 V 16 V Glucose Conc. (mm) + v Accessibility: Investigate | 4 V Α΄ Α΄ Av A570 (1) 0 0.11 0.196 0.303 0.39 0.393 C Average A570 0 0.111 0.206 0.301 0.397 9 Review View 三 三 三 A570(2) 0 0.112 0.217 0.288 0.393 0.417 D Absorbance (570nm) 0.45 0.4 0.35 0.3 0.25 0.2 0.15 0.1 0.05 Automate A570(3) 0 0.11 0.206 0.312 0.41 0.405 0 General E Chart Design Format V % A Book1 0.02 F Average A570 0 0.11 0.206 0.301 .00 ←0 .00 →.0 0.397 0.405 Glucose Standard Curve Absorbance 570nm= 5.0233 X glucose concentration (mm) Tell me Cell Conditional Format Formatting as Table Styles W 0.04 Glucose concentration (mm) 0.06 G X 0.08 P DNN Insert v Delete v Format v H 0.1 * G WE V V V 100% APO Sort & Find & Filter Select | III Comments Analyse Data Sat 15 Apr 9:49 am J Sensitivity %D Share + 100% K
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Health Info Management Principles/Prac…
Essentials Health Info Management Principles/Prac…
Health & Nutrition
ISBN:
9780357191651
Author:
Bowie
Publisher:
Cengage
Biomedical Instrumentation Systems
Biomedical Instrumentation Systems
Chemistry
ISBN:
9781133478294
Author:
Chatterjee
Publisher:
Cengage