I need help in finding the third column with the equation below and to find the L-L dist

manageable table, some data points have been deleted. 3. Using the spreadsheet, make a new column titled "Area Trapz" and use equation (1) shown in the section "Trapezoid Rule" to calculate the total area under the curve. You can determine "w" by the separation between data points on the x-axis. Recall that yo and Yn represent the initial and final values of intensity data. 4. Use Excel Solver Tool to fit this data set to a consecutive Lorentzian-Lorentzian distribution. A Lorentzian function can be represented as: W 2A y = TT (2) 4(xi Xpeak)' + w2 The parameters, A, w and Xpeak (sometimes called xc) describe characteristics of the peak. Here, w is the peak width at half of its maximum intensity value, A is the area of the peak and Xpeak is the x value where the peak maximum occurs (i.e. the peak center). Then a consecutive Lorentzian-Lorentzian (L-L Dist.) would be the sum of two or: W1 2A2 W2 + (4) (3) y TT 14(x; Xpeak, 2) + w? 4(xi Xpeak,2) ? + w Area Trapz D L-L Dist E Error^2 Intensity (a.u.) O 20 Frequency (cm) 2500 2504.5 2509 2513.5 2518 0.013 0.015 0.026 0.046 0.084 2522.5 2527 0.135 2531.5 0.202 0.412 0.661 2536 2540.5 2545 2549.5 0.537 0.301 2554 0.226 2558.5 0.401 2563 0.87 2567.5 0.934 2572 0.482 2576.5 0.156 2581 0.047 2585.5 0.017 2590 0.008 2594.5 0.003 X1 ydx = (y + x) 2 Xo