Big data signal averaging. Download the spreadsheet of ten fluorescence emission spectra for 1 M1 M anthracene

Big data signal averaging. Download the spreadsheet of ten fluorescence emission spectra for 1 μM1 μM anthracene in methanol from SaplingPlus or macmillanlearning.com.
a. Data inspection. Before analyzing large data sets, data should be inspected for outliers, drift, or other nonidealities. Graphs are effective for inspecting data. Select cells A6:K136. On the Insert ribbon, select Scatter graphs, and then Scatter with Straight Lines. Double click on the x-^x- ’axis scale, click on the bar graph icon, and in Axis Options adjust minimum to 370370 and maximum to 500.500. All 1010 spectra are plotted in one graph. This overlay makes abnormalities apparent. Identify the two outliers in these data.
b. Signal averaging four scans. In cell L6 type ‘-AVERAGE (B6:E6)”. You should see 544.9 544.9 Click on cell L6, click on the fill handle—the small square in the bottom right corner of the cell—and drag down to cell L136. This fills column L with the average of scans 1-4.1-4. Plot overlaid spectra of scan 11 and average of four scans by selecting cells A6:B136, pressing Ctrl, and then selecting cells L6:L136. Cells in columns A, B, and L should be highlighted, but not those in cells C to K. Graph scan 11 and average of scans 1-4 1-4 using the procedure in (a).
c. It is easy to get lost when scrolling up and down large data files. Select cell B6. On the View ribbon, select Freeze Panes, and then Freeze Panes. Now when you scroll down, the top 55 rows remain at screen top. Column A remains on screen when you scroll right. To remove Freeze Panes, click on the View ribbon, Freeze Panes, and select Unfreeze panes.
d. Signal averaging nine scans. In cell M6 type ‘=AVERAGE (B6:J6)”. You should see 557.7. 557.7. Calculate the average down column M as in (b). Plot overlaid spectra of scan 11 and average of scans 1-9.1-9.
e. The range 470-500 nm 470-500 nm is background, with no signal. Calculate root-mean-square noise from 470-500 nm 470-500 nm for scan 1,1. average of scans 1-4,1-4, and average of scans 1-9 1-9. Does the noise depend on number of scans nⁿ or n√n?
f. Calculate signal-to-noise at 399nm 399nm for scan 1,1, average of scans 1-4,1-4, and average of scans 1-9 1-9. Use average from 470-500 nm 470-500 nm to estimate background. Does the signal-to-noise depend on number of scans nⁿ or n√n?