Serinus 40 User Manual 2.2
Microsoft Excel
Alternatively all the data can be placed into an Excel spread sheet in columns next to the supplied
concentration.
1. Create an X/Y scatter plot of expected calibration against instrument response. Right click on
either point and select Add Trendline. Tick the Display Equation on Chart and Display R-squared
Value on Chart in the options tab.
2. The linear regression equation y = mx + b will be displayed.
Figure 39 – Excel graph of multipoint calibration
3. The following is a guide to approximate expected good results:
a. The gradient (m) falls between 0.98 and 1.02.
b. The intercept (b) lies between -2 and +2.
c. The correlation (R
2
) is greater than 0.99.
4. If unsatisfactory results are observed, perform a leak check (refer to Section 6.4.4), check zero air
scrubbers or check troubleshoot guide for possible errors (refer to Section 7).
To Next Page
Loading...
