Problem 1: 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 Jxsvl

3rd......Shipper equal to NYK and M

a) How many observations make up this filtered group?

b) Create a SUBTOTAL formula to calculate the filtered SUM of Tonnes. Assume the OBS in the table is located in cell A1.

Problem 2: a) Create a Frequency Distribution column graph for the # of 40 ft Cntrs. data in the table.  Use the Frequency(data_array,bins_array) function in Excel to construct the column graph and use bins that contain 5000 unit intervals, starting with 5,001-10,000 and ending with 55,001-60,000. Finally, make the values on the x-axis match the exact bin values (5,001-10,000, 10,001-15,000,....,55,001-60,000) so there is no doubt of the values contained in each bin.

b) Which of the following statement(s) is (are) false about the frequency distribution graph?

1) This frequency distribution graph is Unimodal

2) This frequency distribution graph is not symmetric

3) This frequency distribution graph is skewed left

4) This frequency distribution graph is skewed right

5) This frequency distribution has a median value less than its mean value

Attachment:- Assignment File.rar