Texts: AGCMS (gas chromatograph-mass spectrometer) will be used to analyze solutions for benzflurain. First, a standard curve is prepared. Solutions with varying concentrations are made and analyzed, and the response of the GCMS (the peak area) is recorded. The data are given below.
Assignment: Enter a LINEST formula in the light blue cell to get values for m, b, and their errors for a y=mx+b fit. Populate the purple cells by using your m and b values to calculate mx + b for each concentration. Then plot a line of these values against concentration values, and show it as a line without points. This is the trendline. Please use the equation you obtained to estimate the error on your calculated concentration. For this, we follow the mathematical order of operations and find the error after each operation, so you will need two steps to find the error. Report benzflurain concentration, ppb. Response Fit (mx + b) Benzoflurain Calibration Curve (GCMS) 18000 160000 140000 27488 120000 29526 26482 56231 80000 68962 6000 75011 147351 40000 1000 168796 20000 0 m = 100 b = 209 300 400 500 600 700 800 900 1000 1100 values: errors:
Unknown sample: Response 6224 Concentration, ppb: y - b (y - b)/m Error, ppb: Report concentration as ppb.