Context: say I am trying to determine the concentration of a chemical, so I take known concentrations of the chemical and make a standard curve (6 measurements per standard) then measure my unknown 6 times.
Here's what I can do: I can use linear regression to determine confidence limits for the concentration of each independent read of my unknown sample (by using a selection variable and saving predictions from the REGRESSION command, but that's not what I want. I want a single estimate (with std. error or CI bounds) of my single unknown sample that accounts for both a) the error in my regression model built from my standard concentrations and b) the error in my measurement from my one unknown sample.
How can I do this in SPSS? If I try to save predicted values from GENLINMIXED, MIXED, or GLM, I get either no predicted values for my unknown (because no dependent value was listed) or a unique estimate and error for each replicate measurement of my unknown (when I want the group estimate, not the estimate for each replicate).
Here are some example data I made up. Depending on the analysis you want to try, it might be necessary to run VARSTOCASES first. I don't want to make this a tall question, so I'm submitting it in this format:
data list list /conc read1 read2 read3 read4 read5 read6 stdCurve.
begin data
0 .00446 .00515 .00450 .00519 .00500 .00492 1
100 .10054 .10484 .10086 .10877 .10293 .10747 1
200 .20695 .20083 .21797 .21949 .18936 .19672 1
300 .32355 .31071 .30802 .30414 .30014 .26003 1
400 .42793 .40888 .40227 .41009 .39880 .39879 1
500 .47858 .47810 .55102 .49355 .51650 .46561 1
600 .66123 .62981 .62180 .54510 .67363 .65373 1
700 .65611 .70905 .74126 .71843 .69953 .77222 1
800 .86298 .75166 .86441 .77430 .82915 .85193 1
900 .92009 .94197 .92889 .91114 .79323 .93604 1
1000 .90955 1.00724 1.02682 .95047 1.03176 1.16755 1
. .56990 .55395 .58641 .51932 .59506 .55967 0
end data.
concentration
as DV andread
values as IV. (Am I correct?) This way you naturally get several varying prediction values for the DV. Whereas your calibrationconcentration
values are true (error free) and should be the IV. $\endgroup$read
byconcentration
. Estimate and plot upper and lower confidence bounds around the regression line. Compute the meanread
for the unknown concentration sample. Intersect this line with the aforementioned confidence bounds and project the two points of intersection on concentration axis. That will be the bounds for concentration of your sample. In your example data, however, there is the problem of heteroscedasticity (cloud is fan-like shape) and hence the usual OLS confidence interval is inappropriate. $\endgroup$