in Excel, how to find FWHM of data?

In Excel, I have two columns X and Y, and Y is Gaussian type of peak, how can I find the Full-width half maximum (FWHM)?

I want to find all Y cells that are greater than half maximum and find the first and last corresponding X values, how can I do that? Is there a better way?

1 Answer

Question 1: how can I find the Full-width half maximum (FWHM)?

According to

FWHM = 2*sqrt(2*ln(2))*c

Then, to find c you have to resort to

For that, you would like to explore some of the links from

"Question" 2: I want to find all Y cells that are greater than half maximum.

To be answered.

"Question" 3: ...

Idem.