Part 1

Make sure that your spreadsheet calculations are set to 2 decimal places. 

Below is the raw data for 50 customers, detailing the amount (£) spent per person in the hotel café.

Using the inbuilt formulae in Excel (see page 34 of handbook) calculate the mean, standard deviation, median, Q1 and Q3, min and max for this data.  

Group this data using the following groups: 

3 to under 5

5 to under 7

7 to under 9

9 to under 11

11 to under 13

13 to under 15

Using this Grouped data:

Calculate the mean and standard deviation. Draw the Histogram and make a comment about the shape.  Draw an Ogive and read off the median, Q1 and Q3 values.