Bioequivalence and Bioavailability Forum

Not with EXCEL [General Sta­tis­tics]

posted by d_labes  – Berlin, Germany, 2010-08-20 16:57 (5371 d 15:10 ago) – Posting: # 5819
Views: 9,183

Dear Bharat,

❝ ... may I know how to calculate MSE residuals here???

MSE_residual is the Mean square of the error term from an appropriate ANOVA with the terms (effects) treatment, period, sequence and subject within sequence in the ANOVA model.

Although it is in principle possible I would not recommend to do this in M$ EXCEL . See this and related posts.
If you need a cheaper alternative then consider using R.

If you insist in using a spreadsheet consider the evaluation via intra-subject contrasts T-R. See Senn, Chapter 3 or Chow and Liu, Chapter 3.3.

S Senn
Cross-over Trials in Clinical Research
John Wiley & Sons, Chichester (2nd ed. 2002)

S-C Chow and J-p Liu
Design and Analysis of Bioavailability and Bioequivalence Studies
Marcel Dekker, New York (3rd ed. 2009)

Complete thread:

• least square mean calculation bvoggu 2010-08-18 07:49 [General Sta­tis­tics] 
  • least square mean calculation Helmut 2010-08-18 14:15
    • least square mean calculation bvoggu 2010-08-19 09:24
      • SE: SAS / PHX-WNL / manual Helmut 2010-08-19 12:36
        • Standard error d_labes 2010-08-19 16:18
          • Standard error Helmut 2010-08-19 16:33
          • Standard error bvoggu 2010-08-20 10:51
            • Not with EXCELd_labes 2010-08-20 14:57
  • least square mean calculation ElMaestro 2010-08-18 14:46
    • least square mean calculation bvoggu 2010-08-20 07:41
      • LSMeans ElMaestro 2010-08-20 09:34