Question 5- Analytical Types of ProductsPerchase amount ($)Age (blanks means we do not know their age)Gender (Male is 1)Family sizeMembership (with membership is 1)Discount card type (0 means no...

files have been attached


Question 5- Analytical Types of ProductsPerchase amount ($)Age (blanks means we do not know their age)Gender (Male is 1)Family sizeMembership (with membership is 1)Discount card type (0 means no card and there are three discount cards 2837.0300302 21533.0371612 31577.0370611 41055.0231213 51279.0391102 51662.0550600 5758.0770301 41015.0251102 31277.0661411 1885.00411 5901.0530212 3757.0220402 4703.0191612 51150.0240202 5971.0430302 21472.0490600 31235.0671202 51183.0600203 51008.0580302 4880.0721301 4683.0421511 31137.0660102 41309.0541403 51313.0430201 2877.0330511 31547.0380401 2694.0400200 31551.0600212 31279.0310601 31121.0380511 11248.0570213 41200.0231303 2972.00500 41403.0761412 11467.0530302 3895.0531202 31181.0331412 1833.0541312 21198.0610511 21105.0631511 3980.0620112 21238.0401111 51280.0631612 1822.0761110 21356.0721413 31295.0530601 31308.0271410 2913.0281202 31257.0741403 4974.0550513 31398.0540512 21431.0531302 1817.0771410 21519.0211103 51393.0610302 41638.0330300 51383.0491512 2978.0291603 31384.0690200 21052.0381102 51518.0621302 3821.0651500 4981.0641102 51275.0721211 31627.0480310 4684.0311603 21214.0240102 1902.0490203 51373.0710203 4758.0341100 51492.0701603 21274.0551412 21523.0460301 2856.0190113 51513.0170110 11373.0601500 41400.0571612 1703.0440513 21537.0371611 41632.0750202 51579.0730511 21458.0460302 4923.0251403 4939.0421201 3992.01100 11027.0501210 51345.0700611 41622.0240202 11107.0470210 41163.0671310 31585.0460310 3694.0310602 31311.0330111 2923.0720102 21312.0481213 21137.0620513 41185.0580100 51480.0350510 2756.0641203 21510.0610513 2804.0190513 2843.0411203 3678.0471312 11661.0661211 4733.0291313 51508.0350300 51547.0770210 4822.0601511 5856.0511410 31567.0340112 11328.0401610 1872.0471211 3724.0721212 21317.0220612 1787.0770403 21043.0481212 31550.0281510 2892.0711601 4719.0320211 1861.0530313 41517.0511611 3949.0310302 51008.0361401 21592.0500301 21567.0510400 3949.0630610 2925.0180611 2979.0411601 31307.0690413 21049.0601213 31563.0231300 51558.0551211 11205.0550210 41148.0510603 3822.0751613 21313.0440113 1717.0491303 31117.0440112 5859.0210102 1986.0750412 51522.0700401 4738.0521200 41381.0260410 2781.0601312 51498.0520610 31389.0611510 4725.0541412 5785.0591612 31608.0541202 21003.0590610 41097.0390512 4854.0450111 31361.0560600 21339.0760500 5898.0260311 31264.0211613 5977.0401611 51079.0320201 31538.0631101 3905.0680613 2940.0471200 5809.0420613 31636.0501303 41293.0381402 31085.0491200 21390.0370112 31025.0701311 51185.0751301 2867.0570203 4764.0271211 41458.0471301 31086.0220313 4981.0691112 4722.0601501 41428.0601402 21414.0530200 5984.0241201 11668.0180211 41005.0350213 21614.0380413 11071.0431413 4907.0451513 51094.0781303 31007.0570311 4672.0281413 51489.0720112 41029.0530112 21637.0371201 31013.0501400 31145.0331300 4897.0421301 4923.0250513 51309.0510301 31332.0651112 51509.0291603 31368.0581613 1738.0601503 3943.0260203 31416.0251112 51135.0660613 3853.0361601 2685.0510612 4885.0300410 5753.0430303 51595.0681500 5680.0770303 51231.0420311 2731.0361210 31549.0320112 31304.0220403 31423.0230200 31386.0550412 21619.0551101 3803.0541512 21356.0270410 21633.0331503 3759.0290313 4716.0350602 3707.0771211 11044.0441403 2927.0710210 11638.0501103 4781.0161613 4946.0521410 3920.0501102 51347.0530111 21244.0190101 2841.0180110 31236.0220501 5835.0390100 41156.0161512 5930.0581500 21628.0630200 41273.0221113 41210.0171402 31021.0750300 31507.0270113 21432.0531213 21586.0710512 51602.0311301 4842.0330202 41606.0390601 41311.0690201 51364.0330311 3718.0271503 21550.0411500 21559.0321611 3952.0500413 21217.0290511 31491.0711312 5768.0470613 41222.0291511 2756.0310511 2705.0620302 2999.0661612 3795.0491112 31563.0441412 1738.0170313 21436.0651613 51178.0470203 41435.0610202 2753.0310113 11438.0710401 31242.0411200 31425.0631412 11077.0591312 51038.0420600 21333.0320211 21643.0310113 51453.0581603 31316.0210302 5799.0671210 4790.0731102 41035.0631312 21528.0261200 41215.0581511 51613.0200611 31662.0210613 11413.0681211 51088.0711612 2920.0300101 41439.0640500 51583.0200102 51316.0211100 51313.0501613 11150.0400101 21393.0390102 31197.0531310 41307.0700613 51547.0541410 21213.0740411 31249.0660513 1970.0531403 41039.0730312 31485.0520411 31648.0741312 4760.0550203 4803.0571410 31501.0630603 31535.0570210 4709.0430102 1873.0301110 31279.0270311 51002.0601100 31605.0500112 41211.0481610 51466.0410112 51014.0740603 51330.0391102 51309.0620100 41656.0680510 51073.0680202 31022.0681211 21345.0440203 31049.0400212 5878.0261303 11197.0591502 21430.0781303 4836.0501512 3785.0440610 21503.0690211 2972.0410502 21231.0641201 31333.0390303 21258.0651110 5691.0471300 21554.0230502 41634.0430511 41428.0290513 31312.0611600 41266.0241600 3884.0190303 21193.0300502 51481.0260201 21364.0571612 2797.0600112 5777.0770112 5911.0380212 51048.0640300 11242.0630302 2678.0261602 31317.0421600 41060.0421601 2846.0241413 4962.0261502 31149.0681411 41598.0771301 4865.0290513 4785.0580210 31663.0731600 21229.0451603 51098.0171411 5782.0190513 51367.0630412 4678.0380103 31114.0301301 41499.0391102 41363.0750411 4930.0660511 21591.0271213 41506.0711600 21622.0770411 41528.0431111 21037.0200202 11362.0200610 3718.0360113 31488.0351201 5677.0640601 11079.0560602 21065.0390300 5729.0310602 4785.0490503 31244.0490101 31169.0181601 31425.0191603 41248.0550500 41457.0691210 2946.0330202 21193.0221213 41640.0580213 11237.0441500 41618.0441312 21510.0491113 11582.0340102 41059.0520610 11240.0471402 41276.0501211 2680.0220400 5672.0470613 41367.0250413 2931.0311101 4815.0541401 41354.0510201 3907.0761401 41016.0361502 11064.0730303 11268.0451110 4686.0440311 21603.0261110 41041.0160110 41566.0421600 5762.0201401 11494.0470513 5937.0331412 41401.0550301 41004.0430403 51586.0451212 41032.0381310 41506.0210611 5988.0470513 21326.0661401 5973.0531602 51493.0190310 3725.0631312 21642.0430612 21589.0471200 11527.0251511 51259.0671400 31275.0760411 21530.0380111 11537.0341203 11669.0711302 5906.0371401 41510.0380300 41611.0580400 31497.0551310 5988.0320611 41435.0491101 1742.0770112 51141.0260413 4690.0491403 11193.0591403 41572.0641411 51246.0381112 2860.0230213 51397.0601211 11298.0540612 41617.0390403 51408.0590301 2854.0460201 51389.0481101 5685.0551510 41023.0751300 51040.0611312 51275.0491602 41068.0750612 31625.0241602 51377.0751210 41663.0761113 41247.0370301 31458.0180213 41565.0781313 11638.0760502 2893.0690403 51235.0300111 5786.0250500 21199.0291511 4879.0350400 51235.0441112 41031.0451202 31396.0251601 11494.0181100 5762.0190303 21345.0310102 4714.0580201 3919.0501500 5875.0391112 41271.0271610 4870.0590501 21460.0450402 3785.0191512 41275.0390310 31669.0431300 11600.0290300 4838.0261112 21424.0441310 21086.0770102 51386.0180411 11485.0700400 51109.0270403 31223.0630501 11181.0201411 51138.0730511 41094.0600501 41297.0600101 21319.0570110 31329.0391210 51658.0731313 31320.0560412 1695.0611200 31078.0740400 31137.0741511 41624.0521102 2815.0460612 3864.0531503 31614.0301201 4890.0551513 21336.0380500 41119.0361202 21071.0580600 Question 6- Analytical Repair time (hours)Cost of Matrials ($)Invoice amount to customer ($)Time of serviceType of repairRepairperson 12.187.0717.0MorningMechanicalJames 4.826.0484.0AfternoonElectricalJames 12.943.0487.0AfternoonMechanicalJames 11.682.0668.0AfternoonElectricalJames 626.0550.0AfternoonMechanicalJames 8.232.0444.0AfternoonElectricalJames 14.713.0982.0MorningElectricalJames 8.337.0382.0MorningElectricalJames 11.20.0526.0MorningMechanicalJames 0.50.0118.0MorningElectricalJames 12.668.0591.0MorningElectricalJohn 9.696.0628.0MorningElectricalJohn 14139.01164.0MorningElectricalJohn 7.630.0336.0MorningElectricalJohn 10.1101.0615.0MorningElectricalJohn 1099.0640.0MorningElectricalJohn 11.274.0974.0AfternoonMechanicalJohn 9.322.0602.0AfternoonMechanicalJohn 9.156.0564.0AfternoonMechanicalJohn 4.617.0307.0MorningMechanicalJohn 10.232.0702.0MorningMechanicalJohn 10.572.0489.0MorningMechanicalJohn 8.593.0644.0MorningMechanicalJohn 10.830.0921.0AfternoonMechanicalJohn 8.90.0661.0AfternoonMechanicalJohn 7.856.0724.0AfternoonMechanicalJohn 8.965.0572.0AfternoonMechanicalJohn 8.328.0581.0AfternoonElectricalJohn 7.4396.0AfternoonElectricalJohn 10.129.0827.0AfternoonElectricalJohn 8.477.0470.0AfternoonElectricalJohn 15.292.0693.0MorningElectricalJohn 13.738.01141.0MorningElectricalJohn 1098.0840.0MorningElectricalJohn 4.114.0354.0AfternoonElectricalJohn 4.536.0321.0AfternoonElectricalJohn 8.585.0500.0AfternoonElectricalJohn 3.730.0215.0MorningElectricalJohn 11.896.0914.0AfternoonMechanicalJohn 10104.0580.0AfternoonMechanicalJohn 5.238.0407.0AfternoonMechanicalJohn 6.416.0330.0AfternoonMechanicalJohn 8.585.0483.0AfternoonMechanicalJohn 7.9535.0AfternoonMechanicalJohn 7.466.0611.0MorningMechanicalJohn 11.326.0755.0MorningMechanicalJohn 15.177.0840.0MorningMechanicalJohn 9.932.0734.0MorningMechanicalJohn 8.227.0412.0MorningMechanicalJohn 4.852.0321.0MorningMechanicalJohn 7.122.0554.0MorningMechanicalBob 15.755.01278.0AfternoonMechanicalBob 9.676.0820.0AfternoonMechanicalBob 21.988.01239.0AfternoonMechanicalBob 15131.0805.0AfternoonElectricalBob 20.4128.01487.0AfternoonElectricalBob 9.18.0728.0AfternoonElectricalBob 19.7198.01184.0AfternoonElectricalBob 21.2139.01626.0AfternoonElectricalBob 20.678.0759.0AfternoonElectricalBob 7.329.0626.0AfternoonElectricalBob 12.994.01119.0MorningElectricalBob 15.9148.0927.0MorningElectricalBob 11.945.0719.0MorningElectricalBob 15.2157.0830.0MorningElectricalBob 16.4177.01248.0MorningElectricalBob 4.527.0429.0ElectricalBob 19.217.01636.0ElectricalBob 15.936.01245.0ElectricalBob 18.635.01365.0ElectricalBob 7.511.0520.0MechanicalBob 14.857.0870.0ElectricalBob 21.512.01390.0MorningElectricalBob 9.233.0459.0MorningMechanicalBob 13.494.0515.0MorningElectricalBob 11.960.0659.0MorningElectricalBob 18.2178.01447.0MorningElectricalBob 5.139.0360.0MorningElectricalBob 8.345.0507.0MorningElectricalBob 1246.0568.0MorningMechanicalBob 9.110.0537.0MorningMechanicalBob 12.8107.0599.0MorningMechanicalBob 10.526.0856.0MorningMechanicalBob 20.271.01393.0MorningMechanicalBob 11.427.0704.0MorningMechanicalBob 13.762.0854.0MorningMechanicalBob 1045.0850.0MorningMechanicalBob 1580.01060.0AfternoonMechanicalBob 18.478.01425.0AfternoonMechanicalBob 12.417.0993.0AfternoonMechanicalBob Question 7 - Analytcs Donor IDDonation DateBlood TypeAgeGender (Male =1)Total Protoean level (g/dL) 1192/1/18O+46M7.53 922/1/18O+43M9.17 932/1/18O+44F6.54 862/1/18O+39M5.60 1982/1/18O+60F8.05 1702/1/18O+58M6.58 442/1/18A+31M6.04 1822/1/18O+60M5.51 242/1/18AB+25F7.37 22/1/18B+23M7.35 942/1/18O+41M7.99 1792/1/18O+58M5.15 1312/1/18O+50M8.42 1352/1/18O+45F7.17 1482/1/18O+49M5.27 1842/1/18O+59M9.47 1582/1/18O+50M4.90 1802/1/18O+61F7.95 1272/1/18O+47M5.96 1002/2/18O+39M6.75 1712/2/18O+57F7.44 182/2/18O-23F7.07 512/2/18A-29F8.12 372/2/18AB-29M7.66 782/2/18O+39F6.67 1432/2/18O+50M8.00 242/2/18AB+23F6.81 382/2/18AB-30M8.51 252/2/18AB+28M6.12 252/2/1824M6.15 702/2/1833M6.86 732/2/1834M5.46 1112/2/1843F9.11 1852/2/1857M5.57 1962/2/18O+59M5.68 22/2/18B+23M9.16 1022/2/18O+41F7.56 1682/2/18O+53F6.07 1052/2/18O+42F10.29 962/2/18O+38F7.47 702/2/18O+36M7.21 1752/2/18O+54M7.06 692/2/18B-37F8.43 792/2/18O+39M5.30 1462/2/18O+48M5.80 1642/2/18O+53M6.20 132/2/18O-28M6.27 892/2/18O+37M6.49 1912/3/18O+63M7.91 52/3/18B+25M7.39 1142/3/18O+48F8.03 192/3/18O-27M7.61 1082/3/18O+45F6.55 732/3/18O+37M7.30 1122/3/18O+44M6.44 672/3/18B-32M6.58 822/3/18O+34M5.79 732/3/18O+39M8.11 852/3/18O+35M9.10 42/3/1825M5.72 1532/3/1856F8.16 1562/3/1855F7.31 472/3/1829M5.71 212/3/1828F5.38 72/3/1824M4.40 1832/3/1859F7.85 1932/3/1862M7.54 1572/3/1850M7.02 1642/3/1858M7.43 172/3/18O-26M5.75 1062/3/18O+39M6.19 1252/3/18O+46M7.81 442/3/18A+28M8.60 1902/3/18O+58M7.06 762/3/18O+38M5.90 1402/3/18O+47M5.15 1312/4/18O+46M9.66 602/4/18B-36F8.65 1992/4/18O+62M8.85 1912/4/18O+60M9.15 1972/4/18O+60M8.43 962/4/18O+37F8.04 1212/4/18O+44M7.02 1772/4/18O+56F7.61 1232/4/18O+49F6.50 562/4/18A-36M7.32 652/4/18B-34M9.57 1562/4/18O+51F6.76 762/4/18O+39M8.15 712/4/18O+37M6.74 1322/4/18O+44F7.82 1242/4/18O+50M6.15 1602/4/18O+50M7.10 1792/4/18O+60M8.41 192/4/18O-28M4.46 1262/4/18O+50F6.38 1312/4/18O+44M7.66 1202/4/18O+47F7.14 172/4/18O-22M7.58 1102/4/18O+42M7.43 682/4/18B-39M7.56 1112/4/18O+46F7.15 622/4/18B-33M6.96 642/4/18B-38M7.10 232/4/18AB+23M6.83 1012/4/18O+38M7.66 1282/4/18O+49M8.48 1932/4/18O+61M7.87 1562/4/18O+53F7.18 412/4/18A+33M7.12 572/4/18A-36F8.11 1302/4/18O+47M5.88 1032/4/18O+43M7.21 1142/4/18O+43F6.10 752/4/18O+39F5.30 1382/4/18O+48F8.79 682/4/18B-34M6.80 2002/4/18B-63M6.37 812/4/18O+41F5.44 1822/4/18O+60M8.04 1982/4/18O+63F4.95 662/4/18B-32F7.24 1962/4/18O+59M6.26 982/4/18O+45M8.15 972/4/18O+38M6.09 1412/4/18O+51F7.36 442/4/18A+33M7.50 452/4/18A+33F5.40 1542/4/18O+53M6.49 1942/4/18O+58M6.30 1272/4/18O+43M5.32 722/5/18O+34F7.03 42/5/18B+21M7.71 1002/5/18O+44M6.06 282/5/18AB+29M6.63 402/5/18A+31M7.78 132/5/18O-23M7.48 1362/5/18O+46M8.96 292/5/18AB+29M9.24 1532/5/18O+50F7.32 1442/5/18O+49F7.61 502/5/18A-33M7.50 502/5/18A-28M7.49 812/5/18O+37F8.51 1572/5/18O+51M6.93 1742/5/18O+53F10.04 842/5/18O+37F5.89 972/6/1840M7.96 812/6/1834F4.59 1032/6/1839M8.20 112/6/18O-26M6.72 1802/6/18O+54F7.35 1592/6/18O+55F8.51 1692/6/18O+59M5.67 1882/6/18O+59M7.30 1332/7/18O+51M4.84 1412/7/18O+52F6.34 572/7/18A-31F7.49 732/7/18O+34M8.11 112/7/18O-24M7.60 1102/7/18O+46M4.60 1082/7/18O+44F8.76 1212/7/18O+45M6.39 132/7/18O-26M7.79 1292/7/18O+45F4.56 1382/7/18O+46F4.53 232/7/18AB+29M7.10 662/7/18B-38F7.29 222/7/18AB+24M8.19 1752/7/18O+58M7.42 1552/7/18O+50M7.19 612/7/18B-34M10.62 1662/7/18O+55M8.91 222/7/18AB+27M6.86 602/7/18B-36F6.12 1902/7/18O+56M8.19 922/7/18O+39M6.77 742/7/18O+40M8.33 1082/7/18O+41F7.72 432/7/18A+28M6.65 422/8/18A+31F7.42 202/8/18AB+27M7.30 1032/8/18O+44M6.85 1162/8/18O+44M7.33 1072/8/18O+43M6.61 452/8/18A+29F8.46 662/8/18B-31F9.81 1172/8/18O+44F5.29 432/8/18A+34M8.70 2002/8/18O+64M6.59 1732/8/18O+60M6.33 542/8/18A-32F9.14 1982/8/18O+58F6.65 292/8/18AB+29M6.24 1022/8/18O+42F7.74 2002/8/18O+63M7.00 1662/8/18O+54M4.98 802/8/18O+37M5.34 462/8/18A+32M7.96 942/8/1843M7.85 1312/8/1846M8.87 1502/8/1855F6.72 1532/9/1856F6.66 172/9/1823M7.21 912/9/1836M6.90 52/9/1823M8.62 482/9/18A+29F6.60 332/9/18AB-32F6.39 1992/9/1860M8.18 132/9/1827M6.01 1292/9/1846F5.84 102/9/18O-22M6.13 172/9/18O-24M7.33 692/9/1839F6.81 1912/9/18O+63M7.64 1892/9/18O+62F9.43 1862/9/18O+61F 912/9/18O+42M7.02 1802/9/18O+57F6.39 1582/9/18O+56M5.88 1422/9/18O+53M8.31 1642/9/18O+56M9.47 822/9/18O+34M8.75 1092/9/18O+42M8.80 1782/9/18O+56M7.81 1702/9/18O+56M7.20 1212/9/18O+45M5.24 152/9/18O-27F8.48 1182/9/18O+45M6.27 662/9/18B-36F8.62 812/9/18O+37F8.23 782/9/18O+40F6.40 1962/9/18O+61M8.77 1962/9/18O+63M6.88 1192/9/18O+42M7.89 1312/9/18O+51M8.13 1132/9/18O+43M5.41 1373/15/18O+52M6.67 1773/15/18O+58F7.17 573/15/18A-34F7.61 523/15/18A-35M5.92 1683/15/18O+54F9.79 1033/15/18O+39M6.95 343/15/18AB-29M4.57 1813/15/18O+56M7.90 1983/15/18O+63F6.10 893/15/18O+36M7.32 1913/15/18O+58M7.04 883/15/18O+39M8.78 473/15/18A+34M9.26 1403/15/18O+47M6.27 1193/15/18O+42M8.40 1893/15/18O+59F6.29 1103/15/18O+46M5.13 493/16/18A+28M6.84 1963/16/18O+63M6.09 1663/16/18O+55M8.68 373/16/18AB-30M8.03 1863/16/18O+58F6.25 1083/16/18O+41F9.07 533/16/18A-36M6.72 293/16/18AB+28M9.93 513/16/18A-28F9.16 823/16/18O+39M7.65 613/16/18B-35M8.08 1023/16/18O+42F6.66 903/16/18O+41F7.15 993/16/18O+39F8.65 1563/16/18O+52F6.37 503/16/18A-28M6.37 513/16/18A-34F7.29 1053/16/18O+39F8.07 1473/16/18O+47F6.94 403/16/18A+28M8.65 1763/17/18O+53M6.44 483/17/18A+29F6.34 713/17/18O+35M4.93 1623/17/18O+52F7.33 953/17/18O+41M4.00 1263/17/18O+43F8.52 563/17/18A-31M5.95 983/17/18O+39M8.86 1653/17/18O+54F7.38 1003/17/18O+42M7.69 733/17/18O+40M7.14 703/17/18O+35M7.85 1743/17/18O+58F6.52 43/17/18B+20M6.11 1553/17/18O+53M7.94 1393/18/18O+50M8.22 873/18/18O+40F7.15 303/18/18AB-30F7.23 693/18/18B-32F9.47
May 22, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here