1.Calculate the following: Average margin in industry 1, Average turnover industry 6, average turnover industry 10, sum of income industry 9

Sales Industry 1 Company 2 3 1 3.224 23.734 1 1 1 4 5 6 1 1 2 3 3 4 5 6 7 8 9 7 8 9 0.141 0.513 4.426 3.99 29.305 24.033 66.089 17.133 174.01 512.951 -1.149 40.457 215.315 887.245 541.545 540.112 674.314 3386.726 7386.626 1 1 1 10 10 11 12 1 1 2 2 2 2 2 13 14 15 16 17 Investment Income 1.409735483 21.75802149 42.04067211 378.5927608 424.5894653 578.1635577 1209.456373 1397.208844 2417.582167 5859.946852 22.75293304 47.8585295 62.25139281 99.51902666 427.1814783 2489.07476 6236.916668 21310.68739 10784.09774 22553.14818 19685.15626 32946.33587 131638.4636 1.07367938 33.6705354 241.1165172 234.3893771 499.7945015 758.0515591 694.7722288 660.9104697 1038.432233 2488.60286 2030.875117 2 2 2 18 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 19 20 21 22 23 1.594 -1.075 2.218 98.414 170.581 355.6 1054.9 492.115 -393.523 3137.878 2054.523 8273 0.316 1.156 48.098 -17.321 2 2 3 31.184 37.61 39.594 204.168 959.934 2124.988 3567.5 6548.4 4937.063 15724.844 11800.116 22272.895 43604 2.09 11.348 440.804 353.467 84.422 457.374 295.844 1174.7 1509 1559.334 1892.5 24 25 26 3 3 3 3 3 3 3 3 3 27 28 29 30 3 31 32 33 13.641 23.174 -144.207 106.6 -56 141.377 -86 4 4 4 34 4 4 36 37 35 36 37 4 38 3925.3 1445 7082 13649.287 0.542 4 38 4 39 40 41 39 4 40 76.332 4 41 42 42 43 44 45 43 44 5 5 5 5 46 45 46 47 47 48 49 50 51 24.7 197 506 828.786 -0.03 -0.577 -0.721 15.931 7.463 13.557 17.236 56.672 -34.314 137.349 -19.461 55.983 6.499 10.459 241.9 295.078 274.4 167 680.3 4833 -0.105 48 49 6 3755.087504 3592.429569 16047.37107 16284.30182 1.029553252 124.2932249 119.8973355 74.8248633 172.7858617 168.386964 311.0611509 709.6863127 430.2213229 1100.396805 952.118519 1354.906771 1823.276774 3586.412743 3162.653495 3150.373208 2447.844514 4860.042603 8356.342442 29018.87046 1.56346676 16.89531072 31.99035096 55.72558543 65.86606639 68.28566925 99.96601179 288.3825849 385.1040397 904.0504425 50 51 52 53 52 53 54 55 6 6 54 6 194.873 142.298 221.03 168.446 317.017 792.907 307.624 1103.202 1741.779 1752.401 1617.64 2294.533 4071.4 3039.112 5966.9 5390 9611.8 30274 1.637 16.854 22.995 6.715 93.278 112.505 122.696 200.727 656.267 577.247 56 55 6 56 6 57 58 57 6 59 58 6 60 59 6 61 60 1.358 6 61 62 63 7 7 64 62 63 64 7 65 7 4.396 -0.969 15.788 -0.212 1.635 33.138 9.863 4.923 66 65 7 66 7 67 68 67 7 7 69 68 69 7 70 71 72 70 71 72 73 74 8 88 8 8 73 74 75 76 77 76 78 77 79 80 30.9 -112.9 121.38 228.9 1012.14 -0.841 -10.783 -0.832 5.016 3.208 -2.241 -73.282 26.641 79.423 192.248 131.883 -1047.96 788.7 78 79 8 81 80 8 82 9 81 82 83 %828aa8w888992%89%89%ww 83 84 85 86 84 637.887805 1812.34238 1134.739919 4853.009447 17525.547 5.75767493 44.39379986 117.3546549 91.1980114 252.3746893 261.4851901 687.8867749 896.8341029 878.8895513 2208.94644 2743.717447 4624.442031 3559.989496 4418.438574 5643.892269 23822.40596 18563.76329 17.5545982 473.8426893 331.6016618 624.0962484 1848.037891 2292.440195 927.184169 1934.083052 930.0169647 41.50820287 1164.5 1467.7 1193.975 2740.5 12711.744 5.59 39.632 80.442 100.203 79.925 375.096 666.011 406.812 951.466 2205.683 2525.532 3886.072 6643.9 5244 2707.115 7002 12413 26.03 254.134 129.79 589.89 605.841 1700.1 715.656 896.377 421.864044 37.05592 85 9 87 86 88 694 87 88 89 89 90 9 8 88 889999999999wowowowowo 9 90 9 91 92 93 94 91 92 93 10 95 447.212 820 -157 1.863 25.625 13.739 -55.226 -101.614 236.1 -66.637 77.684 27.626717 -10.082105 94 96 97 98 95 96 97 98 99 100 101 10 99 100