[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

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
0
Wanu San
Asked:
Wanu San
2 Solutions
 
Dr. KlahnPrincipal 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, AccessRemote 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now