Question

1. 0/50 points | Previous Answers My Notes Ask Your Tea Fluoride ion selective electrodes obey the following equation E(V)K B(0.0592)log[F] where the fluoride concentration is expressed as mol/L and the temperature coefficient B is normally equal to1 In a normal calibration procedure you dilute a standard fluoride solution to between 10 and 20 mg/L fluoride ion and then measure the response of the electrode. You then plot the data and do a linear regression to obtain the fitting coefficients K and β Use the plotting and linear regression tools in Excel to calculate K and β from the data in the table. The coefficient β is close to 1, and can be determined from a calibration curve F concentration (mg/L) 10.0 12.0 14.0 16.0 18.0 20.0 E(V) 0.338 0.342 0.346 0.350 0.353 0.355 What value of K do you obtain from your plot? What value of B do you obtain from your plot? 40.985X

Answer 1

value of K = -0.529

value of beta = 0.985

Explanation

The equation of straight line obtained after line regression is : y = -0.9852x - 0.529

Home Page Layout Formulas Data Review Vew 816 coefficients 1 SUMMARY OUTPUT Rearession Statistics 4 Multiple R 5 R Square 6 Adjusted R Square 7 Standard Error 8 Observations 0.998567497 0.997137047 0.996421308 0.000392584 6 10 ANOVA MS F gnificance F 12 Regression 13 Residual 14 Total 15 16 17 Intercept 18 0.0592log[F-] 19 20 21 1 0.00021472 0.00021 1393.16 3.1E-06 4 6.1649-071.5E-07 5 0.00021533 Coefficients tandard Error t Stat P-value lower 95%.jpper 95%ower 95.0 pper 95.0% 0.52897066 0.004869 -108.64 4.3E-08-0.54249 -0.51545 -0.54249 -0.51545 -0.985156085 0.02639397 37.325 3.1E-06 -1.05844 -0.91187-1.05844 -0.91187 23 24 25 26 Sheet2 Sheet3 Ready Average:-0.757063373 Count 3 Sum:-1.514 126745 EELI 120%(