Bioequivalence and Bioavailability Forum

Dear Helmut and all,

SAS results correspond with your Phoenix-results:
Diff of ln(means): 0.143765
SE:                0.049080
sWR                0.044645
point estimate     1.15461
x                  0.018260
y                 -0.15879
boundx             0.050908
boundy            -0.12299
theta² (0.25)      0.79669
theta              0.892574         
critbound         -0.092076<=0, RSABE demonstrated

„Confidence limit”-Calculation, like Endrenyi/Tothfalusi call it in SAS:
Em (should be x…)  0.020668
Es (=-y)           0.15879
Cm (=boundx)       0.050908
Cs (=-boundy)      0.12299
Lm                 0.001065889
Ls                 0.001281992
CL                -0.091257

Small difference, but can be critical;

Now my EXCEL Sheet (I know, that EXCEl has bad reputation, but +-*/² and sqrt are exact):

Unfortunately I get a different value for the variance of the differences of the pooled formulation data:
MSE=0.165897781 in EXCEL and
0.1662119811 from SAS, if I take the „stderr“-value from „iout2“ to calculate MSE using: MSE=stderr²*69;
(accordingly: SE in EXCEL: 0.0490338, in SAS 0.49080)

But, if I look at the residual from „iout1“ (please see SAS program of FDA):
exactly the result of my EXCEL calculation appears: residual=0.1658977
However the stderr from iout2 is used in SAS for further assessment;
results from EXCEL:
Critbound  -0.09209837 acc. to FDA
CL         -0.091279223 acc. to E/T

My knowledge in SAS is not enough, to draw the formula somewhere.
Can someone give me a hint on the reason for the 2 different variability results, and may be a comparison of the formulas?

thanks a lot
FI