Question

The weight of 50 boxes containing Apples is measured in Kilograms, is given below. Perform the tasks given in (i) to (iv) using a spreadsheet package

9.5 8.9 10.0 10.1 8.8 9.2 9.7 9.7 9.5 10.2
8.8 8.5 11.0 9.1 10.8 9.9 8.8 9.5 9.9 9.2
10.2 9.7 11.2 9.8 9.6 9.7 10.7 8.0 9.8 10.7
10.5 9.9 10.7 10.9 9.8 9.3 9.9 8.9 10.5 10.7
9.9 10.6 9.6 10.4 8.5 10.2 8.9 9.9 8.9 9.4

(i) Find the minimum and maximum weight using spreadsheet
formula.
(ii) Divide the weight in 5 classes with suitable class interval and
create the frequency distribution for these classes using Array
formula.
(iii) Find the percentage of boxes whose weight is above 10 kgs.
(iv) Represent the frequency distribution with the help of a relevant
graph.

Answer 1

See the attached spread sheet.

c064de629a13b207a63ed24d4d571b80.xlsx