number 11

what else do I need to show?

Required information 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,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 CHICKIHrena bretorial on PivotCharts in Excel Click here for a brief tutorial on IF Statements in Excel. Sc. Which price range had the highest number of residential sales transactions? How many transactions occurred within that range? The price range with the highest number of residential sales transactionals the number of transactions that occurred in this range is G Month Selling Price Type Mester Resort County 2 October $ 157,500 Commen David Puen 101 Metod 3 JUNY $ 88,800 Commen David Pule 101 Rutherford 4 November $ 67,875 Com David Putin 101 Buncombe 5 November $ 53,938 Commercial Dawid Pullen 101 Rutherford 6 October $ 7,989.500 COIN Did W 102 Bancombe 7 November S2.027,375 CM Did Wills 102 Henderson 8 muay $ 505.000 Commen David W 102 McDowell 9 IMMY $ 242,500 Land Did w 102 McDowell 10 lat $ 236,300 Conwerin David W 102 Polk 11 October 127250 Residentin Did W 102 Polka 12 November $ 108,125 Commer David W 102 Buncombe 13 October 100.000 and Did Will 102 Pole 14 November $ 98,750 Residenti David Wii 102 McDowell 15 January $ 64,400 Residenti David Wild 102 Henderson 16 November $ 62,719 Commercial David W 1OZ Buncombe 17 December $ 51,359 Commercial David Will 102 Pod 10 January $ 44,258 Land David Wis 102 Henderson 19 October $ 3,014,750 Commercial Hi Keeler 103 Rutherford 20 May S 717,000 Commercial HN Keeler 103 Cleveland 21 October $ 585.000 Commercial M Keefer 103 Rutherford 22 December $ 288.422 Commercial Hal Keder 102 Ceveland 23 November $ 272,625 Land Hileler 103 Rutherford 24 December $ 204,469 Land Herder 103 Cleveland 25 November S 83,625 Residential Haller 103 Polk 26 December S 49 831 Commercial Hal Keder 103 McDowell 27 November $ 47.500 Residential Her 103 Cleveland 28 December 5 536,844 Commercial Jon Dolan 104 McDowel 29 January $ 81,117 Commercial Jon Dolan 104 Buncombe 30 December $ 50,158 Commercial Jon Dolan 104 Boncombe 31 January $ 45,680 Land Jon Dolan 104 Buncombe 32 December 5 41 875 Commercial Jon Dolan 104 Suncombe 33 October 403,500 Commercial Arturo lame 105 Boncombe 34 November 5 368,928 Commercial Arturo lames 105 McDowel 35 October $ 365060 Land Arturo James 105 Rutherford 36 January 5 287.000 Commercial Arturo 105 Buncombe 37 October $ 275.000 Residential Arturo James 105 Henderson 38 December 3 218,000 Commercial Arturo ames 105 Suncombe 39 October 5 214 500 Resident Arturolmes 105 McDowell 40 November S 98,155 Commercio Arturo James 105 Buscombe 41 ianuary 5 66.000 Residential Arturo las 105 Buncombe 42 December $ 57031 Commercial Arturo lames 105 Huncombe 43 January $44,916 Residential Arturones 105 Henderson 44 January 3 22,000 Land Arturo ames 105 Por 45 December 5 950,000 Commen Marcus laction 106 Henderson 46 January S 164211 Commercio Marcus Jackson 106 Banco 47 October 5 151.500 Residenti Marcus Jackson 105 Cleveland 48 January $ 102.105 Redents Marcus Jackson 106 Rutherford 49 December 5 60,316 Commercial Maculacion 106 Por So January 49,516 Residenti Marcado 106 Buscombe 51 November 5 43,750 Residential Marcus con SOG PR 52 5 445.000 Commercial Mega Cooper 102 Buncombe 53 January 5 245.000 Commercial Megan Cooper 54 October 107 Scombe 70,000 Land Mee Cooper 107 Ruthford S5 November 69.375 Resident Megan Cooge 107 PB Pivot Table PivotChart IF Statements EA 6-3 Ready IT 22 GR 56 November 57 November 58 December 59 October G0 November G1 November 62 ay 63 December 64 January 65 JY 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 31 October 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 103 104 105 106 107 108 109 110 D CE TITE S 55,000 Commerci Mee Cooper $ 50,906 Land Mee Cooper $ 47,344 Und Mee Cooper $ 254,600 Land Melanie Aaron $ 176,250 Commercial Melanie Amon $ 118,650 Resident Melanie Aaron $ 60,559 Residenti Melanie Aaron $ 59,663 Residenti Melanie Aaron $ 50,279 Land Mane Aaron $ 47.270 Commercial Melanie Aaron $ 2,671,500 Commercial Eun Junge $ 697,875 Commercial Eun Junge $ 202,530 Land Fun lung $ 80,633 Commercial Eun Jung Boe $ 79,325 Land Eun lungo $ 67,500 Residential Eun Junge $ 54,539 Land Eun June $ 45.453 Residential Eun Jung Ba $1,150.000 Residential Mitch David $ 1,033,688 Land Mitch Davis $ 221,750 Commercial Mitch Davis $ 197,300 Residential Mitch Davis 5 122,234 Residential Mitch Davis $ 95,750 Residential Mitch David $ 42.840 Commercial Mitch Davis $ 312,500 Residenti Nicole Ashby $ 163,500 Commercial Nicole Ashby $ 156 313 Commercial Nicole Ashby $ 130,875 Commercial Nicole Ashby $ 121.265 Residential Nicole Ashby $ 95,000 Land Nicole Ashby 5 85 438 Commercial Nicole Ashby $ 74,063 Commercial Nicole Ashby 5 69,078Comme Nicole Ashby 5 1355,750 Commercial Peacobs s 970,500 Commercial Pete lacobs 5 505,250 Commercial Pete Jacobs $ 486,800 Commercial Peter Jacobs $ 138,150 Land Pete lacobs 5 129000 Residential Pete Jacobs $ 61 813 Residenti Pete lacobi 5 54,683 Commercia Pedelacobs $ 46.969 Residenti Pete lacobs 5 41420 Commercial Pete lacobs 5 40,938 Land Pete Jacobs 107 Henderson 107 Henderson 107 Boncombe 108 Rutherford 108 Oeveland 108 Pok 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Boncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Pok 109 McDowe 109 Buncombe 110 Rutherford 110 Geveland 110 Polk 110 Henderson 110 Suncombe 110 Pok 110 Cleveland 111 McDowell 111 Menu 111 Henderson 111 Buncombe 111 McDowe 111 Buncombe 113 Henderson 111 Buncombe 111 Pok 112 Card 112 Buco 112 Cand 112 Po 112 Cand 112 cm 112 cm 112 P 112 Rutherford 112 Post 112 Henderson A Pivot Table PivotChart IF Statements EA 6-3 Dond IT