topic NORMINV Function in QlikView https://community.qlik.com/t5/QlikView/NORMINV-Function/m-p/584625#M217025 <HTML><HEAD></HEAD><BODY><P>Is there anyone who is familiar with the NORMINV (inverse of Normal Distribution calculation) as it relates to the same function (NORMSINV) in MS Excel? I am trying to calculate the process sigma of complaints vs shipments.</P><P></P><P>The formula using NORMSINV (Excel) as follows: =(1- NORMSINV(1-((Total Defects) / (Total Opportunities))) + 1.5.</P><P></P><P>The NORMSINV function is QlikView is: =(NORMINV, prob, mean, std dev).</P><P></P><P>I would rather not calculate this in Excel and then load the table into QlikView. I'd rather load the data table listing Sites, Years, Period, Complaints and Shipments and make the calculation in QlikView. That will prevent me from having to update the spreadsheet before reloading. </P><P>Thanks in advance for any help with this one.</P><P></P><P>Jeff</P></BODY></HTML> Mon, 17 Mar 2014 16:39:38 GMT jmonroe918 2014-03-17T16:39:38Z NORMINV Function https://community.qlik.com/t5/QlikView/NORMINV-Function/m-p/584625#M217025 <HTML><HEAD></HEAD><BODY><P>Is there anyone who is familiar with the NORMINV (inverse of Normal Distribution calculation) as it relates to the same function (NORMSINV) in MS Excel? I am trying to calculate the process sigma of complaints vs shipments.</P><P></P><P>The formula using NORMSINV (Excel) as follows: =(1- NORMSINV(1-((Total Defects) / (Total Opportunities))) + 1.5.</P><P></P><P>The NORMSINV function is QlikView is: =(NORMINV, prob, mean, std dev).</P><P></P><P>I would rather not calculate this in Excel and then load the table into QlikView. I'd rather load the data table listing Sites, Years, Period, Complaints and Shipments and make the calculation in QlikView. That will prevent me from having to update the spreadsheet before reloading. </P><P>Thanks in advance for any help with this one.</P><P></P><P>Jeff</P></BODY></HTML> Mon, 17 Mar 2014 16:39:38 GMT https://community.qlik.com/t5/QlikView/NORMINV-Function/m-p/584625#M217025 jmonroe918 2014-03-17T16:39:38Z Re: NORMINV Function https://community.qlik.com/t5/QlikView/NORMINV-Function/m-p/584626#M217026 <HTML><HEAD></HEAD><BODY><P>=NORMINV(1-Yield,0,1)-1.5</P><P></P><P>Where yield is your Defect per million expressed as a %</P></BODY></HTML> Wed, 16 Jul 2014 21:15:31 GMT https://community.qlik.com/t5/QlikView/NORMINV-Function/m-p/584626#M217026 2014-07-16T21:15:31Z