Using the attached spreadsheet please answer the following questions. I'm looking for good accurate answers. I will extend the timeline and price if needed.

18.

Please download the file final.xlsx and refer to the Problems 18-21 worksheet.

Transaction 12 was the ___th largest transaction in terms of the Total.

Enter just the cardinal number; e.g., 9

19.

Again refer to the Problems 18-21 worksheet. The average (mean) quantity sold per transaction is _________.

Round your answer to the nearest whole number, and enter just the number; e.g., enter 71.5 as 72

20.

Again refer to the Problems 18-21 worksheet. The standard deviation (assume that the dataset represents a sample, not a population) of the quantity sold per transaction is ________.

Round your answer to the nearest whole number, and enter just the number; e.g., enter 71.5 as 72.

21.

Again refer to the Problems 18-21 worksheet. The fifth largest transaction in terms of quantity sold is transaction number ____.

23.

Please refer to the Problems 23-25 worksheet from the file final.xlsx. The sum of the first digits of all numbers listed in column A is ____. (For example, the first number has a first digit of 1.)

Enter just the number; e.g., 218

24.

Again refer to the Problems 23-25 worksheet. The sum of the second digits of all numbers listed in column A is ___. (For example, the second number listed has a second digit of 4.)

Enter just the number; e.g., 91

25.

Again refer to the Problems 23-25 worksheet. How many of the listed numbers have a first digit less than or equal to 4?

Enter just the number; e.g., 76

Transaction number 23 47 76 6 11 80 33 37 29 50 58 67 85 4 25 95 55 57 35 34 13 96 53 70 78 100 20 46 30 89 72 2 87 17 69 19 54 43 83 12 28 45 26 65 91 8 14 Quantity 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 100 100 98 98 97 97 97 95 93 93 92 91 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Unit price 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 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 20.04 32.98 28.63 38.76 20.70 26.87 24.48 34.21 25.10 33.51 29.92 38.48 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total 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 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 90 48 49 98 44 97 16 31 7 32 3 10 1 36 92 66 73 88 9 41 51 64 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 68 82 52 75 15 39 38 62 71 24 60 89 88 88 87 85 85 84 83 81 81 79 75 73 71 71 70 70 70 69 67 66 66 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 37 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 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 29.06 33.95 38.24 36.79 29.31 19.46 34.82 29.08 24.60 35.06 18.31 31.94 21.65 28.48 31.35 17.37 37.52 17.24 17.36 32.32 39.16 32.21 32.32 29.68 22.93 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 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 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 42 74 63 93 94 33 30 26 26 25 $ $ $ $ $ 32.47 26.42 37.43 23.14 26.29 $ $ $ $ $ 1,071.51 792.60 973.18 601.64 657.25 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.1046784 2892.54654976 4049.565169664 5669.3912375296 7937.1477325414 11112.006825558 15556.8095557812 21779.5333780937 30491.3467293312 42687.8854210636 59763.0395894891 83668.2554252847 117135.557595399 163989.780633558 229585.692886981 321419.970041774 449987.958058483 629983.141281877 881976.397794627 1234766.95691248 1728673.73967747 2420143.23554846 3388200.52976784 4743480.74167497 6640873.03834496