Question

How to calculate molar absorptivity from LINEST Excel?

A) Slope of the line
B) Intercept of the line
C) Ratio of absorbance to concentration
D) Standard deviation of absorbance

Answer 1

To calculate molar absorptivity from LINEST in Excel, perform a linear regression analysis by plotting the absorbance and concentration data on a scatter chart and adding a trendline. The slope of the trendline equation represents the molar absorptivity.

Step-by-step explanation:

To calculate molar absorptivity from LINEST in Excel, you need to perform a linear regression analysis on a data set that includes the absorbance and concentration values. Here are the steps:

1. Enter the absorbance values in one column and the corresponding concentrations in another column.
2. Select the range of data and go to the 'Insert' tab then click 'Scatter' and choose the 'Scatter with Straight Lines' option.
3. Right-click on one of the data points on the chart and select 'Add Trendline'.
4. In the 'Trendline Options' dialogue box, choose the 'Linear' option and check the 'Display Equation on chart' and 'Display R-squared value on chart' checkboxes.
5. The molar absorptivity is equal to the slope of the line in the equation displayed on the chart.