Posted on Leave a comment

Two-way analysis of variance – ANOVA – in Excel data analysis add in

The two way analysis of variance is a statistical method for determine if two independent variables has any effects on another variable. when we want to find out the relationship between these variables, we need to conduct an experiment in which, we have to change amounts in independent variables and then measuring the resulted amount in dependent variable. If we see meaningful changes in the average of resulted amounts, then we can conclude that the variable has effects. The method is called, analysis of variance, and in addition to that we have to test if the interaction of two independent variables have effects on the dependent variable or not. in this video we show how we can conduct the two-way ANOVA with replication (meaning that we have more than one sample for each variation in variables) in the Excel by using Data analysis add ins

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.