## Wednesday, June 08, 2016

### How To... Perform a Two-Way ANOVA in Excel 2013 #207

It's been a while since I uploaded a video to YouTube - partly because I had a very busy semester II, and partly because I had plenty of videos already to support existing classes. This past semester I took on a new (to me) statistics module: Advanced Business Data Analysis. While much of the work done in the class was in R and SPSS, we did use Excel for a few of the statistical tests. The first was for a two-way ANOVA*. This is a hard test to calculate manually, so we use tools instead to perform this test. More videos to support this module to come in the next couple of weeks.

* From my course notes:

Use two-way anova when you have one measurement variable and two nominal variables, and each value of one nominal variable is found in combination with each value of the other nominal variable. It tests three null hypotheses: that the means of the measurement variable are equal for different values of the first nominal variable; that the means are equal for different values of the second nominal variable; and that there is no interaction (the effects of one nominal variable don't depend on the value of the other nominal variable).