answersLogoWhite

0

What does the sigma do in Excel?

User Avatar

Anonymous

16y ago
Updated: 8/16/2019

If I understood correctly, you are asking about calculating sigma in MS Excel If A2 is cell has defects and B2 has total number of opportunities. Then copy-paste this formula in C2 cell =IF(A2=0,6,IF(A2=B2,0,IF(B2=0, "DENOMINATOR CANNOT BE ZERO",ROUND((NORMSINV(1-A2/B2)+1.5),2))))

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is the excel formula for a Z test?

Excel has a ZTEST function. It has the format ZTEST(array, µ0, sigma).


What is the sign of sum in Excel?

The representation of SUM is the capital Greek letter SIGMA (Σ).


On a standard toolbar what can be used to enter the sum function in excel?

The Sigma button. Sigma is a Greek letter shaped like the letter, Z, that has gone the wrong way.


What is the name of the button you click to sum cells in Excel?

You use the sum button in excel when you want to add numerous amounts of numbers.


How do I get a six sigma certification?

To earn six sigma certification you must excel in multiple areas of business. You must succeed in project management, presentation skills, statistical thinking, and test methods.


Which icon allows you to insert the sum of a list of numbers on excel?

Google the image of a capital sigma. It is a greek letter that looks similar to an E. it is black in colour


When was Sigma Sigma Rho created?

Sigma Sigma Rho was created in 1998.


What sorority was Carrie Underwood in?

Sigma Sigma Sigma


When was Sigma Mu Sigma created?

Sigma Mu Sigma was created on 1921-03-25.


What is the motto of Kappa Sigma Sigma?

Kappa Sigma Sigma's motto is 'A kappa sig nunquam mendums'.


What is the symbol for autosum?

The symbol for autosum in Excel is a Greek letter sigma (∑) located in the toolbar or ribbon at the top of the application. It is used to quickly add up a range of selected cells in a spreadsheet.


What is Phi Sigma Sigma's motto?

The motto of Phi Sigma Phi is 'Do unto others as you would'.