57
Legend”.
(3) Insert Graphics. Click the “Next” button to go into “Chart Wizard 4-Procedure 4”. Select
the location of inserting a graphics.
3. Data Processing by using Linear Regression
From the Excel menu select “Chart (C)”
→
“Add Trend Line (R)…”. Select “Linear
Regression”. Switch to the “Options” page. Select “Show Formula” and “Display R-Square Value ”.
Click the “OK” button.
Fig. 3-2 The Standard Curve Plotted after Data Processing With Excel 2000 Software
in Measurement of Riboflavin by fluorophotometry
(y=437.14x+0.2762 the fitted equation, correlation coefficient R
2
=0.9997)
4. Measurement of Unknown Sample
Under the same condition measure the fluorescent intensity of unknown sample solution.
Comparing the fluorescence value with that in the above standard curve, or putting the value into the
fitting equation, you may obtain the concentration of riboflavin in the unknown sample.
INSTRUCTION MANUAL FOR SPECTRO 96 FLUOROSPECTROPHOTOMETER