Question

How do you normalize the peaks on excel?

Dald Cidl pe mart Styles Data Type Location s 0.004 KIL M NO PQ RE 694.6 0.015 694.6 0.012 SPINACH SPECTROPHOTOMETRY O 0.95 0.9 0.85 0.8 0.7 0.65 0.6 0.35 os 304 OAS 0.35 0.3 0.25 0.2 0.15 0.05 -0.053 75 400425 450 475 500 525 550 575 600 625 650 675700 -0.1 725 WAVELENGTH(NM) - T3 - T6 Original

Answer 1

When you normalize, you want the maximum of all spectra to be 1. For this, you should take each of the columns with the absorbance value and divide ell the values by the maximum absorbance value among them.

Suppose you have your absorbance values in column 3, from cell C2 to cell C200. Now take an empty column (we will suppose this is column D) and in D2, write =C3/MAX($C$2:$C$200). Then copy this command to all the cells in the D column (from D2 to D200), and you should get normalized value which you can then plot.

If you have any doubts, please write a comment and I'll try to help you!