Synthetic data are given below for a calibration curve in which randon Gaussian noise with a magnitude of 80 was superimposed on y values that follow the equation y=26.4x+1.37. This exercise shows that a high value of R² does not guarantee that data quality is excellent.
A. Prepare a scatter plot on excel, use LINEST to find least-square parameters
B. Add 95% Confidence interval y error bars.
I finished the problem up to the error bars. I don't know how to compute the confidence interval. Here is the data:
a. 0,14
b. 10,350
c.20,566
d.30,957
e. 40,1067
f.50,1354
g. 60,1573
h. 70,1732
i. 80,2180
j. 90,2330
k. 100,2508