Just need answer. thank you

Required information [The following information applies to the questions displayed below.) Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the companys 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637361 Click here to download the Excel template which you will use to answer the questions that follow. Click here for a brief tutorial on Pivottables in Excel. Click here for a brief.tutorial on PivotCharts in Excel 5. Based on your findings in requirements 1-4. Who were the top performers? David Wills Total sales Commercial segment Land sales Residents sales Sold Sold Sold Sold E B D 1 Month Selling Price Type - Realtor 2 October $ 157,500 Commercial David Pullen 3 January $ 88,800 Commercial David Pullen 4 November $ 67,875 Commercial David Pullen 5 November $ 53,938 Commercial David Pullen 6 October $ 2,989,500 Commercial David Willis 7 November $ 2,027,375 Commercial David Willis 8 January $ 505,000 Commercial David Willis 9 January $ 242,500 Land David Willis 10 January $ 236,300 Commercial David Willis 11 October $ 127,250 Residential David Willis 12 November S 108,125 Commercial David Willis 13 October $ 100,000 Land David Willis 14 November $ 98,750 Residential David Willis 15 January $ 64,400 Residential David Willis 16 November $ 62,719 Commercial David Willis 17 December S 51,359 Commercial David Willis 18 January $ 44,258 Land David Willis 19 October $ 3,014,750 Commercial Hal Keefer 20 January $ 717,000 Commercial Hal Keefer 21 October $ 585,000 Commercial Hal Keefer 22 December $ 288,422 Commercial Hal Keefer 23 November $ 272,625 Land Hal Keefer 24 December $ 204,469 Land Hal Keefer 25 November $ 83,625 Residential Hal Keefer 26 December S 49,831 Commercial Hal Keefer 27 November $ 47,500 Residential Hal Keefer 28 December $ 536,844 Commercial Jon Dolan 29 Januar $ 81,117 Commercial Jon Dolan Pivot Table PivotChart Sheet 1 Sheet1 Ready E F RealtorID County 101 McDowell 101 Rutherford 101 Buncombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell 104 Buncombe Sheet2 EA 6-1, Chapman A B D 30 December $ 50,158 Commercial Jon Dolan 31 January $ 45,680 Land Jon Dolan 32 December $ 41,875 Commercial Jon Dolan 33 October $ 403,500 Commercial Arturo James 34 November $ 368,938 Commercial Arturo James 35 October $ 365,060 Land Arturo James 36 January $ 287,000 Commercial Arturo James 37 October $ 275,000 Residential Arturo James 38 December $ 218,000 Commercial Arturo James 39 October S 214,500 Residential Arturo James 40 November $ 98,156 Commercial Arturo James 41 January $ 66,000 Residential Arturo James 42 December $ 57,031 Commercial Arturo James 43 January $ 44,916 Residential Arturo James 44 January $ 22,000 Land Arturo James 45 December $ 950,000 Commercial Marcus Jackson 46 January $ 164,211 Commercial Marcus Jackson 47 October $ 151,500 Residential Marcus Jackson 48 January $ 102,105 Residential Marcus Jackson 49 December S 60,316 Commercial Marcus Jackson 50 January $ 48,516 Residential Marcus Jackson 51 November $ 43,750 Residential Marcus Jackson 52 January $ 445,000 Commercial Megan Cooper 53 January $ 245,000 Commercial Megan Cooper 54 October $ 70,000 Land Megan Cooper 55 November $ 69,375 Residential Megan Cooper 56 November $ 55,000 Commercial Megan Cooper 57 November $ 50,906 Land Megan Cooper 58 December $ 47,344 Land Megan Cooper Pivot Table PivotChart Sheet 1 Sheet1 Shoot E F 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe 105 Henderson 105 Buncombe 105 McDowell 105 Buncombe 105 Buncombe 105 Buncombe 105 Henderson 105 Polk 106 Henderson 106 Buncombe 106 Cleveland 106 Rutherford 106 Polk 106 Buncombe 106 Polk 107 Buncombe 107 Buncombe 107 Rutherford 107 Polk 107 Henderson 107 Henderson 107 Buncombe 620 JX A B D E F 59 October $ 354,600 Land Melanie Aaron 108 Rutherford 60 November $ 176,250 Commercial Melanie Aaron 108 Cleveland 61 November $ 118,650 Residential Melanie Aaron 108 Polk 62 January $ 60,559 Residential Melanie Aaron 108 Buncombe 63 December $ 59,663 Residential Melanie Aaron 108 Buncombe 64 January $ 50,279 Land Melanie Aaron 108 Rutherford 65 January $ 47,270 Commercial Melanie Aaron 108 Buncombe 66 October $ 2,671,500 Commercial Eun Jung Bae 109 Henderson 67 November $ 697,875 Commercial Eun Jung Bae 109 Buncombe 68 November $ 202,530 Land Eun Jung Bae 109 Henderson 69 November $ 80,633 Commercial Eun Jung Bae 109 Cleveland 70 November S 79,325 Land Eun Jung Bae 109 Cleveland 71 January $ 67,500 Residential Eun Jung Bae 109 Polk 72 January $ 54,539 Land Eun Jung Bae 109 McDowell 73 December $ 45,453 Residential Eun Jung Bae 109 Buncombe 74 January S 1,150,000 Residential Mitch Davis 110 Rutherford 75 November $ 1,033,688 Land Mitch Davis 110 Cleveland 76 October $ 221,750 Commercial Mitch Davis 110 Polk 77 October $ 197,300 Residential Mitch Davis 110 Henderson 78 December $ 122,234 Residential Mitch Davis 110 Buncombe 79 October $ 95,750 Residential Mitch Davis 110 Polk 80 January $ 42,840 Commercial Mitch Davis 110 Cleveland 81 October $ 312,500 Residential Nicole Ashby 111 McDowell 82 January S 163,500 Commercial Nicole Ashby 111 McDowell 83 November $ 156,313 Commercial Nicole Ashby 111 Henderson 84 November $ 130,875 Commercial Nicole Ashby 111 Buncombe 85 November $ 121,265 Residential Nicole Ashby 111 McDowell 86 January $ 95,000 Land Nicole Ashby 111 Buncombe 87 November $ 85,438 Commercial Nicole Ashby 111 Henderson Pivot Table PivotChart Sheet 1 Sheet1 Sheet2 EA 6-1, Chapma A B D 71 January $ 67,500 Residential Eun Jung Bae 72 January $ 54,539 Land Eun Jung Bae 73 December $ 45,453 Residential Eun Jung Bae 74 January $ 1,150,000 Residential Mitch Davis 75 November $ 1,033,688 Land Mitch Davis 76 October $ 221,750 Commercial Mitch Davis 77 October $ 197,300 Residential Mitch Davis 78 December $ 122,234 Residential Mitch Davis 79 October $ 95,750 Residential Mitch Davis 80 January $ 42,840 Commercial Mitch Davis 81 October $ 312,500 Residential Nicole Ashby 82 January $ 163,500 Commercial Nicole Ashby 83 November $ 156,313 Commercial Nicole Ashby 84 November $ 130,875 Commercial Nicole Ashby 85 November $ 121,265 Residential Nicole Ashby 86 January $ 95,000 Land Nicole Ashby 87 November $ 85,438 Commercial Nicole Ashby 88 November $ 74,063 Commercial Nicole Ashby 89 December $ 69,078 Commercial Nicole Ashby 90 October $ 1,355,750 Commercial Pete Jacobs 91 October $ 970,500 Commercial Pete Jacobs 92 October $ 505,250 Commercial Pete Jacobs 93 January $ 486,800 Commercial Pete Jacobs 94 January $ 138,150 Land Pete Jacobs 95 January $ 129,000 Residential Pete Jacobs 96 November $ 61,813 Residential Pete Jacobs 97 November $ 54,688 Commercial Pete Jacobs 98 November $ 46,969 Residential Pete Jacobs 99 January $ 41,420 Commercial Pete Jacobs Pivot Table PivotChart Sheet 1 Sheet1 E 109 Polk 109 McD 109 Bunc 110 Ruth 110 Cleve 110 Polk 110 Hend 110 Bunc 110 Polk 110 Cleve 111 McDc 111 McDc 111 Hende 111 Bunce 111 McDo 111 Buncc 111 Hende 111 Buncc 111 Polk 112 Clevel 112 Bunco 112 Clevel 112 Polk 112 Clevel 112 Bunco 112 Bunco 112 Polk 112 Ruther 112 Polk Sheet2 EA 6-1, CI Road