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 company's 12 realtors sold 99 properties (residential, commercial and lond) ocross six counties for a total of $30,637161 Click here to download the Excel template which you will use to answer the questions that follow. Click here for a brief tutorial on Pivot Tables in Excel Click here for a brief tutorial on PivotCharts in Excel. 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? Commercial Land Residential Sold Sold Sold Fun Month NA Selling Price Type Realtor Realtorbim County 2 October S 157 500 Commercial David Pullen 101 McDowell 3 January S 88,800 Commercial David Pullen 101 Rutherford 4 November 67,875 Commercial David Pullen 101 Buncombe 5 November S 53,938 Commercial David Pullen 101 Rutherford 6 October 2,989,500 commercial David Willis 102 Buncombe 7 November S 2,027,375 Commercial David Willis 102 Henderson 8 January S 505,000 Commercial David Willis 102 McDowell 9 January $ 242,500 Land David Willis 102 McDowell 10 January S 236,300 Commercial David Willis 102 Polk 11 October $ 127,250 Residential David Willis 102 Polk 12 November S 108,125 Commercial David Willis 102 Buncombe 13 October $ 100,000 Land David Willis 102 Polk 14 November S 98,750 Residential David Willis 102 McDowell 15 January S 64,400 Residential David Willis 102 Henderson 16 November S 62,719 Commercial David Willis 102 Buncombe 17 December 51,359 Commercial David Willis 102 Polk 18 January S 44,258 Land David Willis 102 Henderson 19 October $ 3,014,750 Commercial Hal Keefer 103 Rutherford 20 January S 717.000 Commercial Hal Keefer 103 Cleveland 21 October S 585,000 Commercial Hal Keefer 103 Rutherford 22 December S 288,422 Commercial Hal Keefer 103 Cleveland 23 November S 272,625 Land Hal Keefer 103 Rutherford 24 December S 204.469 Land Hal Keefer 103 Cleveland 25 November S 83,625 Residential Hal Keefer 103 Polk 26 December S 49.831 Commercial Hal Keefer 103 McDowell 27 November S 47 500 Residential Hal Keefer 103 Cleveland 28 December S 536,844 Commercial Jon Dolan 104 McDowell 29 January S 81,112 Commercial Jon Dolan 104 Buncombe 30 December S 50,158 Commercial Jon Dolan 104 Buncombe 31 January $ 45,680 Land Jon Dolan 104 Buncombe 32 December 41,875 Commercial Jon Dolan 104 Buncombe 33 October $ 403,500 Commercial Arturo James 105 Buncombe 34 November S 368,938 Commercial Arturo James LOS MEDowell 35 October S 365,060 Land Arturo James 105 Rutherford 36 January S 287,000 Commercial Arturo James 105 Buncombe 37 October $ 275,000 Residential Arturo James 105 Henderson 38 December $ 218,000 Commercial Arturo James 105 Buncombe 39 October $ 214,500 Residential Arturo James 105 McDowell 40 November $ 98,156 Commercial Arturo James LOS Buncombe 41 January S 66,000 Residential Arturo James 105 Buncombe Pivot Table PivotChart EA 6-1, Chapman Realty 42 December S 57,031 Commercial Arturo James 105 Buncombe / 43 January $ 44,916 Residential Arturo James 105 Henderson 44 January S 22,000 Land Arturo James 105 Polk 45 December $ 950,000 Commercial Marcus Jackson 106 Henderson 46 January S 164,211 Commercial Marcus Jackson 106 Buncombe 47 October $ 151,500 Residential Marcus Jackson 106 Cleveland 48 January S 102,105 Residential Marcus Jackson 106 Rutherford 49 December $ 60,316 Commercial Marcus Jackson 106 Polk 50 January $ 48,516 Residential Marcus Jackson 106 Buncombe 51 November $ 43,750 Residential Marcus Jackson 106 Polk 52 January $ 445,000 Commercial Megan Cooper 107 Buncombe 53 January 245,000 Commercial Megan Cooper 107 Buncombe 54 October $ 70,000 Land Megan Cooper 107 Rutherford 55 November $ 69,375 Residential Megan Cooper 107 Polk 56 November $ 55,000 Commercial Megan Cooper 107 Henderson 57 November S 50,906 Land Megan Cooper 107 Henderson 58 December $ 47,344 Land Megan Cooper 107 Buncombe 59 October $ 354,600 Land Melanie Aaron 108 Rutherford 60 November S 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 S 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 $ 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 lanuary S 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 Pivot Table PivotChart EA 6-1, Chapman Realty US 82 January 83 November 84 November 85 November 86 January 87 November 88 November 89 December 90 October 91 October 92 October 93 January 94 January 95 January 96 November 97 November 98 November 99 January 100 December 101 102 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ B 163,500 Commercial 156,313 Commercial 130,875 Commercial 121,265 Residential 95,000 Land 85,438 Commercial 74,063 Commercial 69,078 Commercial 1,355,750 Commercial 970,500 Commercial 505,250 Commercial 486,800 Commercial 138,150 Land 129,000 Residential 61,813 Residential 54,688 Commercial 46,969 Residential 41,420 Commercial 40,938 Land D Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs E F 111 McDowell 111 Henderson 111 Buncombe 111 McDowell 111 Buncombe 111 Henderson 111 Buncombe 111 Polk 112 Cleveland 112 Buncombe 112 Cleveland 112 Polk 112 Cleveland 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson