QUESTION 3 The following data gives the distances that a sample of Johannesburg car owners drive during one week. Distance driven (km) 103 114 69 91 24 61 107 110 87 110 120 42 146 255 95 143 64 77 281 146 266 120 85 144 106 149 373 150 95 66 130 125 (a) Enter the data into Excel. (4) (b) Use Excel to draw a histogram of the data set, (i) using a class width of 100; (6) (ii) using a class width of 50. (8) (c) Use Microsoft Excel to draw a box plot of the data set. including Data labels. Identify outliers, the upper and lower quartiles. the median and mean from the box plot. (12) Include a picture of the spreadsheet and all the requested graphs in your solutions. [30] QUESTION 5 A survey to nd out if there is a connection between length of work experience and salary of academics at a university found the following data. Work experience is measured in years and salary in thousands of rands per month. Work experience \"-3-3n-ll- Salarypermonth 15 31 14 56 20 15 1'! 28 (a) Enter the data onto Excel and draw box plots for Work experience and for Salary per month. (15) (6) Use Excel to draw a scatterplot of the data set. (10) Include a picture of the Excel spreadsheet with the data as well as the diagrams in your solutions. Remember to label all parts of the diagram appropriately. [25] [TOTAL: 100 marks]