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

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

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

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

based on the magnitude of values, these function will return the rank of one specific value in a data range

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

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

These functions calculates the average of numbers in a range of data

These functions count the number of cells in a range that contains numerical values, or any values or if its equal to a some criteria

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

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