2 problem excel and word
delport
project1DMUU.docx
Gannon University
Department of Mechanical Engineering
Decision Making Under Uncertainty, GENG 623
Jafar Alsayednasser
Dr: Mahesh C. Aggarwal
Probability is the fundamental science of uncertainty. At whatever point there is something that we don't know without a doubt, our uncertainty can be depicted by probabilities. When we examine probability hypothesis, we are considering uncertainty. To study uncertainty with a spreadsheet-based reproduction, it is valuable to make some uncertainty inside the spreadsheet itself. Knowing this, the originators of Excel gave us one straightforward yet flexible approach to make such uncertainty: the RAND() function, and afterward press the Enter key. A number somewhere in the range of 0 and 1 is dis-played in cell Al. At that point (by mouse or bolt keys) and enter the formula;
=IF(A1<0.5,"Defective","Good")
(The initial equals sign [=] alerts Excel to the fact that what follows is to be interpreted as a mathematical formula, not as a text label. The value of an IF(,,) function is its second parameter if the first parameter is a true statement, but its value is the third parameter if the first is false.)
|
|
Group 1 |
Group 2 |
|
|
|
|
Subgroup 1 |
Subgroup 2 |
|
Nu of people |
30 |
10+20 |
5+30 |
|
Defective % |
0.05 |
0.15 |
0.4 |
|
Assemble % |
0.5 |
0.3 |
0.2 |
|
|
<0.5 |
<0.8 |
>0.8 |
=IF(K7<L5,L4,IF(K7<(L5+M5),M4,N4))
This formula used for the defective percentage of each group in the Excel sheet.
=IF(E34=$H$31,D34,"…..")
This formula used for simulating the table for 1 to 2000 cell.
=COUNT(F34:F2034)
This formula used for the total defective in the Excel sheet.
=SUM(F34:F2034)
This formula used for group 1 defective in the Excel sheet.
=J22/J21
This formula used for Probability defective of the first group in the Excel sheet.
|
Total defective |
219 |
|
Total defective of the first group |
4 |
|
Probability defective of the first group |
0.01843318 |
|
|
|
|
References
WHAT EVERY ENGINEER SHOULD KNOW ABOUT DECISION MAKING UNDER UNCERTAINTY, JOHN X. WANG, CERTIFIDE SIX SIGMA MASTER BLACK BELT CERTIFIED RELIABILITY ENGINEER, ANN ARBOR, MICHIGAN
