Results 1 to 11 of 11

VBA Code for Six Sigma Calculation

Threaded View

farhanthaheem VBA Code for Six Sigma... 03-19-2024, 04:06 AM
Glenn Kennedy Re: BVA Code for Six Sigma... 03-19-2024, 04:18 AM
farhanthaheem Re: BVA Code for Six Sigma... 03-19-2024, 04:24 AM
bebo021999 Re: BVA Code for Six Sigma... 03-19-2024, 04:27 AM
farhanthaheem Re: BVA Code for Six Sigma... 03-19-2024, 05:06 AM
bebo021999 Re: BVA Code for Six Sigma... 03-19-2024, 05:32 AM
farhanthaheem Re: BVA Code for Six Sigma... 03-19-2024, 05:41 AM
Glenn Kennedy Re: BVA Code for Six Sigma... 03-19-2024, 04:28 AM
farhanthaheem Re: BVA Code for Six Sigma... 03-19-2024, 05:43 AM
JohnTopley Re: BVA Code for Six Sigma... 03-19-2024, 05:55 AM
farhanthaheem Re: BVA Code for Six Sigma... 03-19-2024, 10:48 AM
  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    29

    Post VBA Code for Six Sigma Calculation

    I have defect percentage in column F and I want to calculate Six Sigma Level corresponding to defect value

    I am using below formula in excel and that giving me correct sigma level
    =IFERROR(NORMSINV(1-F5)+1.5,"0")

    F5 has defect percentage in excel sheet

    Example;

    Defect % Sigma Level
    0.0230% 5.00
    0.0210% 5.03
    0.0180% 5.07
    0.0160% 5.10
    0.0140% 5.13
    0.0120% 5.17
    0.0090% 5.25
    0.0070% 5.31
    0.0050% 5.39
    0.0030% 5.51

    I have been trying to create VBA code but not able find correct sigma level, may be because of NORMSINV function not available.
    Please help me to resolve. I need VBA code so that sigma level is calculated for each row having defect percentage only.
    Last edited by farhanthaheem; 03-19-2024 at 05:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sigma
    By a.janmohammadi in forum Excel General
    Replies: 3
    Last Post: 11-10-2014, 11:52 AM
  2. [SOLVED] Sigma Function
    By ganesh81289 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2012, 12:37 PM
  3. mathematic Sigma
    By eliziki in forum Excel General
    Replies: 3
    Last Post: 04-16-2007, 06:08 AM
  4. how do I get STDEV() 2 sigma?
    By jimbo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-25-2006, 03:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1