Calculate Normal Distribution Probability in Excel
There are a lot of statistical measures and terms that are used and can be calculated using Excel. One of these terms is…
Category: formulas
Mood’s Median Test in ExcelÂ
Although Excel has many built-in formulas that fall under many categories: statistical, mathematical, logical, and many more, there are some things that cannot…
Excel VLOOKUP and MID for Data Analysis
Excel formulas are made in a way that complicated things can seem easy. There is always an option to combine the formulas to…
Excel SUMIF with INDEX & MATCH
Although Excel formulas are powerful as a standalone option, their true power can be seen when combined. INDEX and MATCH are two formulas…
Using the LINEST function
A LINEST function is a great tool that can be used in Excel or Google Sheets. With this function, we can perform linear…
Linear Interpolation in Excel
If we talk about linear interpolation in Excel, we first need to understand what this term is. Linear interpolation is a method from…
Difference Between LOOKUP and VLOOKUP Functions
VLOOKUP is one of the most widely used formulas in Excel. A similar formula, from the same family for that matter, is LOOKUP,…
Using HLOOKUP in Excel to Retrieve Text Values
To retrieve text values using HLOOKUP in Excel, you must use the asterisk (*) wildcard. For example, you can use HLOOKUP with the…
Adding Hexadecimal Numbers in Excel
Hexadecimal numbers, also known as hex numbers, are a number system frequently utilized in computing and programming. Unlike the decimal system, which has…
Combining MATCH, INDEX, and OFFSET in Excel
All of the formulas in Excel are great on their own. Better yet, these formulas are even better when combined. In the example…