How to calculate Standard Deviation in Excel

How to count unique values 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 standard deviation, new methods have been developed. Excel is a powerful tool that can be used to calculate standard deviation in just a few steps.

How to calculate discount 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. Discount can also be expressed in percentage by taking the regular price multiplied by the rate of discount. Regular Price × Rate of Discount =

Simple way to calculate compound interest in Excel

Compound interest is where interest is credited on a loan or deposit considering the initial principal and the cumulative interest from the time before. A good example is when you invest 700,000/= with a 10% annual interest rate compounded annually. When a year lapses from the initial principal, you get 70,000/= (700,000 x 0.10) as