I have to automate a GLM within an Excel sheet that will be analyzing some toxicity data, resulted from scoring cell aberrations. And, I'm using MiniTab to validate the estimates. MiniTab is using Type I (sequential) SS and Type II (adjusted) SS within their ANOVA GLM.

I can't find a place online that will give me a comprehensive guide to estimating the Type I and Type II SS.

I've also poured through "Applied Linear Statistical Models" and can't find out how to do these. The book only covers Type III SS, which is the classic unweighted means.

I also looked at "Four Types of Sums of Squares for ANOVA Effects". But, it was very vague in describing how to calculate the different SS Types.

Can someone point me in the right direction? Either a website or an example excel file?

Thank You,

BrainExploding