Question

A standard stock solution is diluted to generate three working standard solutions containing ethyl acetate (EA) at 50 ppm, 400 ppm, and 800 ppm. An internal standard, n-butanol (nB), is added so its concentration is 1500 ppm in each of the working standard solutions. The solutions are analyzed using GC-FID.

The peak area data for the peak corresponding to ethyl acetate from the standard chromatograms
50 ppm (EA area = 5.05, nB area = 124.37)
400 ppm (EA area = 47.98, nB area = 125.31)
800 ppm (EA area = 98.21, nB area = 130.63)

The results for the linear regression analysis for the data set using Excel are?

Answer 1

The two pairs of data are plotted in excel and linear regression is applied:

The results are:

For Ethyl Acetate:

Y = 0.1242 * X - 1.3557

For n-Butanol:

Y = 0.0085 * X + 123.24

If you liked the answer, please rate it positively, you would help me a lot, thanks.