Excel Formulas

How to Calculate Altman Z Score in Excel (3 Suitable Examples)

What Is the Altman Z Score? Using the Altman Z score, you can predict if a company will be bankrupt within two years. Developed by Edward Altman, it ...

How to Calculate the BMI Z Score in Excel – 4 Steps

What Is the BMI? BMI (Body Mass Index) is a standard index first proposed by Adolphe Quetelet in the 1830s. It gives an insight into a person’s ...

How to Calculate Coefficient of Variance in Excel (3 Methods)

In Excel, users calculate various Statistics properties to showcase data dispersion. For this reason, users try to calculate the Coefficient of ...

How to Calculate Interquartile Range in Excel (2 Suitable Ways)

Calculating the Interquartile range is an important task as it can be used to find outliers. If you are finding ways how to calculate interquartile ...

How to Find F Critical Value in Excel?

While working with Microsoft Excel, sometimes, we have to calculate the F critical value. Calculating the F critical value in Excel is an easy task. ...

How to Round Off to Nearest 50 Cents in Excel (4 Quick Methods)

We often need to round off numbers for different types of calculations. In particular, we need to round off currencies and prices while dealing with ...

How to Find Critical Value of r in Excel?

In this article, we will learn to find the critical value of r in Excel. Generally, the critical value of r is determined from a chart. But we can ...

How to Calculate the Mahalanobis Distance in Excel – Step by Step

The dataset showcases the monthly return percentages of Stocks and Bonds.   What Is the Mahalanobis Distance? The Mahalanobis ...

How to Calculate Probability from Z-Score in Excel (with Quick Steps)

  What Is Z-Score? Z-Score is a special type of value that indicates how far the value is from the mean. The general formula for the Z-score ...

How to Calculate Retail Price in Excel (2 Suitable Ways)

Method 1 - Calculate the Retail Price from the Markup Let's assume the total cost to manufacture a bicycle is $600. Revenue earned from the sale is ...

How to Calculate Percentage Range in Excel (Step-by-Step Guide)

Sometimes, you may need to calculate percentage range, percentage relative range, or percentage of cells in a range. Microsoft Excel enables you to ...

How to Calculate Projected Sales in Excel (2 Methods)

Dataset Overview We've provided a data set containing information about the annual sales. We need to project future sale price. Method 1 ...

How to Calculate Age in Excel in dd/mm/yyyy (2 Easy Ways)

Method 1 - Calculate Current Age in Excel by Combining TODAY and DATEDIF Functions DATEDIF function calculates the difference between two dates. ...

How to Find Critical Value in Excel: 2 Useful Methods

Method 1 - Find T Critical Value in Excel The T critical value is basically the indicator of determining the statistical significance of a T-test. ...

How to Calculate Miles between Two Addresses in Excel (2 Methods)

Method 1 - Using Latitude and Longitude to Calculate Miles between Two Addresses In our first method, we’ll use the latitude and longitude within a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo