A survey was made of the cars entering a car park. A note was made of the make and colour of each car. The drivers were asked why they had purchased the car.

Each car was subsequently tested on a dynamometer and the actual power at the wheels was measured. (This data will be provided to you in an Excel spreadsheet).

a) Using appropriate techniques, examine both the quantitative and qualitative data contained in the spreadsheet and represent the data for further analysis in a suitable graphical form.

b) Further analyse the data in part 2a and using a combination of quantitative and qualitative methods present your findings in a suitable format.

2 Car Power(KW) Make Colour Why 1 46 vw Blue Power 57 Ford Grey Make 3 44 vw Black Cost 4 51 Honda Red Make 55 VW Red Power 6 27 BMW Black Make 56 BMW Black Make 8 51 Nissan Grey Make 9 59 Rover Red Colour 10 39 Ford Grey Power 11 37 VW Black Power 12 47 Honda Black Cost 13 42 Rover Black Colour 14 SS Nissan Red Make 15 61 VW Black Power 16 42 Ford Grey Colour 17 55 Vw Grey Colour 18 37 Rover Blue Make 19 42 Rover Black Cost 20 24 Nissan Black Power 21 47 Rover Grey Cost 22 29 BMW Black Colour 23 59 Vw Red Make 24 51 Ford Black Power 25 44 Nissan Red Make 26 44 Nissan Blue Power 27 38 Nissan Red Make 28 38 Honda Grey Power 29 29 Rover Red Make 30 24 BMW Red Power 31 33 Ford Blue Power 32 57 Honda Black Cost 33 29 Rover Grey Power 34 29 BMW Grey Colour 35 59 Honda Black Make 36 64 Rover Blue Power 37 33 Rover Grey Colour 38 61 Honda Blue Power 39 59 VW Blue Cost 40 29 Rover Black Power 2 Car Power(KW) Make Colour Why 1 46 vw Blue Power 57 Ford Grey Make 3 44 vw Black Cost 4 51 Honda Red Make 55 VW Red Power 6 27 BMW Black Make 56 BMW Black Make 8 51 Nissan Grey Make 9 59 Rover Red Colour 10 39 Ford Grey Power 11 37 VW Black Power 12 47 Honda Black Cost 13 42 Rover Black Colour 14 SS Nissan Red Make 15 61 VW Black Power 16 42 Ford Grey Colour 17 55 Vw Grey Colour 18 37 Rover Blue Make 19 42 Rover Black Cost 20 24 Nissan Black Power 21 47 Rover Grey Cost 22 29 BMW Black Colour 23 59 Vw Red Make 24 51 Ford Black Power 25 44 Nissan Red Make 26 44 Nissan Blue Power 27 38 Nissan Red Make 28 38 Honda Grey Power 29 29 Rover Red Make 30 24 BMW Red Power 31 33 Ford Blue Power 32 57 Honda Black Cost 33 29 Rover Grey Power 34 29 BMW Grey Colour 35 59 Honda Black Make 36 64 Rover Blue Power 37 33 Rover Grey Colour 38 61 Honda Blue Power 39 59 VW Blue Cost 40 29 Rover Black Power