12. Please download the file final.xlsx and refer to Worksheet B. How many of the listed numbers have a first digit less than or equal to 5? 20 23 OOOO 24 27 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.104678 2892.54655 4049.56517 5669.391238 7937.147733 11112.00683 15556.80956 21779.53338 30491.34673 42687.88542 59763.03959 83668.25543 117135.5576 163989.7806 229585.6929 321419.97 449987.9581 629983.1413 881976.3978 1234766.957 1728673.74 2420143.236 3388200.53 4743480.742 6640873.038 Transaction number Quantity 23 47 176 6 11. 80 33 37 29 50 58 167 85 4 25 95 55 57 149 $ 149 $ 147 $ 146 $ 145 $ 144 $ 142 $ 140 $ 139 $ 139 $ 138 $ 138 $ 136 $ 135 $ 135 $ 135 $ 134 $ 132 $ 130 $ 129 $ 128 $ 126 $ 125 $ 122 $ 120 $ 120 $ 118 $ 118 $ 114 $ 113 $ 112 $ 110 $ 106 $ 104 $ 101 $ 19.08 $ 34.19 $ 39.51 $ 26.50 $ 31.59 $ 25.35 $ 37.66 $ 20.60 $ 35.56 $ 23.63 $ 27.55 $ 20.53 $ 31.82 $ 36.52 $ 32.38 $ 39.62 $ 32.12 $ 17.44 $ 39.23 $ 38.06 S 35.99 $ 35.36 $ 28.58 $ 33.43 $ 22.40 $ 33.78 $ 30.81 29.14 $ 38.92 $ 32.29 $ 19.82 $ 22.68 $ 28.49 $ 22.55 $ 34.04 $ 2,842.92 5,094.31 5,807.97 3,869.00 4,580.55 3,650.40 5,347.72 2,884.00 4,942.84 3,284.57 3,801.90 2,833.14 4,327.52 4,930.20 4,371.30 5,348.70 4,304.08 2,302.08 5,099.90 4,909.74 4,606.72 4,455.36 3,572.50 4,078.46 2,688.00 4,053.60 3,635.58 3,438.52 4,436.88 3,648.77 2,219.84 2,494.80 3,019.94 2,345.20 3,438.04 35 34 13 96 53 70 78 100 20 46 30 1 2 3 4 5 6 89 72 2 87 17 69 Worksheet A Worksheet B + 69 19 54 43 83 12 28 45 26 65 91 8 14 90 48 49 98 44 101 $ 100 $ 100 $ 98 $ 98 $ 97 $ 97 $ 97 $ 95 $ 93 $ 93 $ 92 $ 91 $ 89 $ 88 $ 88 $ 87 $ 85 $ 85 $ 84 $ 83 $ 81 $ 81 $ 79 $ 75 $ 73 $ 71 $ 71 $ 70 $ 70 70 69 s 67 $ 66 $ 66 $ 66 5 34.04 $ 20.04 $ 32.98 $ 28.63 $ 38.76 $ 20.70 $ 26.87 $ 24.48 $ 34.21 $ 25.10 $ 33.51 $ 29.92 $ 38.48 $ 20.62 $ 22.96 $ 17.40 $ 25.64 $ 32.39 $ 33.44 $ 31.21 $ 39.77 $ 38.76 $ 25.48 $ 22.84 $ 20.35 $ 32.41 $ 35.38 $ 18.95 $ 39.56 $ 19.08 $ 24.42 $ 20.93 $ 32.32 $ 24.81 $ 34.73 $ 39.72 $ 3,438.04 2,004.00 3,298.00 2,805.74 3,798.48 2,007.90 2,606.39 2,374.56 3,249.95 2,334.30 3,116.43 2,752.64 3,501.68 1,835.18 2,020.48 1,531.20 2,230.68 2,753.15 2,842.40 2,621.64 3,300.91 3,139.56 2,063.88 1,804.36 1,526.25 2,365.93 2,511.98 1,345.45 2,769.20 1,335.60 1,709.40 1,444.17 2,165.44 1,637.46 2,292.18 2,621.52 97 16 31 7 32 3 10 1 36 92 66 W NO 88 9 41 51 64 79 B TH = = = il I'll E = x fx Transaction number D B E F 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 66 $ 64 $ 63 $ 62 $ 60 $ 60 $ 60 $ 58 $ 58 $ 55 $ 55 $ 54 $ 54 $ 51 $ 48 $ 48 $ 46 $ 44 $ 44 $ 43 $ 43 $ 42 $ 39 $ 38 $ 37 S 37 S 33 $ 30 $ +265 26 S 25 $ 39.72 $ 29.06 $ 33.95 $ 38.24 $ 36.79 $ 29.31 $ 19.46 S 34.82 $ 29.08 $ 24.60 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28.48 $ 31.35 $ 17.37 $ 37.52 $ 17.24 S 17.36 $ 32.32 $ 39.16 S 32.21 $ 32.32 $ 29.68 $ 22.93 $ 32.47 $ 26.42 S 37.43 $ 23.14 $ 26.29 $ 2,621.52 1,859.84 2,138.85 2,370.88 2,207.40 1,758.60 1,167,60 2,019,56 1,686.64 1,353.00 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 799.02 1,650.88 758.56 746.48 1,389.76 1,644.72 1,256.19 1,228.16 1,098.16 848.41 1,071.51 792.60 973.18 601.64 657.25 68 82 52 75 15 39 38 62 71 24 60 42 74 63 93 94
