Question

1 Approved Answer

Posted on Sep 18, 2024

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

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? FS TI mer OBS Fof 40 Onth Tonnes 1 31,766 1,182,664 2 $2,275 395,361 3 34.168 1.390,618 4 31,385 1.601.501 5 42,800 483,710 6 49,925 1,165,691 7 51070 543,632 8 18,729 491,010 109 23,690 1,372,957 11 10 26,611 1,368,792 11 31,697 448,773 11 12 38,751 976,205 s 13 16,511 1,221,523 15 14 13,819 1.156,106 16 15 24,572 1,517,366 12 16 31,148 794,388 17 14,549 484,601 1918 40,021 595,985 2019 38.259 993,594 21 20 49.007 525,653 22 21 34,999 1.276,407 23 22 50,705 1.462.923 24 23 30,810 513,322 25 24 36,040 1,017,254 25 25 47,100 1,037,689 27 28 15,113 396,621 26 27 30,349 041,083 29 28 45,615 1.193,597 0 29 53,581 978,729 30 40,924 1,304,651 3231 45,331 1,413,944 38 32 28,397 701.044 34 33 948,631 15 34 52 598 1,322253 35 50,531 574,556 37 36 41,645 630,723 36 37 50,992 1,333,123 1938 13.352 1,364.922 39 31.791 393.791 43 40 27.606 1.489.263 4241 20,126 700.995 a 42 38,945 1,346,607 4 43 17,808 1,010,026 45 44 52,061 1,357,886 45 38.221 424,523 46 32.685 728,821 47 G32,092 45 21,626 1,417,378 49 25,810 1.119.654 50 32.142 579,068 50 5 46,746 467.766 52 50.60 527,846 453 1.214.561 39,650 54 34,962 1,514,036 4155 36,249 501,913 sy 19.647 1,050,845 47. ZO 50 33.382 829,203 10% 1$31,332 14,911 149 45.579 1403.7 30.733 27.495 64 2.IO 67201 65 1579 1.000,190 3120 67 40,019 1.176.400 68 50 51 657141 69 22,140 2556 45,397 TI 1,485.000 19,000 372191 722 14,826 904 STE 73 4873 65.70 14 51,532 450-15 75 3. 1.41.26 26 26.30 6,240 445,278 7. Shipper Port EG NYU NYK NYK NYNU NYK Chi NYK VA EG Chilon NYK VA CSOL VA EG VA H NY-NU EG NY-NU NYK NY- NYK VA NYK VA NYNU NY-NU NYK Chin M Con NYK NY-NU NYK VA NYK NYK NY-NU M VA M Jav FG Chi EG NTNU G VA NYK NYU NYK NY NU M NY:NU EG Chin NYX VA EG NY-NU EG Ba LG NY-NU NYK NY-NU NYK VA CSOL NYN EG VA NYK csa NY-NU NYK VA NEK NYNU NYK Chan LG NIK NYK EG EG EG JM FC E NYNU Chon EG NY-NI NIK VA NIK NY-NI NY Cher NY-NU MY-NU NIK Chin NIN VA NIK VA NY NY NO NY NIK MENU DO NYU NY NYNO G M MENU 11,633 INAN 1.472592 1.40 03 190 29 NH 1.400,00 07.06 32 70 ANT M NY H NEN MENU YA CSC NE FR uz WA 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? FS TI mer OBS Fof 40 Onth Tonnes 1 31,766 1,182,664 2 $2,275 395,361 3 34.168 1.390,618 4 31,385 1.601.501 5 42,800 483,710 6 49,925 1,165,691 7 51070 543,632 8 18,729 491,010 109 23,690 1,372,957 11 10 26,611 1,368,792 11 31,697 448,773 11 12 38,751 976,205 s 13 16,511 1,221,523 15 14 13,819 1.156,106 16 15 24,572 1,517,366 12 16 31,148 794,388 17 14,549 484,601 1918 40,021 595,985 2019 38.259 993,594 21 20 49.007 525,653 22 21 34,999 1.276,407 23 22 50,705 1.462.923 24 23 30,810 513,322 25 24 36,040 1,017,254 25 25 47,100 1,037,689 27 28 15,113 396,621 26 27 30,349 041,083 29 28 45,615 1.193,597 0 29 53,581 978,729 30 40,924 1,304,651 3231 45,331 1,413,944 38 32 28,397 701.044 34 33 948,631 15 34 52 598 1,322253 35 50,531 574,556 37 36 41,645 630,723 36 37 50,992 1,333,123 1938 13.352 1,364.922 39 31.791 393.791 43 40 27.606 1.489.263 4241 20,126 700.995 a 42 38,945 1,346,607 4 43 17,808 1,010,026 45 44 52,061 1,357,886 45 38.221 424,523 46 32.685 728,821 47 G32,092 45 21,626 1,417,378 49 25,810 1.119.654 50 32.142 579,068 50 5 46,746 467.766 52 50.60 527,846 453 1.214.561 39,650 54 34,962 1,514,036 4155 36,249 501,913 sy 19.647 1,050,845 47. ZO 50 33.382 829,203 10% 1$31,332 14,911 149 45.579 1403.7 30.733 27.495 64 2.IO 67201 65 1579 1.000,190 3120 67 40,019 1.176.400 68 50 51 657141 69 22,140 2556 45,397 TI 1,485.000 19,000 372191 722 14,826 904 STE 73 4873 65.70 14 51,532 450-15 75 3. 1.41.26 26 26.30 6,240 445,278 7. Shipper Port EG NYU NYK NYK NYNU NYK Chi NYK VA EG Chilon NYK VA CSOL VA EG VA H NY-NU EG NY-NU NYK NY- NYK VA NYK VA NYNU NY-NU NYK Chin M Con NYK NY-NU NYK VA NYK NYK NY-NU M VA M Jav FG Chi EG NTNU G VA NYK NYU NYK NY NU M NY:NU EG Chin NYX VA EG NY-NU EG Ba LG NY-NU NYK NY-NU NYK VA CSOL NYN EG VA NYK csa NY-NU NYK VA NEK NYNU NYK Chan LG NIK NYK EG EG EG JM FC E NYNU Chon EG NY-NI NIK VA NIK NY-NI NY Cher NY-NU MY-NU NIK Chin NIN VA NIK VA NY NY NO NY NIK MENU DO NYU NY NYNO G M MENU 11,633 INAN 1.472592 1.40 03 190 29 NH 1.400,00 07.06 32 70 ANT M NY H NEN MENU YA CSC NE FR uz WA