Problem 4: Filter the Port Data by 3 keys in the order given- 1st.....# of 40 ft Cntrs, greater than 30,000 2nd.....Port equal to VA and Ixsvl 3rd......Shipper equal to NYK and M a) How many observations make up this filtered group? b) What percentage is a) of the total? c) Create a SUBTOTAL formula to calculate the filtered SUM of Tonnes. Assume the OBS in the table is located in cell Al. d) What percentage is d) of the total? 4 FI OBS 11 1 2 3 4 5 6 2 3 4 EG Origini 2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 E C E of 40 ft Cnt Tonnes Shipper Port 31.766 1.182 664 EG NYAN 52.275 398 361 NYK BA 34.168 1.390,618 NYK NY-N) 31385 1601501 NYK Chlon 42.800 483.710 NYK VA 49.925 1,165,691 EG Chian 51,070 643, 632 NYK VA 18,729 491018 CSCL VA 23,690 1372,957 EG VA 26.611 1368.792 M NY-NJ 31,697 448,773 NY-NJ 38,751 976,205 NYK NY-NJ 16 511 1221,523 NYK VA 13.819 1.156.106 NYK VA 24,572 1517 366 EG NY-NJ 31.148 794,388 M NY-NJ 44 549 484 601 NYK Chian 40,021 596.383 M Chisn 38.259 993 594 NYK NY-NJ 49 007 525,653 NYK VA 34 989 1276,407 NYK Jusul 50,708 1462.923 NYK NY-NJ 30.810 513,322 M VA 36,040 1,017254 M Jusul 47.100 1037 689 EG Chisn 15. 113 396,621 EG NY-NJ 36,349 841,083 EG VA 45,615 1.193,597 NEK NY-NJ 53 581 978,729 NYK NY-NJ 40 924 1.304,651 M NY-NU 45,331 1413 944 Chisn 28,397 701,044 NYK Jusul 45.455 948.631 EG VA 52.598 1.322 153 EG NY-NJ 50 531 574 556 EG Bal 41645 630.723 EG NY-N 50.392 1333,123 NYK NY-N 13,352 1,364.922 NYK VA 31,791 393.791 CSCL NY-NU 27,606 1.489.283 EG VA 20.126 700.998 NYK Bal 38.946 1.346 607 CSCL NY-NU 17 808 1010 026 NYK VA EG 31 32 33 34 35 36 37 38 39 40 41 42 43 44 41 42 43 D EG E Bal NY-NJ NY-NJ VA NYENU VA Bal 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 35 36 67 68 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 B 50 531 41845 50,992 13 352 31.791 27.606 20.126 38,946 17,808 52.861 38,221 32,685 44.637 21.628 29,810 32 342 46,746 50,681 39660 34,962 36.249 19.847 47.207 33 382 39 402 14,931 45,570 38,733 27,495 52 207 33,620 33,622 40.019 SO 587 22.348 45.397 13,880 44.826 34,479 51512 51037 26,340 28.950 36.054 574 556 630,723 1,333,123 1364 922 393.791 1489.263 700,998 1.346,607 1010 026 1.357 888 424,523 728,821 632.092 1.417 378 1119,654 579 068 467.766 527 846 1214.961 1.516,856 603,913 1058,945 1,479.592 820,293 1531,382 1240.949 1403,745 1408 064 607,083 672.821 1.000 190 651.961 1.378,408 667. 141 785,361 1485.088 1374 191 504,676 465.780 430 415 1412 974 569.240 445,274 1,057 837 EG NYK NYK CSCL EG NYK CSCL NYK NYK NYK EG NYK NYK EG EG EG EG EG EG NYK NYK NYK M M EG NYK NYK NYK NYK NYK NYK NY-NJ VA NY-NJ Chisn Bal Chisn NY-NU Jusul NY-NJ Jesu NY-NJ Chian NY-NJ VA NY-NJ Bal Chisn NY-NJ NY-NJ Chis VA VA NY-NJ Just NY-NJ NY-NJ NY-NJ NY-NJ Jusul NY-NU Chin NY-NU NY-N NY-NO VA Bal VA EG 65 66 67 68 69 70 71 72 73 74 75 78 77 78 79 60 61 62 63 64 65 66 67 68 69 70 71 172 72 74 75 76 2 78 NYK NYX EG M NYK NYK NYK M CSOL NYK EG blo Pent
