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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? sold Third highest Fifth highest 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 countles 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 PivotCharts in Excel. 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? Commercial Sold Land Sold Residential 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 countles 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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor seil? Buncombe Sold Henderson Sold Polk 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 PivotCharts In Excel. 4c. 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 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 PivotCharts In Excel. 5. Based on your findings in requirements 1-4, Who were the top performers? Total sales Sold Sold Commercial segment Land sales Sold Residential sales Sold Realtor David Pullen David Pullen David Pullen David Pullen David Willis David Willis David Willis Realtorld County 101 McDowell 101 Rutherford 101 Bungombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis Month Selling Price Type October $ 157,500 Commercial January $ 88,800 Commercial November $ 67,875 Commercial November $ 53,938 Commercial October $ 2,989,500 Commercial November $ 2,027,375 Commercial January $ 505,000 Commercial January $ 242,500 Land January $ 236,300 Commercial October $ 127,250 Residential November $ 108, 125 Commercial October $ 100,000 Land November $ 98,750 Residential January $ 64,400 Residential November $ 62,719 Commercial December $ 51,359 Commercial January $ 44,258 Land October $ 3,014,750 Commercial January $ 717,000 Commercial October $ 585,000 Commercial December $ 288,422 Commercial November $ 272,625 Land December $ 204,469 Land November $ 83,625 Residential December $ 49,831 Commercial November $ 47,500 Residential December $ 536,844 Commercial January $ 81,117 Commercial December $ 50,158 Commercial January $ 45,680 Land December 41,875 Commercial October $ 403,500 Commercial November $ 368,938 Commercial October $ 365,060 Land January $ 287,000 Commercial October $ 275,000 Residential David Willis David Willis Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell Jon Dolan Jon Dolan Jon Dolan Jon Dolan 104 Buncombe 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe Arturo James Arturo James Arturo James Arturo James Arturo James 105 Henderson Arturo James $ $ $ $ $ $ $ $ $ $ $ $ $ S S $ S $ $ S December October November Jankrary December January January Decernber January October January December January November January January October November November November December October November November January December January January October November November November November January January December January November October October December S $ 218,000 Commercial 214,500 Residential 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 Land 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 54,539 Land 45,453 Residential 1,150,000 Residential 1,033,688 Land 221 750 Commercial 197 500 Residential 122,234 Residential Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Megan Cooper - Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper 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 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 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 S $ S S $ S S S S S $ S S $ S S S S S $ S October January October January November November November January November November December October October October January January January November November November January December S S S $ $ S S S S S S $ S $ $ $ s S S 5 95,750 Residential 42,840 Commercial 312,500 Residential 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 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 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 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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? sold Third highest Fifth highest 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 countles 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 PivotCharts in Excel. 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? Commercial Sold Land Sold Residential 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 countles 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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor seil? Buncombe Sold Henderson Sold Polk 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 PivotCharts In Excel. 4c. 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 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 PivotCharts In Excel. 5. Based on your findings in requirements 1-4, Who were the top performers? Total sales Sold Sold Commercial segment Land sales Sold Residential sales Sold Realtor David Pullen David Pullen David Pullen David Pullen David Willis David Willis David Willis Realtorld County 101 McDowell 101 Rutherford 101 Bungombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis Month Selling Price Type October $ 157,500 Commercial January $ 88,800 Commercial November $ 67,875 Commercial November $ 53,938 Commercial October $ 2,989,500 Commercial November $ 2,027,375 Commercial January $ 505,000 Commercial January $ 242,500 Land January $ 236,300 Commercial October $ 127,250 Residential November $ 108, 125 Commercial October $ 100,000 Land November $ 98,750 Residential January $ 64,400 Residential November $ 62,719 Commercial December $ 51,359 Commercial January $ 44,258 Land October $ 3,014,750 Commercial January $ 717,000 Commercial October $ 585,000 Commercial December $ 288,422 Commercial November $ 272,625 Land December $ 204,469 Land November $ 83,625 Residential December $ 49,831 Commercial November $ 47,500 Residential December $ 536,844 Commercial January $ 81,117 Commercial December $ 50,158 Commercial January $ 45,680 Land December 41,875 Commercial October $ 403,500 Commercial November $ 368,938 Commercial October $ 365,060 Land January $ 287,000 Commercial October $ 275,000 Residential David Willis David Willis Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell Jon Dolan Jon Dolan Jon Dolan Jon Dolan 104 Buncombe 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe Arturo James Arturo James Arturo James Arturo James Arturo James 105 Henderson Arturo James $ $ $ $ $ $ $ $ $ $ $ $ $ S S $ S $ $ S December October November Jankrary December January January Decernber January October January December January November January January October November November November December October November November January December January January October November November November November January January December January November October October December S $ 218,000 Commercial 214,500 Residential 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 Land 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 54,539 Land 45,453 Residential 1,150,000 Residential 1,033,688 Land 221 750 Commercial 197 500 Residential 122,234 Residential Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Megan Cooper - Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper 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 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 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 S $ S S $ S S S S S $ S S $ S S S S S $ S October January October January November November November January November November December October October October January January January November November November January December S S S $ $ S S S S S S $ S $ $ $ s S S 5 95,750 Residential 42,840 Commercial 312,500 Residential 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 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 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