a. Enter the columns i and ai in Excel and make a plot of the data (ai vs. i). b. Calculate the 5-point smooth as defined above and add the smoothed data to the chart. c. Print the chart and add it to your written answers. (Screen Shot) d. Comment on the differences between the original and smoothed data.

The simplest smoothing algorithm is to replace every data point by a running mean of its neighboring data points. In other words, if the original data are called a where i ranges from 1 to the total number of data points N, the smoothed data b; are calculated by: b=(21-2+a;-1+a;+di+1+a;+2)/5 (for a 5-point running mean). Do the following, given the set of data below that was calculated from a Gaussian profile and adding in 50% noise: i 1 2 3 4 No 5 6 ai 1.7E-12 3.4E-10 8.5E-08 4.5E-06 2.2E-04 5.3E-03 4.7E-02 2.2E-01 7.5E-01 9.2E-01 1.1E+00 3.5E-01 7 8 9 10 11 12 The simplest smoothing algorithm is to replace every data point by a running mean of its neighboring data points. In other words, if the original data are called a where i ranges from 1 to the total number of data points N, the smoothed data b; are calculated by: b=(21-2+a;-1+a;+di+1+a;+2)/5 (for a 5-point running mean). Do the following, given the set of data below that was calculated from a Gaussian profile and adding in 50% noise: i 1 2 3 4 No 5 6 ai 1.7E-12 3.4E-10 8.5E-08 4.5E-06 2.2E-04 5.3E-03 4.7E-02 2.2E-01 7.5E-01 9.2E-01 1.1E+00 3.5E-01 7 8 9 10 11 12