mechanical lab

profilepie18k
MENG468Lab5kjpChart_ChexMix.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>mechanical lab

Data

MENG 468 QA & Lean Chex-Mix Lab Data Collection
Team Members: AbdulKarim, Mohammed, Zach, Alix
Good Bad Criteria:
Gross Weight (g): 432.5
Tare Weight (g): 6.5
Product Weight (g): 426
Weight (g) Count
Type Good Bad Total % of Product % Good P P-Bar UCL LCL Good Bad Total % Good P P-Bar UCL LCL
Round Pretzel 15 1 16 0.0375586854 0.9375 0.0625 0.2377030142 0.5569602206 -0.0815541922 12.5 0.09 12.59 0.9928514694 0.0071485306 0.1472050742 0.4467707729 -0.1523606245
Square Pretzel 7 2 9 0.0211267606 0.7777777778 0.2222222222 0.2377030142 0.6633792894 -0.187973261 6.5 0.9 7.4 0.8783783784 0.1216216216 0.1472050742 0.5379461689 -0.2435360205
Bread Stick 59 15 74 0.1737089202 0.7972972973 0.2027027027 0.2377030142 0.3861545998 0.0892514286 42 4 46 0.9130434783 0.0869565217 0.1472050742 0.3039256552 -0.0095155068
Yellow Chex 268 56 324 0.7605633803 0.8271604938 0.1728395062 0.2377030142 0.3086490601 0.1667569684 138.5 17 155.5 0.8906752412 0.1093247588 0.1472050742 0.2324443502 0.0619657982
Brown Chex 287 87 374 0.8779342723 0.7673796791 0.2326203209 0.2377030142 0.3037366028 0.1716694257 126 34 160 0.7875 0.2125 0.1472050742 0.231237124 0.0631730244
Brown Chip 21 24 45 0.1056338028 0.4666666667 0.5333333333 0.2377030142 0.4280712318 0.0473347967 26.5 14 40.5 0.6543209877 0.3456790123 0.1472050742 0.3142285192 -0.0198183708
Total Chex 555 143 698 1.6384976526 0.7951289398 264.5 51 315.5 0.8383518225
Totals 657 185 842 352 69.99 421.99
2 p charts in excel
2 p charts in minitab
stat>control chart>attribute chart>P (second one)
variables: select defective one
subgroup: select total
option > test > all tests

P-Chart for Weight(g)

P 6.25E-2 0.22222222222222221 0.20270270270270271 0.1728395061728395 0.23262032085561499 0.53333333333333333 P-Bar 0.23770301421445214 0.23770301421445214 0.23770301421445214 0.23770301421445214 0.23770301421445214 0.23770301421445214 UCL 0.55696022059654238 0.66337928939057245 0.38615459978991684 0.30864906007713888 0.3037366027594034 0.4280712317549944 LCL -8.1554192167638068E-2 -0.18797326096166814 8.925142863898744E-2 0.16675696835176543 0.17166942566950089 4.7334796673909912E-2

P-Chart for Count

P 7.1485305798252583E-3 0.12162162162162161 8.6956521739130432E-2 0.10932475884244373 0.21249999999999999 0.34567901234567899 P-Bar 0.14720507418811668 0.14720507418811668 0.14720507418811668 0.14720507418811668 0.14720507418811668 0.14720507418811668 UCL 0.44677077291686684 0.53794616889608271 0.30392565515201825 0.23244435015002984 0.23123712398507248 0.3142285191966861 LCL -0.15236062454063348 -0.24353602051984935 -9.5155067757848877E-3 6.1965798226203517E-2 6.3173024391160876E-2 -1.9818370820452735E-2

Visual Ruler