Improve company productivity with a Business Account.Sign Up

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

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
0
Wanu San
Asked:
Wanu San
  • 2
  • 2
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
1
 
Wanu SanAuthor Commented:
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
 
Wanu SanAuthor Commented:
Thank you crystal
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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