Calculate INTERCEPT in Excel

What is Intercept? Intercept is a point on Y-axis where the line crosses. Or, we can say that it is the value of y when x is 0. How to find ...

How to Ignore zero in the Average of numbers in Excel

In this article, we will learn about how to get the Average of numbers ignoring zero in Excel. In simple words, Average of numbers is the ratio of ...

How to Calculate Mean in Excel

The arithmetic means, mode and median are the base of any statistical analysis of data. We have already discussed how we can calculateĀ MODE and MEDIA...

How to Create Standard Deviation Graph in Excel

The bell curve or standard deviation graph is used to visualise the spread of data. Excel is powerful tool to create graphs and visualise data and it ...

How to Calculate Max if condition match in Excel

In this article, we will learn about how to calculate Maximum value if the condition matches in Excel. When working with long ranges of data we nee...

Calculating Coefficient of variation in Excel

In this article, we will learn about how to calculate the coefficient of variation in Excel. The coefficient of variation is a statistical measure ...

How to get the Present Value of Annuity in Excel

In this article, we will learn about how to find the Present Value of annuity using the PV function in Excel. Present value of annuity is the prese...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.