Solved

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

Posted on 2016-10-20
3
83 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 25

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Have you ever thought of installing a power system that generates solar electricity to power your house? Some may say yes, while others may tell me no. But have you noticed that people around you are now considering installing such systems in their …
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 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