We get it. Statistics can be *intimidating*. All those numbers and all those graphs and all of the rules on how to interpret everything - it's enough to make your head spin. Which is why we're happy to tell you that some things *can* be less stressful with the use of modern technology. Specifically, the little helper we're talking about is - no surprise - Microsoft Excel. Keep scrolling to learn everything you need to know about how to calculate z score in Excel. You'll be glad you did. It's easier than you think to learn how to calculate z score in Excel!

## Z-Score Fundamentals

First things first! We need to break down the whole concept of a z score. Getting some clarity on the topic will make it that much easier to learn how to calculate a z-score in Excel when the time comes. You have to learn to walk before you can run, right?

__What Is a Z Score__?

__What Does a Z Score Do__?

__Easy Real World Z Score Example__

## The Z Score Formula

Actually, depending on what you're using the z score for, there are two different z score formulas to choose from - and choosing the right formula is important. But rest assured that for any z score formula you will need two numbers: the mean (μ) and also the population standard deviation (σ). You will need both of these when you learn how to calculate the z-score in Excel.

__The Basic Z Score Formula__

__Standard Error of the Mean__

## How to Calculate the Z Score in Excel

Now that you know what a z score is and the basic formula you will be using, it's time to learn how to calculate z score in Excel. Be prepared by having your data points easily accessible and be forewarned that there will be a lot of data entry. Just as a reminder - double check your numbers and always calculate your z score twice!

#### Step 1: Open Excel

#### Step 2: Enter the Mean Formula

#### Step 3: Enter the Standard Deviation Formula

#### Step 4: Finding the Z-Score

## Conclusion

*image source: unsplash.com via **Helloquence*

See how easy that was? Learning how to calculate z score in Excel is a cakewalk because Excel does all the really hard work for you. Of course, the job of interpreting what the z score means still falls to your shoulders, but at least you don't have to make your head ache by hand-writing and calculating the z score formula. Simply use Excel to find your mean formula and your standard deviation, and then you're only one simple input away from finding the z score for any point of data you want.

Still not seeming so simple? Try it for yourself! Trust us, it gets easier after inputting the formula a few times!

*Featured Photo by rawpixel.com from **Pexels*