number 11

what information do i need to attach to this?

Help Save & Exit Seved Submit Data Analytics Chapter 6 Check my work 11 O Part 6 of 9 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,637,161 0.2 points Click here to download the Excel template which you will use to answer the questions that follow BOOK 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 References 5c. 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 transactions is The number of transactions that occurred in this range is 1 Month 2 October 3 MUMY 4 November 5 November 6 October 7 November 3 Ianuary 9 IMMY 10 My 11 October 12 November 13 October 14 November 15 January 16 November 17 December 18 January 19 October 20 January 21 October 22 December 23 November 24 December 25 November 26 December 27 November 28 December 29 January 30 December 31 January 32 December 33 October 34 November 35 October 36 January 37 October 38 December 39 October 40 November 41 January 42 December 43 January 44 ianuary 45 December 46 January 47 October 48 January 49 December 50 Ianuary 51 November 52 Lanuary 53 January 54 October 55 November TY $ 157.500 Commercin $ 88.800 Commerci $ 67,875 Commerci $ 53,998 Commercial $ 2.989,500 Commercial $ 2,027,375 Commercial $ 505,000 Commercia $ 242,500 Land $ 236,300 Commerce $ 127,250 Residenti $ 108,125 Commerci $ 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 s 585,000 Commercial $ 288422 Commerce $ 272,625 Land $ 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial S 50,158 Commercial $ 45,680 Land $ 41.875 Commerce $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ 287000 Commercial 5 275.000 Residential $ 218,000 Commercial $ 214,500 Residential $ 98.156 Commercial $ 66,000 Residential 5 57,031 Commercial $ 44.916Residential $ 22,000 Land S 950,000 Commercial $ 164,211 Commerce 5 151.500 Residential $ 102 105 Residential 5 60,316 Commercial $ 49,516 Residenti $ 43.750 Residential s 445,000 Commerce $ 245.000 Commercia $ 70.000 Land 5 69,375 Residenti Restor tor County David Pulien 101 Mobowe David Pule 101 Rutherford Dwi Putin 101 Buncombe David Pullen 101 Rutherford David Wall 102 Buncombe David Wallis 102 Henderson David W 102 Metowe David Wis 102 McDowe David W. 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Wallis 102 Polk David W 102 McDowe David Wild 102 Henderson David Wies 102 Buncombe David Willis 102 Pok David Willis 102 anderson Hd Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Heeler 103 Cleveland Hal Keeler 103 Polk Hal Keeler 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowel Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Suncombe Jon Dolan 104 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo lanes 105 Rutherford Arturo lames 105 Buncombe Arturo lames 105 Henderson Arturo me 105 Buncombe Arturo James 105 McDowel Arturo James 105 Bancombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo lames 105 Henderson Arturo James 105 Polk Marcus laclean 106 Henderson Marcus Jackson 105 Suncombe Marcus Jackson 106 Cleveland Marcus Jackson 106 Rutherford Marcus lackson 105 Pok Marc Jacion 106 Buncombe Marcus Bacon 106 Pol Megan Cooper 107 uncombe Mega Cooper 107 uncombe Megan Cooper 107 Rutherford Megan Cooper 107 Po 55 November 55,000 Commenti 57 November $ 50.906 Land 53 December $ 47,344 Land 59 October $ 354,600 Lud 60 November $ 176,250 Commerci 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 Commerce 67 November $ 697875 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 Commercial 27 October s 197,300 Residential 78 December $ 122,234 Residential 79 October $ 95,750 Residential 30 January 42,840 Commercial 31 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 Commerci 91 October S 970,500 Commercial 92 October $ 505,250 Commercial 93 January $ 486 800 Commercial 94 January $ 138,150 Land 95 January S 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 S 40,938 Land UUUUUUUUUUUU Mee Cooper Megm Cooper Meem Cooper Melanie Aaron Melanie Aaron Melanie Aaron Melnie Aston 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 Bse Eun Jung Bse 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 lacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs 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 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 Pok 112 Rutherford 112 POR 112 Henderson U U Help Save & Exit Seved Submit Data Analytics Chapter 6 Check my work 11 O Part 6 of 9 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,637,161 0.2 points Click here to download the Excel template which you will use to answer the questions that follow BOOK 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 References 5c. 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 transactions is The number of transactions that occurred in this range is 1 Month 2 October 3 MUMY 4 November 5 November 6 October 7 November 3 Ianuary 9 IMMY 10 My 11 October 12 November 13 October 14 November 15 January 16 November 17 December 18 January 19 October 20 January 21 October 22 December 23 November 24 December 25 November 26 December 27 November 28 December 29 January 30 December 31 January 32 December 33 October 34 November 35 October 36 January 37 October 38 December 39 October 40 November 41 January 42 December 43 January 44 ianuary 45 December 46 January 47 October 48 January 49 December 50 Ianuary 51 November 52 Lanuary 53 January 54 October 55 November TY $ 157.500 Commercin $ 88.800 Commerci $ 67,875 Commerci $ 53,998 Commercial $ 2.989,500 Commercial $ 2,027,375 Commercial $ 505,000 Commercia $ 242,500 Land $ 236,300 Commerce $ 127,250 Residenti $ 108,125 Commerci $ 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 s 585,000 Commercial $ 288422 Commerce $ 272,625 Land $ 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial S 50,158 Commercial $ 45,680 Land $ 41.875 Commerce $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ 287000 Commercial 5 275.000 Residential $ 218,000 Commercial $ 214,500 Residential $ 98.156 Commercial $ 66,000 Residential 5 57,031 Commercial $ 44.916Residential $ 22,000 Land S 950,000 Commercial $ 164,211 Commerce 5 151.500 Residential $ 102 105 Residential 5 60,316 Commercial $ 49,516 Residenti $ 43.750 Residential s 445,000 Commerce $ 245.000 Commercia $ 70.000 Land 5 69,375 Residenti Restor tor County David Pulien 101 Mobowe David Pule 101 Rutherford Dwi Putin 101 Buncombe David Pullen 101 Rutherford David Wall 102 Buncombe David Wallis 102 Henderson David W 102 Metowe David Wis 102 McDowe David W. 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Wallis 102 Polk David W 102 McDowe David Wild 102 Henderson David Wies 102 Buncombe David Willis 102 Pok David Willis 102 anderson Hd Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Heeler 103 Cleveland Hal Keeler 103 Polk Hal Keeler 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowel Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Suncombe Jon Dolan 104 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo lanes 105 Rutherford Arturo lames 105 Buncombe Arturo lames 105 Henderson Arturo me 105 Buncombe Arturo James 105 McDowel Arturo James 105 Bancombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo lames 105 Henderson Arturo James 105 Polk Marcus laclean 106 Henderson Marcus Jackson 105 Suncombe Marcus Jackson 106 Cleveland Marcus Jackson 106 Rutherford Marcus lackson 105 Pok Marc Jacion 106 Buncombe Marcus Bacon 106 Pol Megan Cooper 107 uncombe Mega Cooper 107 uncombe Megan Cooper 107 Rutherford Megan Cooper 107 Po 55 November 55,000 Commenti 57 November $ 50.906 Land 53 December $ 47,344 Land 59 October $ 354,600 Lud 60 November $ 176,250 Commerci 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 Commerce 67 November $ 697875 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 Commercial 27 October s 197,300 Residential 78 December $ 122,234 Residential 79 October $ 95,750 Residential 30 January 42,840 Commercial 31 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 Commerci 91 October S 970,500 Commercial 92 October $ 505,250 Commercial 93 January $ 486 800 Commercial 94 January $ 138,150 Land 95 January S 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 S 40,938 Land UUUUUUUUUUUU Mee Cooper Megm Cooper Meem Cooper Melanie Aaron Melanie Aaron Melanie Aaron Melnie Aston 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 Bse Eun Jung Bse 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 lacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs 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 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 Pok 112 Rutherford 112 POR 112 Henderson U U