Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (a) Present a scatter plot of sales and number of employees in all 20 corporations (5 marks) 4 (b) c 1 2 3 4 5 5 7 3 9 1 2 4 5 5 7 3 9 D 1 2 B 4 D excel 1 CUSTER Sales Corporations 1 Company 1 2 Company 2 3 Company 3 4 Company 4 5 Company 5 6 Company 6 7 Company 7 8 Company 8 9 Company 9 10 Company 10 11 Company 11 12 Company 12 13 Company 13 14 Company 14 15 Company 15 16 Company 16 17 Company 17 18 Company 18 19 Company 19 20 Company 20 1200000 1300000 1250000 1125000 1005231 1143450 1500000 1624520 1524545 1600242 1652454 1453453 1424524 1343452 1742520 1564444 1436563 1556567 1564774 1854546 Number of employees 10000 11000 10500 9800 11432 12043 8020 7452 8344 9222 8213 7334 9454 8533 13223 10034 11344 12434 12331 10444 Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (a) Present a scatter plot of sales and number of employees in all 20 corporations (5 marks) 4 (b) c 1 2 3 4 5 5 7 3 9 1 2 4 5 5 7 3 9 D 1 2 B 4 D excel 1 CUSTER Sales Corporations 1 Company 1 2 Company 2 3 Company 3 4 Company 4 5 Company 5 6 Company 6 7 Company 7 8 Company 8 9 Company 9 10 Company 10 11 Company 11 12 Company 12 13 Company 13 14 Company 14 15 Company 15 16 Company 16 17 Company 17 18 Company 18 19 Company 19 20 Company 20 1200000 1300000 1250000 1125000 1005231 1143450 1500000 1624520 1524545 1600242 1652454 1453453 1424524 1343452 1742520 1564444 1436563 1556567 1564774 1854546 Number of employees 10000 11000 10500 9800 11432 12043 8020 7452 8344 9222 8213 7334 9454 8533 13223 10034 11344 12434 12331 10444