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 15 years, 3 months ago on August 30, 2012
The trackback for this post is disabled
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 2 weeks, 5 days ago by Raz • • • Reply
Posted 2 weeks, 5 days ago by Raz • • • Reply
Navigation
Sections
Donations
On user request I have added a "Donate" button. If you would like to donate to me through PayPal, you could use the following button:
Props: