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

Posted on

## Descriptive statistic report in Excel add ins analysis

This add ins will generate a simple and fast statistical report from your data

Posted on

## MAX LARGE MAXIFS MIN SMALL MINIFS functions in Excel

These functions will find the biggest (smallest) numbers in a range of data set. you can find 1st, 2st and .. number in your range

Posted on

## VARIANCE and STANDARD DEVIATION in Excel

Standard deviation is a number that measures the variation among data. And its mean that how much data are far from their mean

Posted on

## ROUND ROUNDUP ROUNDDOWN functions in Excel

These functions will convert a decimal number into an integer or another decimal number with desired decimal point

Posted on

## RAND and RANDBETWEEN functions in Excel

These two functions will return the a random number in Excel, RAND function will return a decimal random number between 0 to 1 and RANDBETWEEN will return an integer random number between two defined values