If you have written any competitive exams, you might be familiar with the term percentile. Most of today’s competitive entrance exams publish the results of the applicants based on percentiles. You might be familiar with the term percent. But, it is not the same as percentile.

Do not confuse these terms. As we all know, percentage is a number defined as a fraction of 100. So, if a person says that he scored 60% marks in his GMAT exam, then it means that if total score is 100, he scored 60 marks.

Obviously, if the total score is 50, the person has got 30 marks in the exam.

Read More

If you are familiar with Excel, you might have used many different built-in functions to get results easily, quickly and efficiently. You might have come across a number of mathematical functions too including AVERAGE, LCM, QUOTIENT, GCD, PRODUCT, SUM, POWER, SQRT and so on. Have you ever tried calculating the 4th root or 10th root of any number using Excel? Have you disappointed realizing that there is no built-in function in Excel that allows you to calculate the nth root of a number?

Read More

In mathematics, a ratio is a comparison of two numbers. It is expressed as a colon (:) between the two numbers. For example, if there are 2 red balls and 3 blue balls on a table, the ratio of red balls to blue balls is 2:3.

Read More

Variance analysis is a critical aspect of data analysis, and Excel offers robust tools to simplify the process. In this comprehensive guide, we will walk you through each step of calculating variance in Excel, ensuring clarity and focus on specific topics. Whether you are working with sample data, population data, or datasets that include non-numeric values, this guide is tailored to provide you with precise insights.

Read More

Percentage change in Excel is used to determine the difference between two values as a percentage. This can be useful for comparing changes in financial data, such as sales or profits, over time. In this lesson you will learn, how to calculate the change between two numbers.

Read More