Z-score is also known as the standard score. The statistical formula for a value's z-score is calculated using the following formula: Where: Calculating a z-score requires that you first determine ...

A basic formula might look like this ... you can start using them in your spreadsheet to automate repetitive calculations, derive insights from raw information, and even solve real-life problems.