Realtor David Pullen David Pullen David Pullen David Pullen David Wilts David Wasil fis David Willis Month October January November November October November January January January October November October November January November December January October January October December November December November December November December January December January December October November October January Selling Price Type $ 157,500 Commercial $ 88,800 Commercial $ 67,875 Commercial $ 53,938 Commercial $ 2,989,500 Commercial $ 2,027,375 Commercial 505,000 Commercial $ 242,500 Land $ 236,300 Commercial $ 127,250 Residential $ 108,125 Commercial $ 100,000 Land $ 98,750 Residential $ 64,400 Residential $ 62,719 Commercial $ 51,359 Commercial $ 44,258 Land $ 3,014,750 Commercial $ 717,000 Commercial $ 585,000 Commercial $ 288,422 Commercial $ 272,625 and $ 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial $ 50,158 Commercial $ 45,680 Land $ 41,875 Commercial $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ 287,000 Commercial David Willis David Willis David Willis David Will David Wils David Wills David Willis David Willis David Willis David Wills Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan Jon Dolan Jon Dolan Realtorld County 101 McDowell 101 Rutherfor 101 Buncomb 101 Rutherfor 102 Buncombe 102 Henderso 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 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Burcombe Jon Dolan Jon Dolan Arturo James Arturo James Arturo James Arturo James $ 105 Henderson $ S Arturo James Arturo James Arturo James Arturo James $ S $ Arturo James $ $ $ $ $ $ $ October December October November January December January January December 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 275,000 Residential 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 $ $ $ $ $ $ $ $ $ $ $ $ $ 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 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 108 Polk 108 Buncombe $ $ 108 Buncombe 108 Rutherford $ S 108 Buncombe 109 Henderson $ $ $ $ 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe $ $ $ January S 110 Rutherford November October October December October January October January November November November January November November December October October October January January January November November November January December $ 1,033,688 Land $ 221,750 Commercial $ 197,300 Residential $ 122,234 Residential $ 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 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 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 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,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 PivotTables 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 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 PlvotCharts 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 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 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. 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor sell? Buncombe Henderson Polk 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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 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 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 PlvotCharts in Excel. 5. Based on your findings in requirements 1-4, Who were the top performers? Sold Total sales Commercial segment Sold Land sales Sold Residential sales Sold Realtor David Pullen David Pullen David Pullen David Pullen David Wilts David Wasil fis David Willis Month October January November November October November January January January October November October November January November December January October January October December November December November December November December January December January December October November October January Selling Price Type $ 157,500 Commercial $ 88,800 Commercial $ 67,875 Commercial $ 53,938 Commercial $ 2,989,500 Commercial $ 2,027,375 Commercial 505,000 Commercial $ 242,500 Land $ 236,300 Commercial $ 127,250 Residential $ 108,125 Commercial $ 100,000 Land $ 98,750 Residential $ 64,400 Residential $ 62,719 Commercial $ 51,359 Commercial $ 44,258 Land $ 3,014,750 Commercial $ 717,000 Commercial $ 585,000 Commercial $ 288,422 Commercial $ 272,625 and $ 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial $ 50,158 Commercial $ 45,680 Land $ 41,875 Commercial $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ 287,000 Commercial David Willis David Willis David Willis David Will David Wils David Wills David Willis David Willis David Willis David Wills Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan Jon Dolan Jon Dolan Realtorld County 101 McDowell 101 Rutherfor 101 Buncomb 101 Rutherfor 102 Buncombe 102 Henderso 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 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Burcombe Jon Dolan Jon Dolan Arturo James Arturo James Arturo James Arturo James $ 105 Henderson $ S Arturo James Arturo James Arturo James Arturo James $ S $ Arturo James $ $ $ $ $ $ $ October December October November January December January January December 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 275,000 Residential 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 $ $ $ $ $ $ $ $ $ $ $ $ $ 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 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 108 Polk 108 Buncombe $ $ 108 Buncombe 108 Rutherford $ S 108 Buncombe 109 Henderson $ $ $ $ 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe $ $ $ January S 110 Rutherford November October October December October January October January November November November January November November December October October October January January January November November November January December $ 1,033,688 Land $ 221,750 Commercial $ 197,300 Residential $ 122,234 Residential $ 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 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 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 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,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 PivotTables 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 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 PlvotCharts 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 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 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. 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor sell? Buncombe Henderson Polk 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 Pivot Tables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 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 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 PlvotCharts in Excel. 5. Based on your findings in requirements 1-4, Who were the top performers? Sold Total sales Commercial segment Sold Land sales Sold Residential sales Sold