Wanu San
asked on
Calculating Z-SCORE inside Excel.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you crystal
you're welcome ~ happy to help
ASKER
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