FREE MODULE Introduction to Statistics PROCESS IMPROVEMENT AND SIX SIGMA
 ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
 FREE TRIAL
 :: Online Courses :: Free Trial >> Statistics Module >> Excel Primer :: Six Sigma :: FAQ :: Brochures :: Licenses :: Discounts
 Welcome to MiC Quality Glen Netherwood MiC Quality Online Learning
 :: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: INTRODUCTION TO STATISTICS

Salinity Exercise

A pharmaceutical company fills vials with a saline solution. The target value for the salinity is 50.

The salinity level can be adjusted using a dial on the machine. The value shown on the dial is the nominal value; it may need to be adjusted to compensate for errors:

We need to check the accuracy of the machine, the usual way of doing this is to take a sample from the process and calculate the sample mean. If the sample mean is significantly different from the target value then we will adjust the machine accordingly. I took a sample of 20 vials and obtained the values:

 50.64 47.55 50.62 60 50.67 49.11 52.22 57.4 62.58 51.14 45.41 56.86 53.77 48.53 49.59 43.91 51.17 54.28 46.99 58.41

If you prefer to take your own sample you can press the 'Take Sample' button. You can also turn the dial to adjust the setting, but that is not part of this exercise.

Calculate the mean salinity of the sample of vials taken from the simulation:

If possible use Excel. If you are not too confident with Excel you can check out the MiC Quality free Excel primer. The function is:

 Mode Statistics and Parameters