Solved

Calculating Z-SCORE inside Excel.

Posted on 2016-10-24
4
48 Views
Last Modified: 2016-11-04
Hi

I need to calculate the Z-SCORE Values that would represent the Values of

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

based on the data that I have in Column J. The formulas needs to be kept inside the Orange Box in Column J itself. I have attached the sample excel sheet with the data.

Please check the following thread for reference -
https://www.experts-exchange.com/questions/28977905/What-is-the-Difference-between-Standard-Deviations-and-z-scores-calculated-within-Excel.html

I am using Excel 2016 Professional Plus x64

Thanks
Z-Score.xlsx
0
Comment
Question by:Wanu San
  • 2
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
Comment Utility
1
 

Author Comment

by:Wanu San
Comment Utility
Thank you crystal. I followed all the steps and was able to calculate the Z-SCORE Values for each of the data points, as shown in this snap -
z.png
But I am still puzzled regarding the last part. Now how do I get the Z-SCORE Values from +4 to zero to -4, in the orange box ? I have attached the updated excel sheet as well.

Best Regards
Z-Score---UPDATED.xlsx
0
 

Author Closing Comment

by:Wanu San
Comment Utility
Thank you crystal
0
 
LVL 18
Comment Utility
you're welcome ~ happy to help
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

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 …
Article by: Nicole
This is a research brief on the potential colonization of humans on Mars.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now