How to Calculate Age Using Excel

Have you ever wondered how you could calculate the age of a number of people in a short period of time? Well, excel simplifies this task for you. Since calculating…

How to calculate variance in Excel

Variance is a measure of distance between numbers in a data set. Its measures the distance difference each number is from the mean. This distance is also known as the…

How to Calculate Correlation Coefficient in Excel

Excel is a powerful statistical tool. It can be used to calculate various statistics problems. Finding a correlation between two data series is a common statistical calculation that many statistical…

How to calculate work hours in Excel

Every employer would like to track the hours worked by his employees. However, this may be challenging and time-consuming if manual methods are used. Luckily, Excel allows its users to…

How to calculate Standard Deviation in Excel

Standard deviation is a statistical way of measuring the dispersion of a dataset. It is time confusing and tiresome to calculate standard deviation manually. To ease the process of calculating…

Comments Off on How to calculate Standard Deviation in Excel

How to calculate discount in Excel

Discount is the amount deducted from the regular price of a commodity. This is usually found by deducting the selling price from the regular or marked price of a commodity.…

Comments Off on How to calculate discount in Excel

How to calculate compound interest in Excel

Compound interest is where interest is credited on a loan or deposit with consideration of the initial principal and the cumulative interest from the time before. A good example is…

Comments Off on How to calculate compound interest in Excel