Z value calculation
Six Sigma – iSixSigma › Forums › Old Forums › General › Z value calculation
- This topic has 5 replies, 5 voices, and was last updated 17 years, 9 months ago by
Wagh.
- AuthorPosts
- December 10, 2002 at 4:38 pm #30990
Logan LuoParticipant@Logan-LuoInclude @Logan-Luo in your post and this person will
be notified via email.I am working on software of process monitoring, which intergrates six sigma measurements. Does anyone have the formula of calculating Z value from DPU? I don’t want to ask user to look for Z value from a table.
Thanks
Logan
0December 10, 2002 at 5:22 pm #81403Logan,
Send me an e-mail link and I can provide an excel template that provides the calculations that you are requesting from two different approaches.
Regards,
Erik0December 10, 2002 at 11:07 pm #81406
Logan LuoParticipant@Logan-LuoInclude @Logan-Luo in your post and this person will
be notified via email.Thanks Erik.
My email: [email protected]
Logan0December 11, 2002 at 6:41 am #81411
SharmaParticipant@AbhishekInclude @Abhishek in your post and this person will
be notified via email.Hi Erik ,
Seems some really useful stuff as even i share the same issue.
I am working with an I T organization.. When we are conducting Six Sigma training sessions for our employees .. they find looking Z values into the tables quite time-consuming & inconvenient .So request you to please share that excel template with me also . My email link is [email protected]
Regards and thanks in advance ,
0December 11, 2002 at 7:26 am #814121 – To find a Z value from a probability p use in EXCEL the following :=NORMSINV(p) and you’ll get the Z value without looking at the table.2 – To find a probability p from a Z value use in Excel the following :=NORMSDIST(z)
0May 24, 2003 at 10:24 am #86305Hi Erik,
Cud u pls share the Excel template . my email is [email protected]0 - AuthorPosts
The forum ‘General’ is closed to new topics and replies.