Solved

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

Posted on 2016-10-20
3
107 Views
Last Modified: 2016-10-24
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
Comment
Question by:Wanu San
3 Comments
 
LVL 26

Accepted Solution

by:
Dr. Klahn earned 400 total points
ID: 41853171
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
 
LVL 19

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 100 total points
ID: 41853178
syntax:
Z.TEST(array,x,[sigma])

sigma is optional. If omitted, the sample standard deviation is used.
1
 

Author Comment

by:Wanu San
ID: 41855748
Thank you Dr. Klahn and crystal.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article provides a brief introduction to tissue engineering, the process by which organs can be grown artificially. It covers the problems with organ transplants, the tissue engineering process, and the current successes and problems of the tec…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question