Industrial Pharmacy I – Additional assignment

General instructions

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 msaid3@gmail.com. Kindly state the your name and ID in the email subject.

Details

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:

PSD by Microscope

The equations for such statistical parameters can be found/concluded from here

http://people.umass.edu/biep540w/pdf/Grouped%20Data%20Calculation.pdf

We believe you may need to learn about the following excel functions: vlookup- match- index- large- if – sum – array formula

Best regards ^_^.