Question

The blood glucose level of a person can be measured by spectrometry for clinical use. The absorbance intensity of 6 standard solutions with known glucose concentration is shown below: | C (M) | 0 | 2x10°ーー4x10ゴー16x10·すーー8x10-31-1102 onc. of glucose Absorbance 0 0.189 0.412 0.672 0.8181.104 a) Calculate the equation of the best-fit straight line for the standard glucose solution using the least-square method b) Calculate (i) the variance of the regression line and (i) the correlation coefficient of the (c) A set of blood samples is tested to give an average absorbance of .204, Calculate the average regression line. blood glucose concentration of the blood sample with its standard deviation if the set of blood samples is measured one time only. (d) Do you think the result obtained in part e is reliable? Justify your answer and suggest one way to improve the reliability of the result. -The End-

Answer 1

result from excel

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.997688352
R Square	0.995382047
Adjusted R Square	0.994227559
Standard Error	0.031208744
Observations	6
ANOVA
	df	SS	MS	F	Significance F
Regression	1	0.839755557	0.839755557	862.1846756	8.0094E-06
Residual	4	0.003895943	0.000973986
Total	5	0.8436515
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	-0.015142857	0.022587231	-0.670416719	0.539311531	-0.077855063
CONC.	109.5285714	3.730158392	29.36298138	8.0094E-06	99.17199142

a)

y^= -0.0151 + 109.5286 *x

b)

variance = MSE = 0.000974

r = 0.9977

c)

y^= 1.204 = -0.0151 + 109.5286 *x

x = 0.01113

d)

No,it is not reliable as 1.204 is outside of range of data available