This assignment is considered additional and NOT obligatory. Students who submit successful answers will earn ONE bonus mark.
This assignment should be done by individual students NOT groups.
The deadline is Sun 25/11.
The assignment should be submitted via email to firstname.lastname@example.org. Kindly state the your name and ID in the email subject.
We ask for a user-friendly excel sheet into which the ranges of particle size and count obtained from microscope image analysis can be inserted, so that the sheet can automatically calculate the following statistical parameters for the grouped data: mean, mode, median, span and construct the differential column chart as well cumulative above and under control charts. You can use the data provided in the lab manual to help test your sheet.
The data is present here:
The equations for such statistical parameters can be found/concluded from here
We believe you may need to learn about the following excel functions: vlookup- match- index- large- if – sum – array formula
Best regards ^_^.