Posted on

## 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

Posted on

## 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

Posted on

## Test of hypothesis in Excel data analysis add in

When we have two sample data driven from one or two population and want to see if the mean of those two population (or the mean of one population between two different time) has been changed or not, we use statistical method called test of hypothesis for mean difference, which also known as AB test in some applications. Here we use data analysis add ins in the excel to generate this method in simple way.

Posted on

## Covariance and correlation in Excel data analysis add in

When we want to know if there is relationship between two or more variables, we need to calculate their covariance or correlation indexes. These to will show us how much two variables are related together. If these indexes have greater values (in correlation, near to 1), then showing us there is straight relation between variables. And if their values be huge negative number (in correlation, near to -1) then it showing the inverse relation between variables. However, if value of these indexes be near to 0, then it suggesting no relation between variables.

Posted on

## Regression in Excel data analysis add in

Regression is a statistical method for analysis relationship between two or more variables. this method has lots of application in all areas and one of the most popular use is for predicting one variable based on another

Posted on

## Exponential Smoothing in Excel data analysis add in

Exponential smoothing, or Exponential moving average, is a method in time series analysis that helps us to analysis time based data and predicting of new period data. The approach of this method is getting average of all the data in time line with more attention on newest data periods. we can create a very fast report by using data analysis add in of Excel.

Posted on

## Moving Average in Excel data analysis add in

Moving average is the simplest method for analyzing time series data. The moving average approach is to getting average of nearest data (instead of getting average from whole data). we can create a very fast report by using data analysis add in of Excel.

Posted on

## Histogram and frequency in Excel data analysis add in

By using Histogram tool in Excel data analysis add in, we can simply generate a report which contains the auto calculated bins, frequency, Histogram chart as well as Pareto analysis

Posted on

## Generating random number by Excel data analysis tool

By using random number generator of Excel analysis add ins we can generate a matrix of random numbers with custom seed

Posted on

## Data sampling with Excel data analysis tool

Instead of using formulas to generate random numbers and then selecting random samples from a data set, we can use data analysis add ins in Excel to generate random samples from a data set