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 land) across six counties for a total of $30,637,161. 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 Pivo Charts in Excel 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? Third highest Fifth highest Eun Jung Bae Arturo James sold sold $ 3.899,355 $ 2.420.101 david w hal kee arturo marcus megan melanie eunjur mitch nicole pete 2 October $ 157,500 Commercial 3 January $ 88,800 Commercial 4 November $ 67,875 Commercial 5 November $ 53,938 Commercial 6 October $ 2,989,500 Commercial 7 November $ 2,027,375 Commercial 8 January $ 505,000 Commercial 9 January $ 242,500 Land 10 January $ 236,300 Commercial 11 October $ 127.250 Residential 12 November $ 108,125 Commercial 13 October $ 100,000 Land 14 November $ 98,750 Residential 15 January $ 64,400 Residential 16 November $ 62,719 Commercial 17 December $ 51,359 Commercial 18 January $ 44,258 Land 19 October $ 3,014,750 Commercial 20 January $ 717,000 Commercial 21 October $ 585,000 Commercial 22 December $ 288,422 Commercial 23 November $ 272.625 Land 24 December $ 204,469 Land 25 November $ 83,625 Residential 26 December $ 49,831 Commercial 27 November $ 47,500 Residential 28 December $ 536,844 Commercial 29 January $ 81,117 Commercial 30 December $ 50,158 Commercial 31 January $ 45,680 Land 32 December $ 41.875 Commercial 33 October $ 403,500 Commercial 34 November $ 368,938 Commercial 35 October $ 365,060 Land 36 January $ 287,000 Commercial 37 October $ 275,000 Residential 38 December $ 218,000 Commercial 39 October 5 214,500 Residential 40 November $ 98,156 Commercial 41 January $ 66,000 Residential 42 December $ 57,031 Commercial $ 44,916 Residential 44 January $ 22,000 Land Anh SEO On Camal Pivot Table PivotChart Ready D E David Pullen 101 McDowell David Pullen 101 Rutherford David Pullen 101 Buncombe David Pullen 101 Rutherford David Willis 102 Buncombe David Willis 102 Henderson David Willis 102 McDowell David Willis 102 McDowell David Willis 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Willis 102 Polk David Willis 102 McDowell David Willis 102 Henderson David Willis 102 Buncombe David Willis 102 Polk David Willis 102 Henderson Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Polk Hal Keefer 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowell Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Rutherford Arturo James 105 Buncombe Arturo lames 105 Henderson Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Polk SAU EA 6-1, Chapman Realty + 43 January M30 16 D E B 0 November 1 January 2 December 33 January 14 January 25 December 16 January 47 October 48 January 49 December 50 January 51 November 52 January 53 January 54 October 55 November 56 November 57 November 58 December 59 October 60 November 61 November 62 January 63 December 64 January 65 January 66 October 67 November 68 November 69 November 70 November 71 January 72 January 73 December 74 January 75 November 76 October 77 October 78 December 79 October 80 January 81 October 82 January 83 November $ 98,156 Commercial $ 66,000 Residential $ 57,031 Commercial $ 44,916 Residential $ 22,000 Land $ 950,000 Commercial $ 164,211 Commercial $ 151,500 Residential $ 102,105 Residential $ 60,316 Commercial $ 48,516 Residential $ 43,750 Residential $ 445,000 Commercial $ 245,000 Commercial $ 70,000 Land $ 69,375 Residential $ 55,000 Commercial $ 50,906 40 $ 47,344 Land $ 354,600 Land $ 176,250 Commercial $ 118,650 Residential $ 60,559 Residential $ 59,663 Residential $ 50,279 Land $ 47,270 Commercial $ 2,671,500 Commercial $ 697.875 Commercial $ 202,530 Land $ 80,633 Commercial $ 79,325 Land $ 67,500 Residential S 54.539 Land $ 45,453 Residential $ 1,150,000 Residential $ 1,033,688 Land $ 221,750 Commercial S 197,300 Residential $ 122,234 Residential $ 95,750 Residential $ 42,840 Commercial S 312,500 Residential $ 163,500 Commercial s 156.313 Commercial Pivot Table PivotChart Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Polk Marcus Jackson 106 Henderson Marcus Jackson 106 Buncombe Marcus Jackson 106 Cleveland Marcus Jackson 106 Rutherford Marcus Jackson 106 Polk Marcus Jackson 106 Buncombe Marcus Jackson 106 Polk Megan Cooper 107 Buncombe Megan Cooper 107 Buncombe Megan Cooper 107 Rutherford Megan Cooper 107 Polk Megan Cooper 107 Henderson Megan Cooper 107 Henderson Megan Cooper 107 Buncombe Melanie Aaron 108 Rutherford Melanie Aaron 108 Cleveland Melanie Aaron 108 Polk Melanie Aaron 108 Buncombe Melanie Aaron 108 Buncombe Melanie Aaron 108 Rutherford Melanie Aaron 108 Buncombe Eun Jung Bae 109 Henderson Eun Jung Bae 109 Buncombe Eun Jung Bae 109 Henderson Eun Jung Bae 109 Cleveland Eun Jung Bae 109 Cleveland Eun Jung Bae 109 Polk Eun Jung Bae 109 McDowell Eun Jung Bae 109 Buncombe Mitch Davis 110 Rutherford Mitch Davis 110 Cleveland Mitch Davis 110 Polk Mitch Davis 110 Henderson Mitch Davis 110 Buncombe Mitch Davis 110 Polk Mitch Davis 110 Cleveland Nicole Ashby 111 McDowell Nicole Ashby 111 McDowell Nicole Ashby 111 Henderson EA 6-1, Chapman Realty E c FA B 59 October $ 354,600 Land 60 November $ 176,250 Commercial 61 November $ 118,650 Residential 62 January 60,559 Residential 63 December $ 59,663 Residential 64 January $ 50,279 Land 65 January $ 47,270 Commercial 66 October $ 2,671,500 Commercial 67. November $ 697,875 Commercial 68 November $ 202,530 Land 69 November $ 80,633 Commercial 70 November $ 79,325 Land 71 January $ 67,500 Residential 72 January $ 54,539 Land 73 December $ 45,453 Residential 74 January $ 1,150,000 Residential 75 November $ 1,033,688 Land 76 October $ 221,750 nmercial 77 October $ 197,300 Residential 78 December $ 122,234 Residential 79 October $ 95,750 Residential 80 January $ 42,840 Commercial 81 October $ 312,500 Residential 82 January $ 163,500 Commercial 83 November $ 156,313 Commercial 84 November S 130,875 Commercial 85 November $ 121,265 Residential 86 January $ 95,000 Land 87 November $ 85,438 Commercial 88 November $ 74,063 Commercial 89 December $ 69,078 Commercial 90 October $ 1,355,750 Commercial 91 October $ 970,500 Commercial 92 October $ 505,250 Commercial 93 January S 486,800 Commercial 94 January $ 138,150 Land 95 January $ 129,000 Residential 96 November $ 61,813 Residential 97 November $ 54,688 Commercial 98 November $ 46,969 Residential 99 January $ 41,420 Commercial 100 December $ 40,938 Land 101 12 Pivot Table PivotChart Ready Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Nicole Ashby 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 108 Rutherford 108 Cleveland 108 Polk 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk 110 Henderson 110 Buncombe 110 Polk 110 Cleveland 111 McDowell 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 EA 6-1, Chapman Realty + 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? Third highest Fifth highest Eun Jung Bae Arturo James sold sold $ 3,899,355 $ 2,420,101 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? $ Commercial Land David Willis Mitch Davis Sold Sold $ 6,981,391 2.820,722 1,033,688 Residential Mitch Davis Sold $ 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor sella Buncombe Henderson Polk David Willis (Eun Jung Bee Pete Jacobs Sold Sold Sold $ 6,561,919 $ 3,571,905 $ 958,839 4. Which realtor completed the second highest number of sales transactions during the four-month period? How many properties did the realtor sell? Sales transactions Sold 5. Based on your findings in requirements 1-4, Who were the top performers? Total sales Commercial segment Land sales Residential sales Sold Sold Sold Sold 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 land) across six counties for a total of $30,637,161. 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 Pivo Charts in Excel 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? Third highest Fifth highest Eun Jung Bae Arturo James sold sold $ 3.899,355 $ 2.420.101 david w hal kee arturo marcus megan melanie eunjur mitch nicole pete 2 October $ 157,500 Commercial 3 January $ 88,800 Commercial 4 November $ 67,875 Commercial 5 November $ 53,938 Commercial 6 October $ 2,989,500 Commercial 7 November $ 2,027,375 Commercial 8 January $ 505,000 Commercial 9 January $ 242,500 Land 10 January $ 236,300 Commercial 11 October $ 127.250 Residential 12 November $ 108,125 Commercial 13 October $ 100,000 Land 14 November $ 98,750 Residential 15 January $ 64,400 Residential 16 November $ 62,719 Commercial 17 December $ 51,359 Commercial 18 January $ 44,258 Land 19 October $ 3,014,750 Commercial 20 January $ 717,000 Commercial 21 October $ 585,000 Commercial 22 December $ 288,422 Commercial 23 November $ 272.625 Land 24 December $ 204,469 Land 25 November $ 83,625 Residential 26 December $ 49,831 Commercial 27 November $ 47,500 Residential 28 December $ 536,844 Commercial 29 January $ 81,117 Commercial 30 December $ 50,158 Commercial 31 January $ 45,680 Land 32 December $ 41.875 Commercial 33 October $ 403,500 Commercial 34 November $ 368,938 Commercial 35 October $ 365,060 Land 36 January $ 287,000 Commercial 37 October $ 275,000 Residential 38 December $ 218,000 Commercial 39 October 5 214,500 Residential 40 November $ 98,156 Commercial 41 January $ 66,000 Residential 42 December $ 57,031 Commercial $ 44,916 Residential 44 January $ 22,000 Land Anh SEO On Camal Pivot Table PivotChart Ready D E David Pullen 101 McDowell David Pullen 101 Rutherford David Pullen 101 Buncombe David Pullen 101 Rutherford David Willis 102 Buncombe David Willis 102 Henderson David Willis 102 McDowell David Willis 102 McDowell David Willis 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Willis 102 Polk David Willis 102 McDowell David Willis 102 Henderson David Willis 102 Buncombe David Willis 102 Polk David Willis 102 Henderson Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Polk Hal Keefer 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowell Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Rutherford Arturo James 105 Buncombe Arturo lames 105 Henderson Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Polk SAU EA 6-1, Chapman Realty + 43 January M30 16 D E B 0 November 1 January 2 December 33 January 14 January 25 December 16 January 47 October 48 January 49 December 50 January 51 November 52 January 53 January 54 October 55 November 56 November 57 November 58 December 59 October 60 November 61 November 62 January 63 December 64 January 65 January 66 October 67 November 68 November 69 November 70 November 71 January 72 January 73 December 74 January 75 November 76 October 77 October 78 December 79 October 80 January 81 October 82 January 83 November $ 98,156 Commercial $ 66,000 Residential $ 57,031 Commercial $ 44,916 Residential $ 22,000 Land $ 950,000 Commercial $ 164,211 Commercial $ 151,500 Residential $ 102,105 Residential $ 60,316 Commercial $ 48,516 Residential $ 43,750 Residential $ 445,000 Commercial $ 245,000 Commercial $ 70,000 Land $ 69,375 Residential $ 55,000 Commercial $ 50,906 40 $ 47,344 Land $ 354,600 Land $ 176,250 Commercial $ 118,650 Residential $ 60,559 Residential $ 59,663 Residential $ 50,279 Land $ 47,270 Commercial $ 2,671,500 Commercial $ 697.875 Commercial $ 202,530 Land $ 80,633 Commercial $ 79,325 Land $ 67,500 Residential S 54.539 Land $ 45,453 Residential $ 1,150,000 Residential $ 1,033,688 Land $ 221,750 Commercial S 197,300 Residential $ 122,234 Residential $ 95,750 Residential $ 42,840 Commercial S 312,500 Residential $ 163,500 Commercial s 156.313 Commercial Pivot Table PivotChart Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Polk Marcus Jackson 106 Henderson Marcus Jackson 106 Buncombe Marcus Jackson 106 Cleveland Marcus Jackson 106 Rutherford Marcus Jackson 106 Polk Marcus Jackson 106 Buncombe Marcus Jackson 106 Polk Megan Cooper 107 Buncombe Megan Cooper 107 Buncombe Megan Cooper 107 Rutherford Megan Cooper 107 Polk Megan Cooper 107 Henderson Megan Cooper 107 Henderson Megan Cooper 107 Buncombe Melanie Aaron 108 Rutherford Melanie Aaron 108 Cleveland Melanie Aaron 108 Polk Melanie Aaron 108 Buncombe Melanie Aaron 108 Buncombe Melanie Aaron 108 Rutherford Melanie Aaron 108 Buncombe Eun Jung Bae 109 Henderson Eun Jung Bae 109 Buncombe Eun Jung Bae 109 Henderson Eun Jung Bae 109 Cleveland Eun Jung Bae 109 Cleveland Eun Jung Bae 109 Polk Eun Jung Bae 109 McDowell Eun Jung Bae 109 Buncombe Mitch Davis 110 Rutherford Mitch Davis 110 Cleveland Mitch Davis 110 Polk Mitch Davis 110 Henderson Mitch Davis 110 Buncombe Mitch Davis 110 Polk Mitch Davis 110 Cleveland Nicole Ashby 111 McDowell Nicole Ashby 111 McDowell Nicole Ashby 111 Henderson EA 6-1, Chapman Realty E c FA B 59 October $ 354,600 Land 60 November $ 176,250 Commercial 61 November $ 118,650 Residential 62 January 60,559 Residential 63 December $ 59,663 Residential 64 January $ 50,279 Land 65 January $ 47,270 Commercial 66 October $ 2,671,500 Commercial 67. November $ 697,875 Commercial 68 November $ 202,530 Land 69 November $ 80,633 Commercial 70 November $ 79,325 Land 71 January $ 67,500 Residential 72 January $ 54,539 Land 73 December $ 45,453 Residential 74 January $ 1,150,000 Residential 75 November $ 1,033,688 Land 76 October $ 221,750 nmercial 77 October $ 197,300 Residential 78 December $ 122,234 Residential 79 October $ 95,750 Residential 80 January $ 42,840 Commercial 81 October $ 312,500 Residential 82 January $ 163,500 Commercial 83 November $ 156,313 Commercial 84 November S 130,875 Commercial 85 November $ 121,265 Residential 86 January $ 95,000 Land 87 November $ 85,438 Commercial 88 November $ 74,063 Commercial 89 December $ 69,078 Commercial 90 October $ 1,355,750 Commercial 91 October $ 970,500 Commercial 92 October $ 505,250 Commercial 93 January S 486,800 Commercial 94 January $ 138,150 Land 95 January $ 129,000 Residential 96 November $ 61,813 Residential 97 November $ 54,688 Commercial 98 November $ 46,969 Residential 99 January $ 41,420 Commercial 100 December $ 40,938 Land 101 12 Pivot Table PivotChart Ready Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Nicole Ashby 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 108 Rutherford 108 Cleveland 108 Polk 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk 110 Henderson 110 Buncombe 110 Polk 110 Cleveland 111 McDowell 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 EA 6-1, Chapman Realty + 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? Third highest Fifth highest Eun Jung Bae Arturo James sold sold $ 3,899,355 $ 2,420,101 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? $ Commercial Land David Willis Mitch Davis Sold Sold $ 6,981,391 2.820,722 1,033,688 Residential Mitch Davis Sold $ 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor sella Buncombe Henderson Polk David Willis (Eun Jung Bee Pete Jacobs Sold Sold Sold $ 6,561,919 $ 3,571,905 $ 958,839 4. Which realtor completed the second highest number of sales transactions during the four-month period? How many properties did the realtor sell? Sales transactions Sold 5. Based on your findings in requirements 1-4, Who were the top performers? Total sales Commercial segment Land sales Residential sales Sold Sold Sold Sold