Required information Excel Analytics 6-3 (Static) Sales Analysis of Business Segments [LO6-4] [The following information applies to the questions displayed below.] Chapman Realty Company is seeking your help in analyzing its monthly sales performance and the sales activity within its residential and commercial segments. During the most recent four-month 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. Click here for a brief tutorial on IF Statements in Excel. Excel Analytics 6-3 (Static) Part 5A 5. Summarize the number of residential sales transactions that occurred within various price ranges during the four-month period: a. Using filters, IF statements, and PivotTable, calculate the number of residential sales transactions that occurred within each of the following price ranges: (1) less than or equal to $100,000, (2) $100,001 through $200,000, (3) $200,001 through $300,000, (4) $300,001 through $500,000, and (5) greater than $500,000. > Answer is complete but not entirely correct. $500,000 15 x A B C D E F G 1 Month Selling Price Type Realtor RealtorID County 2 October $ 157,500 Commercial David Pullen 101 McDowell 3 January $ 88,800 Commercial David Pullen 101 Rutherford 4 November $ 67,875 Commercial David Pullen 101 Buncombe 5 November $ 53,938 Commercial David Pullen 101 Rutherford 6 October $ 2,989,500 Commercial David Willis 102 Buncombe 7 November $ 2,027,375 Commercial David Willis 102 Henderson 8 January $ 505,000 Commercial David Willis 102 McDowell 9 January $ 242,500 Land David Willis 10 January $ 236,300 Commercial David Willis 11 October $ 127,250 Residential David Willis 12 November $ 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 $ 18 January $ 51,359 Commercial 44,258 Land David Willis David Willis 19 October $ 3,014,750 Commercial Hal Keefer 20 January $ 717,000 Commercial Hal Keefer 21 October 22 December $ 23 November $ 24 December $ 25 November $ 26 December $ 27 November $ 28 December $ 29 January 30 December $ $ 585,000 Commercial Hal Keefer 288,422 Commercial 272,625 Land 204,469 Land 83,625 Residential 49,831 Commercial 47,500 Residential 536,844 Commercial Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer 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 Hal Keefer 103 Cleveland Jon Dolan 104 McDowell $ 81,117 Commercial Jon Dolan 104 Buncombe 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 $ 368,938 Commercial Arturo James 105 McDowell 35 October $ 365,060 Land Arturo James 105 Rutherford 36 January $ 287,000 Commercial Arturo James 105 Buncombe 37 October $ 275,000 Residential Arturo James 105 Henderson 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 105 Buncombe 41 January $ 66,000 Residential Arturo James 105 Buncombe 42 December $ 57,031 Commercial Arturo James 105 Buncombe 43 January $ 44,916 Residential Arturo James 44 January $ 22,000 Land Arturo James 105 Henderson 105 Polk 45 December $ 950,000 Commercial Marcus Jackson 106 Henderson 46 January $ 164,211 Commercial Marcus Jackson 47 October $ 151,500 Residential Marcus Jackson 48 January $ 102,105 Residential Marcus Jackson 49 December $ 60,316 Commercial Marcus Jackson 50 January $ 48,516 Residential Marcus Jackson 51 November $ 43,750 Residential Marcus Jackson 106 Buncombe 106 Cleveland 106 Rutherford 106 Polk 106 Buncombe 106 Polk 52 January $ 445,000 Commercial Megan Cooper 107 Buncombe 53 January $ 245,000 Commercial Megan Cooper 107 Buncombe 54 October 55 November $ 56 November $ $ 70,000 Land Megan Cooper 69,375 Residential 55,000 Commercial Megan Cooper 107 Rutherford 107 Polk Megan Cooper 107 Henderson 57 November $ 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 $ 176,250 Commercial Melanie Aaron 61 November $ 118,650 Residential Melanie Aaron 108 Cleveland 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 $ 68 November $ 69 November $ 697,875 Commercial 202,530 Land Eun Jung Bae 109 Buncombe Eun Jung Bae 109 Henderson 80,633 Commercial Eun Jung Bae 109 Cleveland 70 November $ 79,325 Land Eun Jung Bae 71 January $ 67,500 Residential Eun Jung Bae 109 Cleveland 109 Polk 72 January $ 54,539 Land Eun Jung Bae 109 McDowell 73 December $ 45,453 Residential Eun Jung Bae 109 Buncombe 73 December 45,453 Residential 74 January $ 1,150,000 Residential Eun Jung Bae 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 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk 110 Henderson 110 Buncombe 110 Polk 80 January $ 42,840 Commercial Mitch Davis 110 Cleveland 81 October $ 312,500 Residential Nicole Ashby 111 McDowell 82 January $ 163,500 Commercial Nicole Ashby 111 McDowell 83 November $ 84 November $ 85 November $ 86 January 87 November $ 88 November $ 89 December $ $ 90 October $ 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 Nicole Ashby 111 Henderson Nicole Ashby 111 Buncombe Nicole Ashby 111 McDowell Nicole Ashby 111 Buncombe Nicole Ashby 111 Henderson Nicole Ashby Nicole Ashby 111 Buncombe 111 Polk 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 112 Cleveland 112 Buncombe 112 Cleveland 112 Polk 112 Cleveland 95 January $ 129,000 Residential Pete Jacobs 112 Buncombe 96 November $ 97 November $ 61,813 Residential Pete Jacobs 54,688 Commercial Pete Jacobs 98 November $ 46,969 Residential Pete Jacobs 99 January $ 41,420 Commercial Pete Jacobs 100 December $ 40,938 Land Pete Jacobs 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson 101