Create subtotal formula to calculate filtered sum of tonnes

Reference no: EM131500341

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

Reference no: EM131500341

Questions Cloud

Who has the higher lifetime tax burden : Amy and Shirley both live two periods. Both have earnings of 1,000 in the present and zero in the future. The interest rate is 8 percent.

Determine upper and lower control limits : Determine upper and lower control limits that will include roughly 97 percent of the sample means when the process is in control.

What are the strengths and weaknesses of the article : What, according to you, is the author trying to achieve through this study? In other words, what is the objective and outcome of this study?

Implementation of a continuous improvement effort : 1. Discuss the main issues involved in the implementation of a continuous improvement effort.

Create subtotal formula to calculate filtered sum of tonnes : Create a SUBTOTAL formula to calculate the filtered SUM of Tonnes. Assume the OBS in the table is located in cell A1

Solve the boundary value problem given by the partial : Solve the boundary value problem given by the partial differential equation

Discuss theory of fiscal federalism as a framework : In his 2000 presidential campaign, Howard Dean said that the federal government should not "inflict" gun regulations.

Project manager of a megaproject : If you are a project manager of a megaproject, what are the top ten questions you would need answered in your project scope statement?

How is energy important to modern manufacturing production : Assignment: Critical Thinking Activity- How is energy important to modern food and manufacturing production and distribution?

User Account

All Pages