Excel 2011 for Mac offers real power in its chart-analysis tools, but using them requires some knowledge of the math behind the features. Adding a trendline to charts in Excel 2011 for Mac Excel can add a line called a trendline that calculates and projects the trends into the past or future indicated by your data.
By You can use StatPlus LE to do analysis of variance in Excel on a Mac. The first thing you have to do, however, is rearrange the data the way StatPlus likes it — in columns. The second thing is to recode variable-level names as numbers. The following figure shows the rearrangement and the recoding. For the A variable, record Book as 1 and E-reader as 2. For the B variable, record Haettenschweiler as 1, Arial as 2, and Callibri as 3. Substitute the StatPlus Two-Way ANOVA tool for the Analysis ToolPak tools.
The first time you analyze the data, treat Subject as Factor 1 and Font as Factor 2. You must also select Advance Options and select the check box next to No Interaction(s) (Randomized block design).