Posted on

## Feature Scaling meaning and methods with example in Excel

When you want to do some mathematical operation on two variables (in Excel on to column of data), then you need to note if those two variables are in the same scale or note, if not the end result may not show you a correct value. For example, in may machine learning algorithms, or in multi criteria decision making problems, or when you want to indicate the importance of some factors in quality management systems, you need to take average from some variables, but the average value will be more near to the variable with more data range scales.

In this video we show different feature scaling  methods such as Mini Max , Standardization , normalization, scale to unit length along with meaningful example.

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

Posted on

## WeekNum and WeekDay functions in Excel

WEEKDAY, WEEKNUM in Excel These functions will return the week number from the start of year and the day name of the week at specific date