Number 8

Saved Data Analytics Chapter 6 Check my work 8 ! Required Information [The following information applies to the questions displayed below) Part 3 of 9 0.2 points 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 countles for a total of $30,637161 Click here to download the Excel template, which you will use to answer the questions that follow eBook 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 References 3c. Which month had the lowest number of Residential sales transactions? What was that total? 3d. Which month had the lowest number of Commercial sales transactions? What was that total? 3.C. had the lowest number of Residential sales transactions with a total of had the lowest number of Commercial sales transactions with a total of 3-d. G 1 Month October 3 January November November 6 October 7 November 8 January 9 January 10 January 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 January 45 December 46 January 47 October B D E E Selling Price Type Realtor f Realtorio County $ 157,500 Commercial David Pullen 101 McDowell $ 88,800 Commercial David Pulien 101 Rutherford $ 67875 Commercial David Pullen 101 Dincombe $ 53,938 Commercial David Pullen 101 Rutherford $ 2,989,500 Commercial David Wallis 102 Buncombe $ 2,027,375 Commercial Devid Wis 102 Henderson $ 505,000 Commercial David Willis 102 McDowel $ 242,500 Land David Willis 102 McDowell $ 236,300 Commercial David Willis 102 Polk $ 127,250 Residential David Will 102 Polk $ 108,125 Commercial David Willis 102 Buncombe $ 100,000 Land David Willie 102 Polk $ 98,750 Residential David W 102 McDowell $ 64,400 Residential David Wills 102 Henderson $ 62,719 Commercial David Willis 102 Buncombe $ 51,359 Commercial David Willis 102 Polk $ 44,258 Land David Willis 102 Henderson $ 3014,750 Commercial Hal Keefer 103 Rutherford $ 717,000 Commercial Hal Keefer 103 Geveland $ 585,000 Commercial Hal Keefer 103 Rutherford $ 28.8.422 Commercial Hal Keefer 103 Cleveland $ 272,625 Land Hal Keeter 103 Rutherford $ 204,469 Land Hal Keefer 103 Cleveland $ 83,625 Residential Hal Keefer 103 Polk $ 49,831 Commercial Hal Keefer 103 McDowell $ 47,500 Residential Hal Keefer 303 Geveland $ 536,844 Commercial Jon Dolan 104 McDowell $ 81117 Commercial Jon Dolan 104 Buncombe $ 50.158 Commercial Jon Dolan 104 Buncombe $ 45,680 Land Jon Dolan 104 Buncombe $ 41.875 Commercial Jon Dolan 104 Buncombe $ 403,500 Commercial Arturo James 105 Buncombe $ 368,938 Commercial Arturo James 105 McDowell $ 365,060 Land Arturo James 105 Rutherford S 287.000 Commercial Arturo lames 105 Buncombe $ 275.000 Residential Arturo James 105 Henderson $ 218.000 Commercial Arturo James 105 Buncombe $ 214.500 Hesidential Arturo James 105 McDowel S 98.156 Commercial Arturo James 105 Buncombe $ 66,000 Residential Arturo James 105 Buncombe S 57,031 Commercial Arturo ames 105 Suncombe $ 44,916 Residential Arturo James 105 Henderson $ 22.000 Land Arturo James 105 Pok $ 950,000 Commercial Marcus Rackson 106 Henderson 5 164,211 Commercial Marcus Jackson 106 Buncombe 151.500 Residents Marcus lackson 105 Cleveland Pivot Table PivotChart IF Statements EA 6-3 5 - Morth 48 annuary 49 December 50 January 51 November 52 January 53 January 54 October 55 November 56 November 52 November 58 December 59 October 60 November 61 November 62 January 63 December 64 January 65 January 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 81 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 Selling Price lvpe Realtor Reator County $ 102,105 Residential Marcus dison 106 Rutherford 5 60,316 Commercial Marcus leckson 106 Polk $ 48,516 Residential Marcus Lackson 106 Bunscombe $ 43,750 Residential Marcus Jackson 106 Polk $ 445,000 Commercial Megan Cooper 107 Buncombe $ 245,000 Commercial Megan Cooper 107 Buncombe $ 70,000 Land Megan Cooper 107 Rutherford $ 69,375 Residential Megan Cooper 107 Polk $ 55,000 Commercial Megan Cooper 107 Henderson $ 50,906 Land Megan Cooper 107 Henderson $ 47,344 Land Megan Cooper 107 Buncombe $ 354,600 Land Melanie Aaron 108 Rutherford $ 176,250 Commercial Melanie Aaron 108 Cleveland $ 118,650 Residential Melanie Aaron 108 Polk $ 60,559 Residential Melanie Aaron 108 Buncombe $ 59,663 Residential Melanie Aaron 108 Buncombe $ 50,279 Land Melanie Aaron 108 Rutherford $ 47,270 Commercial Melanie Aaron 108 Buncombe $ 2,671,500 Commercial Eun Jung Bae 109 Henderson $ 697,875 Commercial Eun Jung Bae 109 Buncombe $ 202,530 Land Eunjung Bae 109 Henderson $ 80,633 Commercial Eun Jung Bae 109 Cleveland $ 79,325 Land Eunjung Bae 109 Cleveland $ 67,500 Residential Eun lung Bae 109 Polk $ 54.539 Land Eun Jung Bae 109 McDowell $ 45,453 Residential Eun Jung Bae 109 Buncombe $ 1,150,000 Residential Mitch Davis 110 Rutherford $ 1,033,688 Land Mitch Davis 110 Cleveland $ 221,750 Commercial Miech Davis 110 Polk $ 197 300 Residential Mitch Davis 110 Henderson $ 122 234 Residential Mitch Davis 110 Buncombe $ 95,750 Residential Mitch Davis 110 Polk $ 42.840 Commercial Mitch Davis 110 Cleveland 312,500 Residential Nicole Ashby 111 McDowell 163,500 Commercial Nicole Ashby 111 McDowel 156,313 Commercial Nicole Ashby 111 Henderson 130,875 Commercial Nicole Ashby 111 Buncombe $ 121.265 Residential Nicole Ashby 111 McDowell $ 95.000 and Nicole Ashby 111 Buncombe $ 85438 Commercial Nicole Ashby 111 Henderson 5 74,063 Commercial Nicole Ashby 111 Buncombe $ 69,078 Commercial Nicole Ashby 111 Polk 5 1355,750 Commercial Pete lacobs 212 Cleveland 5 970,500 Commercial Pete Jacobs 112 Buncombe $ 505 250 Commercial Pete Jacobs 112 Ceveland S 186,800 Commercial Pete lacos 112 Polk $ 138,150 Land Pete Jacobs 112 Cleveland Pivot Table PivotChart IF Statements EA 6-3 U U U U U US D66 Realtorld County Month 99 January 91 January 95 January 96 November 97 November 98 November 99 January 100 December 101 102 103 Eun Jung Bae Selling Price Type Realtor $ 486, 800 Commercial Pete Jacobs $ 138,150 land Pete lacobs $ 129,000 Residential Pete lacobs $ 61 813 Residential Pete Jacobs $ 54,688 Commercial Pete Jacobs $ 46,969 Residential Pete Jacobs $ 41,420 Commercial Pete lacobs $ 40,938 Land Pete lacobs 112 Polk 112 Cleveland 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson 204 205 106 207 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 199