weld type ID,weld type,number of welds,number of inspected welds,number of failed welds,work proportion,inspection rate 1,"2,XS,Material A",37042,7475,281, XXXXXXXXXX, XXXXXXXXXX 2,"10,STD,Material...

1 answer below »
R


weld type ID,weld type,number of welds,number of inspected welds,number of failed welds,work proportion,inspection rate 1,"2,XS,Material A",37042,7475,281,0.16570562,0.201797959 2,"10,STD,Material A",19451,4494,196,0.087013121,0.231042106 3,"13,STD,Material A",14851,3516,59,0.06643524,0.236751734 4,"1,STD,Material A",13011,3078,96,0.058204088,0.236569057 5,"2,STD,Material A",10303,4722,442,0.046089979,0.458313113 6,"13,XS,Material A",9897,3703,98,0.044273757,0.374153784 7,"14,STD,Material A",8698,2295,66,0.038910088,0.263853759 8,"1,XS,Material A",8595,1774,30,0.038449322,0.206399069 9,"2,160,Material A",6040,2302,68,0.027019652,0.381125828 10,"2,80,Material A",5851,1055,43,0.026174169,0.180311058 11,"15,STD,Material A",4798,1131,35,0.021463624,0.235723218 12,"6,STD,Material A",4709,1067,44,0.021065487,0.226587386 13,"10,XS,Material A",3731,1484,23,0.016690451,0.397748593 14,"14,XS,Material A",3186,1317,14,0.014252419,0.413370998 15,"2,40S,Material C",2431,555,24,0.010874963,0.228301111 16,"2,40,Material A",2088,271,38,0.009340568,0.129789272 17,"1,80,Material A",2055,638,8,0.009192944,0.310462287 18,"10,160,Material A",1675,510,8,0.007493033,0.304477612 19,"13,40,Material A",1671,333,5,0.007475139,0.199281867 20,"15,XS,Material A",1655,528,19,0.007403564,0.319033233 21,"6,XS,Material A",1641,666,37,0.007340935,0.405850091 22,"1,40,Material A",1550,592,38,0.006933851,0.381935484 23,"10,40S,Material C",1441,364,6,0.006446245,0.252602359 24,"10,80,Material A",1436,512,11,0.006423877,0.356545961 25,"14,40,Material A",1411,451,29,0.006312041,0.319631467 26,"13,80,Material A",1407,572,6,0.006294147,0.406538735 27,"4,STD,Material A",1393,419,16,0.006231519,0.300789663 28,"10,40,Material A",1358,217,6,0.006074948,0.159793814 29,"2,10S,Material C",1261,175,16,0.005641023,0.138778747 30,"1,40S,Material C",1251,271,3,0.005596289,0.216626699 31,"13,40S,Material C",1128,171,4,0.005046054,0.151595745 32,"10,10S,Material C",1116,149,9,0.004992373,0.133512545 33,"4,80,Material A",958,633,12,0.004285567,0.660751566 34,"7,STD,Material A",914,265,10,0.004088735,0.289934354 35,"14,10S,Material C",912,204,13,0.004079788,0.223684211 36,"13,10S,Material C",911,154,5,0.004075315,0.169045005 37,"26,STD,Material A",858,237,14,0.003838222,0.276223776 38,"2,XS,Material B",841,719,148,0.003762173,0.854934602 39,"1,STD,Material C",799,311,5,0.003574288,0.389236546 40,"4,XS,Material A",781,143,6,0.003493766,0.183098592 41,"15,40,Material A",773,170,5,0.003457979,0.21992238 42,"8,STD,Material A",767,215,7,0.003431138,0.280312907 43,"1,160,Material A",765,152,3,0.003422191,0.19869281 44,"15,40S,Material C",720,99,6,0.003220886,0.1375 45,"16,STD,Material A",704,107,5,0.00314931,0.151988636 46,"13,120,Material A",700,505,16,0.003131417,0.721428571 47,"8,XS,Material A",684,400,20,0.003059841,0.584795322 48,"2,XS,Material C",664,249,2,0.002970372,0.375 49,"14,STD,Material C",658,172,9,0.002943532,0.261398176 50,"13,STD,Material C",656,130,1,0.002934585,0.198170732 51,"15,160,Material A",652,607,8,0.002916691,0.930981595 52,"15,80,Material A",640,294,5,0.002863009,0.459375 53,"14,40S,Material C",628,114,7,0.002809328,0.181528662 54,"10,STD,Material C",611,101,3,0.002733279,0.165302782 55,"9,160,Material A",542,344,6,0.002424611,0.634686347 56,"2,XXS,Material A",540,131,2,0.002415664,0.242592593 57,"1,10S,Material C",537,106,10,0.002402244,0.197392924 58,"13,XS,Material B",528,274,113,0.002361983,0.518939394 59,"4,40S,Material C",489,105,10,0.002187518,0.214723926 60,"28,STD,Material A",486,88,4,0.002174098,0.181069959 61,"1,XS,Material B",485,380,140,0.002169624,0.783505155 62,"14,80,Material A",470,257,2,0.002102523,0.546808511 63,"6,40S,Material C",468,99,7,0.002093576,0.211538462 64,"16,XS,Material A",449,152,9,0.00200858,0.338530067 65,"2,80,Material B",442,59,0,0.001977266,0.133484163 66,"21,160,Material C",440,437,6,0.001968319,0.993181818 67,"2,160,Material B",417,342,174,0.00186543,0.820143885 68,"15,STD,Material C",403,75,7,0.001802801,0.186104218 69,"2,STD,Material C",395,39,2,0.001767014,0.098734177 70,"9,80S,Material C",379,65,0,0.001695438,0.171503958 71,"2,160,Material C",378,365,3,0.001690965,0.965608466 72,"6,80,Material A",355,275,7,0.001588076,0.774647887 73,"13,STD,Material B",355,348,44,0.001588076,0.98028169 74,"15,60,Material B",344,107,0,0.001538868,0.311046512 75,"1,120,Material A",342,128,1,0.001529921,0.374269006 76,"7,XS,Material A",339,78,2,0.0015165,0.230088496 77,"10,XS,Material B",324,77,34,0.001449399,0.237654321 78,"14,STD,Material B",317,313,80,0.001418084,0.987381703 79,"8,40S,Material C",309,45,3,0.001382297,0.145631068 80,"26,40,Material A",296,84,1,0.001324142,0.283783784 81,"13,160,Material A",289,209,7,0.001292828,0.723183391 82,"15,10S,Material C",284,77,4,0.00127046,0.271126761 83,"1,STD,Material B",282,280,47,0.001261514,0.992907801 84,"9,XS,Material A",260,122,4,0.001163098,0.469230769 85,"10,STD,Material B",253,253,59,0.001131783,1 86,"15,STD,Material B",245,242,112,0.001095996,0.987755102 87,"4,40,Material A",240,42,1,0.001073629,0.175 88,"14,160,Material A",237,228,2,0.001060208,0.962025316 89,"6,120,Material B",233,202,0,0.001042314,0.86695279 90,"21,40S,Material C",229,19,2,0.001024421,0.082969432 91,"26,XS,Material A",225,62,3,0.001006527,0.275555556 92,"26,60,Material A",219,56,0,0.000979686,0.255707763 93,"6,10S,Material C",219,38,2,0.000979686,0.173515982 94,"16,20,Material A",218,39,1,0.000975213,0.178899083 95,"21,80S,Material C",216,59,3,0.000966266,0.273148148 96,"16,40,Material A",207,21,0,0.000926005,0.101449275 97,"14,80,Material B",203,82,0,0.000908111,0.403940887 98,"8,30,Material A",203,39,1,0.000908111,0.192118227 99,"26,120,Material A",197,193,1,0.00088127,0.979695431 100,"28,XS,Material A",196,97,8,0.000876797,0.494897959 101,"10,XXS,Material A",191,79,0,0.000854429,0.413612565 102,"6,120,Material A",189,153,1,0.000845482,0.80952381 103,"15,60,Material A",186,69,11,0.000832062,0.370967742 104,"7,40S,Material C",176,49,4,0.000787328,0.278409091 105,"4,10S,Material C",176,53,3,0.000787328,0.301136364 106,"2,80S,Material C",175,132,3,0.000782854,0.754285714 107,"13,XXS,Material C",172,172,4,0.000769434,1 108,"10,80,Material B",164,36,1,0.000733646,0.219512195 109,"16,40S,Material C",162,37,0,0.000724699,0.228395062 110,"10,160,Material B",156,143,13,0.000697859,0.916666667 111,"6,60,Material A",155,39,1,0.000693385,0.251612903 112,"23,80S,Material C",155,56,2,0.000693385,0.361290323 113,"28,3/4"",Material A",150,61,5,0.000671018,0.406666667 114,"25,STD,Material A",150,46,2,0.000671018,0.306666667 115,"26,40S,Material C",147,27,2,0.000657597,0.183673469 116,"10,XXS,Material C",144,144,7,0.000644177,1 117,"21,160,Material A",143,62,1,0.000639704,0.433566434 118,"6,XS,Material B",139,66,8,0.00062181,0.474820144 119,"9,160,Material C",137,130,4,0.000612863,0.948905109 120,"16,60,Material A",130,14,0,0.000581549,0.107692308 121,"4,120,Material B",128,128,3,0.000572602,1 122,"26,XS,Material B",128,90,73,0.000572602,0.703125 123,"14,100,Material A",128,13,0,0.000572602,0.1015625 124,"28,3/8"",Material C",123,46,8,0.000550235,0.37398374 125,"8,40,Material A",120,18,1,0.000536814,0.15 126,"29,0.625"",Material A",120,106,11,0.000536814,0.883333333 127,"15,120,Material C",119,119,4,0.000532341,1 128,"2,80,Material D",117,117,8,0.000523394,1 129,"14,XS,Material B",115,108,57,0.000514447,0.939130435 130,"13,120,Material C",114,81,3,0.000509974,0.710526316 131,"26,80S,Material C",113,31,1,0.0005055,0.274336283 132,"28,0.688"",Material A",113,96,13,0.0005055,0.849557522 133,"14,120,Material A",112,96,2,0.000501027,0.857142857 134,"6,100,Material A",111,65,0,0.000496553,0.585585586 135,"13,40,Material C",110,13,2,0.00049208,0.118181818 136,"15,120,Material A",105,98,0,0.000469712,0.933333333 137,"25,0.875"",Material A",105,13,0,0.000469712,0.123809524 138,"14,XS,Material C",104,72,3,0.000465239,0.692307692 139,"1,XXS,Material B",101,32,0,0.000451819,0.316831683 140,"10,XXS,Material B",99,34,21,0.000442872,0.343434343 141,"1,80,Material B",98,30,0,0.000438398,0.306122449 142,"23,160,Material A",96,36,1,0.000429451,0.375 143,"28,3/8"",Material A",96,27,2,0.000429451,0.28125 144,"15,100,Material A",95,57,1,0.000424978,0.6 145,"6,STD,Material C",93,20,0,0.000416031,0.215053763 146,"2,40,Material C",93,5,0,0.000416031,0.053763441 147,"44,STD,Material C",92,21,1,0.000411558,0.22826087 148,"2,XXS,Material B",91,14,4,0.000407084,0.153846154 149,"26,20,Material A",91,19,1,0.000407084,0.208791209 150,"7,40,Material A",87,11,0,0.00038919,0.126436782 151,"15,100,Material C",87,85,0,0.00038919,0.977011494 152,"67,XS,Material A",86,21,2,0.000384717,0.244186047 153,"23,XS,Material A",85,6,1,0.000380243,0.070588235 154,"13,XXS,Material B",85,42,10,0.000380243,0.494117647 155,"7,60,Material A",84,14,3,0.00037577,0.166666667 156,"15,140,Material A",82,21,0,0.000366823,0.256097561 157,"4,60,Material A",78,21,0,0.000348929,0.269230769 158,"8,10,Material C",76,16,0,0.000339982,0.210526316 159,"16,10S,Material C",76,59,5,0.000339982,0.776315789 160,"67,STD,Material A",76,12,1,0.000339982,0.157894737 161,"7,30,Material B",75,23,0,0.000335509,0.306666667 162,"10,40,Material C",75,10,0,0.000335509,0.133333333 163,"1,40,Material B",74,17,0,0.000331035,0.22972973 164,"1,120,Material B",71,58,18,0.000317615,0.816901408 165,"27,STD,Material A",71,18,1,0.000317615,0.253521127 166,"16,80
Answered Same DayOct 28, 2021

Answer To: weld type ID,weld type,number of welds,number of inspected welds,number of failed welds,work...

Abr Writing answered on Oct 29 2021
161 Votes
CEIE 474 Assignment solution.docx
CEIE 474/574 Construction Computer Application and Informatics
Assignment 5 Solution
STEP 1
1. To account for the 80 percent of the business we have almost 631 weld types with their different w
ork proportions and their own failed, inspection and repair rate. Each weld type has different purpose in the field of the construction.
2. To visualize the weld types we have to import the dataset first in the R and then we will use the library ggplot to visualize the dataset. The visualization of the dataset will look like below;
In the above plot we can clearly see that weld types are decreasing from 600 to 0 which shows that the lower the use of them in the construction while the decreasing weld type also shows increased number of work proportions.
Hence we can say that the number shows the intensity of weld flame the higher the number means higher the risk to eye and other delicate parts of the human body and that is why they are least used.
STEP 2
1. The beta distribution calculation contains some parameters of the tables like number of welds and failed welds and inspected welds number etc. after collecting all the data simply run the pbeta and qbeta command also to create the table we have to combine the values of weld id, weld type and the values of a and b in one table which looks like below.
2. To visualize the data of the top welds we simply have to run the plot command for the values we have calculated for the beta distribution and it will give the graph which looks like below;
The plot for the beta distribution will look like below;

STEP 3
1. To calculate the confidence interval we first have to define the upper and lower limit of the given dataset which can be calculated by the qbeta function after finding out the values the we simply has to calculate the error and then add it with upper limit while subtract with the lower limit and hence we can easily find out the confidence interval of the dataset. The table looks like below after combining the values.
2. The plot of the dataset after the confidence interval is achieved will look like below;
STEP 4
1. To plot the histogram first we have to define the repair rate of the data with the 10000 samples then we have to calculate the beta values of the samples and then we...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here