Highlight the list of numbers you require the mean for, which will appear in the number 1 box (ignore number 2 box) and click ok
– This is also a measure of spread but looks at the spread of the middle 50% of the data around the median. It is found by subtracting the lower quartile from the upper quartile (calculating UQ-LQ).
Click in an empty cell
Click on fx on the tool bar
Select Statistical in the function category
Select Quartile in the function name and then click ok
Highlight the column of data, which will appear in the array box
Click in quart box and type 1
To calculate the , repeat as above but type in 0 instead of 1 in the quart box
To calculate the , repeat as above but type in 2 in the quart box
To calculate the , repeat as above but type in 3 in the quart box
To calculate the , repeat as above but type in 4 in the quart box
Use graph paper
Draw a horizontal scale. It is a good idea to draw all the box plots on one piece of graph paper using the same scale. You will then be able to compare your results in your conclusion.
Mark on the 5 pieces of data you have found and draw in the box and whiskers as shown on the next page.