(a) The Excel spreadsheet on the following page represents capillary electrophoresis results monitored by fluorescence d

[answerhappygod]

A The Excel Spreadsheet On The Following Page Represents Capillary Electrophoresis Results Monitored By Fluorescence D 1 (79.28 KiB) Viewed 95 times

(a) The Excel spreadsheet on the following page represents capillary electrophoresis results monitored by fluorescence detection. Plot the raw data and calculate and plot a five-point, unweighted moving average smooth on the results. (b) Calculate and plot a five-point Savitzky-Golay smooth using the smoothing coefficients given in the chapter. Compare the improvement in S/N of the Savitzky-Golay smooth to that of the moving average smooth plotted in (a). Also compare the peak distortion of the two smooths.

B С 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 B 1 Smoothing of data 2 Capillary electrophoresis peak 3 detected by fluorescence 4 time, s Intensity 5 100 0.0956 6 105 0.1195 7 110 0.1116 8 115 0.1275 9 120 0.0717 10 125 0.1036 11 130 0.0319 12 135 0.0717 13 140 0.1355 14 145 0.2231 15 150 0.1753 16 155 0.5817 17 160 1.8646 18 165 2.6535 19 170 2.8527 20 175 2.8846 21 180 2.8368 22 185 2.7890 23 190 2.7093 24 195 2.5180 25 200 2.3427 26 205 2.2312 27 210 1.9603 28 215 1.8248 29 220 1.6017 30 225 1.4901 31 230 1.2989 32 235 1.2590 33 240 1.1076 34 245 0.9642 35 250 0.9164 36 255 0.8845 37 260 0.7809 38 265 0.7172 39 270 0.6694 40 275 0.6215 41 280 0.6454 42 285 0.6454 43 290 0.5817 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 A 295 300 305 310 315 320 325 330 335 340 345 350 355 360 365 370 375 380 385 390 395 400 405 410 415 420 425 430 435 440 445 450 455 460 465 470 475 480 485 490 495 500 0.5259 0.5658 0.5259 0.5020 0.5419 0.5419 0.3426 0.4940 0.4383 0.4462 0.3984 0.4064 0.4383 0.3984 0.3905 0.4861 0.3984 0.3267 0.3905 0.3825 0.4303 0.3267 0.3586 0.3905 0.3745 0.3347 0.3426 0.2869 0.2550 0.3506 0.3028 0.3028 0.3108 0.2311 0.2709 0.3028 0.2789 0.3347 0.2311 0.1753 0.2869 0.2311