What is the Difference between Standard Deviations and z-scores, calculated within Excel ?

Hi

I want to know what is the exact difference between Standard Deviations and z-scores, with respect to the excel ? Do they represent the same values or what ?

Which one is easy to calculate within excel ? I have data in a column, for one year, each day data in a separate row. And I have to calculate the values which will represent the Standard Deviations and z-scores of

+4
+3
+2
+1
0
-1
-2
-3
-4

Will I get the same result in both the methods ?

Thanks
Wanu SanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dr. KlahnConnect With a Mentor Principal Software EngineerCommented:
The standard deviation is a basic measure of the "scatteredness" of data and it applies to the entire data set.

The z-score is a measure of how many standard deviations away from the mean a raw datum is and it applies to individual values.

Thus the two are not the same.  The standard deviation of the data set must be computed before the z-score of each value can be determined.
1
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
syntax:
Z.TEST(array,x,[sigma])

sigma is optional. If omitted, the sample standard deviation is used.
1
 
Wanu SanAuthor Commented:
Thank you Dr. Klahn and crystal.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.