(a) The following Excel spreadsheet represents capillary electrophoresis

Chapter 5, Problem 5-13

(choose chapter or problem)

(a) The following Excel spreadsheet represents capillary electrophoresis resultsmonitored bv fluoreseencc detection. Plot the raw data and calculate and plota five-point, ~nweighted moving average smooth on the results. .(h) Calculate and plot a five-point Savitzky-Golay smooth us 109 the smoothmgcoefficients given in the chapter. Compare the improvement in SIN of theSavitzky-Golay smooth to that of the moving average smooth plotted 10 (a).Also compare the peak distortion of the two smooths. ._(e) Use a search engine like Google to find the Savitzky-Golay smoothmg coeflicientsfor a seven-point quadratic smooth (order = 2) for the data pOInts.shown. Note that in many cases the coefficients have already been normalIzedby dividing by a normali~ation integer. You can determine whether thecoefficients have been normalized by comparing them to those gIven tnFigure 5-14a, which must be normalized by dividing by 35. .(d) Now perform a seven-point moving average smooth and a seven-po lOtSavitzky-Golay smooth on these data. Compare the improvement in SINand the peak shape distortion.(e) Perform a seven-point moving average smooth and a fifteen-point movingaverage smooth of the data. Which smoothing width gives better improvementin SIN? Whieh smoothing width gives least distortion of peak shape?(f) Defend or criticize the conclusion made by Enke and Nieman in their paperon smoothing (Anal. Chon., 1976, 48, 705A) that "least-squares smoothing isof cosmetic value only." Begin with a statement of whether you agree or dISagreewith Enke and Nieman's conclusion. Justify your conclusions by usingresults and inferences from their paper as well as your own reasoning.