number 14

Seved Data Analytics Chapter 6 Sue Help 0 14 Parto ore Part 9 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,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 PlvotCharts in Excel Click here for a brief tutorial on IF Statements in Excel 0.2 points eBook References Which of the following statements accurately describe the company's monthly sales activity and the price distribution of the company's residential and commercial sales transactions? (You may select more than one correct answer.) Check All That Apply was est month in terms of dollar sales and the number of sales transactions The highest sales dollars including all property types occurred in November The highest number of sales transactions occurred in January with 31 transactions The Commercial segment had 13 sales transactions above $500,000 s $ 2 3 1 Month Seng Price Type Restor Restor County 2 October 157.500 Commercial Dawid Pule 101 McDowell 3 JUNY $ 88.800 Commercia wid Pullen 101 Rutherford 4 November s 67,875 COMEN David Puter 101 Buncombe 5 November $ 53,938 Comercial David Pullen 101 Rutherford 5 October $ 2.989,500 Commen David W 102 Buncombe 7 November $ 2,027375 Commer Dwvid W 102 Henderson Juay $ 505.000 Comerci David W 102 Meow 9 JUNY $ 242,500 Lmd David Wil 102 MeDowell 10 UMY S 226,300 Commercial David Was 102 Polk IL Oxtober $ 127,250 Residenti David Will 102 Pok 12 November 5 108,125 Com David W 102 Buncombe 13 cxctober $ 100,000 Land David w 102 Por 14 November $ 98,750 Residenti David W 102 McDowe 15 May $ 64,400 Residential David Willis 102 Henderson 16 November $ 62,719 Commercial David Wils 102 Buncombe 17 December $ 51,359 Commercial David W 102 Polk 18 January $ 44,258 Land David W 102 Henderson 19 October $ 3,014,750 Commercial Ha Kefer 109 Rutherford 20 Ianuary $ 717,000 Commercial Hal Keder 103 Cleveland 21 October $ 585,000 Commercial Hal Keeler 103 Rutherford 22 December S 288.422 Commercial Hal Keder 103 Cleveland 23 November $ 272,625 Land Hal Keefer 103 Rutherford 24 December $ 204 469 Land HM Keefer 103 Cleveland 25 November 83,625 Residential Haleler 103 Polk 26 December $ 49,831 Commercial Hal Keefer 103 McDowell 27 November $ 47,500 Residential Hal Keler 103 Cleveland 28 December $ 536,844 Commercial Jon Dolan 104 McDowell 29 January $ 81,117 Commercial Jon Dolan 104 Buncombe 30 December $ 50,158 Commercial Jon Dolan 104 Buncombe 31 January S 45,680 Land Jon Dolan 104 Buncombe 32 December $ 41875 Commercial Jon Dolan 104 Buncombe 33 October $ 403.500 Commercial Arturo lames S105 Buncombe 34 November $ 368,938 Commercial Arturo James 105 McDowell 35 October $ 365,060 Land Arturo lames 105 Rutherford 36 January $ 287,000 Commercial Arturo James 105 Boncombe 37 October 5 275.000 Residential Arturo James 105 Henderson 38 December $ 218,000 Commercia Arturo lames 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 lames 105 Buncombe 42 December $ 57,031 Commercial Arturo James 105 Buncombe 43 Ianuary 5 44,916 Residential Artur James 105 Henderson 44 January $ 22,000 Land Arturo James 105 Pok 45 December $ 950,000 Commercial Marcus Jackson 106 Henderson 46 January S 164,211 Commercial Marcus Jackson 106 Buncombe 47 October S 151,500 Residential Marcus Jackson 106 Cleveland 48 January $ 102,105 Residential Marcus Jackson 106 Rutherford 49 December $ 60,316 Commercial Mures Jackson 106 Polk 50 January 5 48,516 Residential Marcos Jackson 106 Buncombe 51 November 5 43,750 Residential Marcus Jackson 106 Polk 52 January $ 445,000 Comercial Megan Cooper 107 Buncombe 53 January 245 000 Commercial Megan Cooper 107 Boncombe 54 October 70,000 Land Megan Cooper 107 Rutherford 55 November 69,375 Residential Megan Cooper 107 Pole Pivot Table PivotChart IF Statements $ EA 6.3 J79 A G 3 2 + 55 November 57 November 53 December 59 October 50 November 61 November 52 UMY 63 December 64 JUNY 65 JUNY 56 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 30 January 81 October 82 January 33 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 $ 55.000 Commercial $ 50,906 Land $ 47,244 Und $ 354,600 Land $ 176,250 Commerci $ 118,650 Residentin S 60,559 Residenti $ 59,663 Residentin S 50,279 Land $ 47,270 Commercial $ 2,671,500 Commerci $ 697,875 Commercial $ 202,530 Land $ 80,693 Commerci S 79,325 Land $ 67,500 Residential $ 54,539 Land $ 45,453 Residential $ 1,150,000 Residential $ 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 S 69,078 Commercial S 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 Wuuuu Megan Cooper Meean Cooper Megan Cooper Melanie Anon Melanie Aaron Melnie Amon Melanie Aaron Melanie Anon Melanie Aaron Melanie Aaron Eun Junge Eun Jung B.se Eun Junge Eun Jung Be Eun Jung Hy Eun Jung B Eun Jung Bae Eun Jung Ba Mitch David Mitch David Mitch Davis Mitch David Mitch David Mitch David Mitch David Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Pete lacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete lacobs Pete Jacobs Pete lacobs 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 Polk 112 Rutherford 112 Pok 112 Henderson