Posted on Leave a comment

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

Analysis of variance is a statistical method for determine if a variable has any effects on another variable. when we want to find out the relationship between two variables, we need to conduct an experiment in which, we have to change amounts in one variable and then measuring the resulted amount in another one. If we see meaningful changes in the average of resulted amounts, then we can conclude that the first variable has effects on the second one. The method is called, analysis of variance, in this video we show how we can conduct the one-way ANOVA 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.