Question: onsider the data set below: Job Number Item to be Moved Weight (tons) 347 Mealies 12.8 348 Sunflower seeds 16.6 349 Sunflower seeds 17.8 350

onsider the data set below: Job Number Item to be Moved Weight (tons) 347 Mealies 12.8 348 Sunflower seeds 16.6 349 Sunflower seeds 17.8 350 Mealies 15.3 351 Mealies 11.8 352 Mealies 12.2 353 Sunflower seeds 14.6 354 Sunflower seeds 16.1 355 Sunflower seeds 9.1 356 Mealies 13.7 357 Soya beans 8.7 358 Soya beans 17.1 2.1 Summarise the Item to be Moved column by using a pivot table in Excel.Display the results using a simple bar chart. Include a copy of your pivot table with your simple bar chart. (8) 2.2 Summarise the Weight (tons) column using the Histogram function from the Data Analysis tool in Excel. Display the results using a histogram with intervals "8 < x 10", "10 < x 12", etc. Include a copy of your frequency table with your histogram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

PLEASE ANSWER ALL OF QUESTIONS QUESTION 1 Basic operations that are supported by built-in structure array support are (page 63) A. Fetch and Delete B. Insert and Delete C. Fetch and Update D. Delete...

QUESTION 1 Basic operations that are supported by built-in structure array support are (page 63) A. Fetch and Delete B. Insert and Delete C. Fetch and Update D. Delete and Update QUESTION 2 Which one...

onsider the following two sample data sets Set 1: 9 2674 Set 2: 2 11 13 6 3 aCalculate the coeffcient of variation for each data set. b. Which data set has more variability

onsider the following data set: 7, 7, 0, 4, 5, 5, 3, 4, 6, 6, 4, 0. (a) Find the five-number summary and the IQR. Min 0 Q 1 3.25 Median 4.5 Q3 6 Max 7 IOR 2.75 (b) Calculate x and s. (Round your...

onsider the Simpson's rule for the integral 1 0 f (x) dx, with the given data set: x 0.00 0.25 0.50 0.75 1.00 f (x) 0.00 0.06 0.24 0.51 0.84 The plots of the derivatives of f are given below:0.0 0.5...

I am having difficulties calculating the following for this problem. I found the y intercept and slop which is -4.5652 + 2.6957, but apparently I am miscalculating the rest of the problem because my...

Matlab: xercise-3: (4 pts) onsider the following set of data x = [1 -1 2 -1 0 2-3 4] and y = [2 2 0 0 3 3 2 3 ovide the commands to: Count the number of elements of x between -2 and 2 included. Raise...

onsider the following data set regarding Nurse demographics for questions 6-8: Sex Sick Days Taken Age (yrs) Hrs Worked (Wkly) M 2 33 25.8 M 9 52 32.9 M 1 42 29.4 M 0 59 36.2 M 5 47 31.0 M 4 35 27.0...

Data Preprocessing in Data Mining onsider the data as 2-D data points. Given a new data point x = (14, 16) as a query, rank the database points based on the cosine similarity measure A2 1.7 1.9 1.8...

Define profession. Do you believe that the field of human resource management is a profession? Explain your answer.

Consider the following problem: Maximize Subject to x1 {25, 30}, x2 {20, 25, 30, 35, 40, 50}, x3 {20, 25, 30}, x4 {20, 25}, all these variables must have different values, x2 + x3 + 60, x1 + x3 + 50....

in explaining the unintended effects of banking regulations after the 1 9 8 s financial crisis, the policy

.................. is the difference between sales revenue and cost of sales. A total profit b gross profit c profit of the year d operating profit