Provided by Christ Notes
Bible Search

August 30, 2012

Z-score in Excel

I recently made an Excel udf to calculate the z-score (z-factor or what you would like to call it...) of a HTS plate. If you dare, you can download it here or if you prefer, copy the code below and paste into the VBA editor. The function is tested on Excel 2011 on Mac, but it should work at least with Excel 2010 and I believe also Excel 2007.


Function zscore(pos As Range, neg As Range) As Single
posmean = Application.WorksheetFunction.Average(pos)
negmean = Application.WorksheetFunction.Average(neg)
posstd = Application.WorksheetFunction.StDev(pos)
negstd = Application.WorksheetFunction.StDev(neg)
zscore = 1 - 3 * (posstd + negstd) / Math.Abs(posmean - negmean)
End Function

Posted 7 years, 4 months ago on August 30, 2012
The trackback for this post is disabled

Re: Z-score in Excel
Love Snac! Thank you and I hope you update it! It's a great software for older scanners you are the best!
Posted 7 years, 2 months ago by Raz • • • Reply

Add Comment

( to reply to a comment, click the reply link next to the comment )

 
Comment Title
 
Your Name:
 
Email Address:
Make Public?
 
Website:
Make Public?
 
Comment:

Allowed XHTML tags : a, b, i, strong, code, acrynom, blockquote, abbr. Linebreaks will be converted automatically.