Number 10

what information do i need to attach to this?

! 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 Pivot Tables in Excel Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on IF Statements in Excel 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: (a) 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. R$ 100.000 $ 100,001 - $200,000 $200,001 - $300,000 $300,001 - $500,000 >$500,000 D E 1 Month Selling Price Type Retor Restorto County 2 October 5 157,500 Commercial David Putin 101. McDowell 3 january $ 88.800 Commercial David Pub 101 Rutherford 4 November $ 67,875 Commercio David Puller 101 Buncombe 5 November $ 53,93 Commercial David Pullen 101 Rutherford 6 October $ 2.989,500 Commercio David Wild 102 Buncombe 7 November $ 2,027.375 Commercial David W 102 Henderson & Juay $ 505,000 Comercial David Wild 102 McDowell 9 IMMY $ 242,500 Land David W 102 McDowel 10 MUY S 236,300 Commercial David W 102 Polk 11 October $ 127,250 Residential David Willis 102 Polk 12 November $ 108,125 Commercia David Wil 102 Buncombe 13 October $ 100,000 Land David W 102 Polk 14 November $ 98,750 Residential David W 102 McDowed 15 My $ 64.400 Residential David W 102 Henderson 16 November $ 62,719 Commercial David Wii 102 Buncombe 17 December $ 51,359 Commercial David Will 102 Pok 18 January $ 44,258 Land David W 102 Henderson 19 October $ 3,014,750 Commercial Haller 103 Rutherford 20 January $ 717,000 Commercial Haleler 103 Cleveland 21 October $ 585,000 Commercia Hal Keler 103 Rutherford 22 December $ 288.422 Commercia Hal Keler 103 Cleveland 23 November $ 272,625 Land Hal Koeler 103 Rutherford 24 December $ 204,469 Land Hal Keder 103 Cleveland 25 November $ 83,625 Residential Hal Keler 103 Pok 26 December $ 49,831 Commercial Haleler 103 McDowel 27 November $ 47.500 Residential Haleler 103 Cleveland 28 December S 536,844 Commercial Jon Dolan 104 McDowe 29 January $ 81,117 Commercia Jon Dolan 104 Buncombe 30 December 5 50,158 Commercia Jon Dolan 104 Buncombe 31 January $ 45,680 Land Jon Dolan 104 Buncombe 32 December $ 41875 Commercial Jon Dolan 104 Buncombe 33 October $ 403.500 Commercial Arturo James 105 Buncombe 34 November 5 368,938 Commercial Arturo lame 105 McDowel 35 October 365060 Land Arturo James 105 Rutherford 36 January $ 287.000 Comercial Arturo James 105 Boncombe 37 October 275,000 Residenti At James 105 Henderson 38 December 218,000 Commercial Arturo lame 105 Buncombe 39 October 214.500 Residential Arturo James 105 McDowel 40 November 5 98,156 Commercial Artuojame 105 Buncombe 41 January 5 66,000 Residential Arturo 205 Boncombe 42 December $ 57,031 Commercia Arturo James 105 Buncombe 43 January s 44.916 Residenti Arturo James 105 Henderson 44 Ianuary s 22.000 and Arturones 105 Polk 45 December $ 950,000 Commedia Marcus Jackson 105 Henderson 46 January 5 164211 Commercia Marcus facicon 106 Huncombe 47 October 5 151.500 Residential Marcus Jackson 106 Cleveland 48 logary $ 102,105 Resident Marcus Jaco 106 Rutherford 49 December $ 60,316 Cammes Marcusacion 106 Polk 50 January 3 48,516 Residential Marc Jacos 10 uncombe 51 November 5 43.750 Residenti Marcuccion 106 To 52 January 3 445,000 Comme Mega Cooper 107 Buncombe 53 January $ 245.000 Camera Mee Cooper 107 Scombe 54 October $ 70,000 and Mega Coc 107 Ruthor S5 November $ 69,375 Residentia Megan Coop 107 Pax Pivot Table PivotChart IF Statements EA 6-3 2 D 56 November 107 Henderson $ 55.000 Commen Mee Cooper 57 November 107 Henderson $ 50,906 und Mega Cooper 53 December $ 47,244 Und Mee Cooper 107 Buncombe $ 59 October 354,600 Land 108 Rutherford Melanie Aron 108 Cleveland $ 60 November Mene Aaron 176.250 Comme 61 November $ 118,650 Residential Melanie Aaron 108 Pok $ 62 january 60,559 Residenti Melanie Aron 105 Buncombe 63 December $ 108 Buncombe 59,663 Residential Melanie Aron 108 Rutherford Melanie Aaron 64 January $ 50,279 Land $ 65 muay Melanie Aaron 47,270 Commercia 108 Buncombe 109 Henderson 66 October Eun Jung $ 2,671,500 Commerci 67 November $ 697875 Commerce Eun Jung 109 Buncombe 63 November $ 202.510 Und Eun Jung Be 109 Henderson 69 November $ 80,639 Commercial tu lut By 109 Cleveland 70 November $ 79,325 Land Eun June 6 109 Cleveland 71 UMY $ 67.500 Residential Eun Jung Bee 109 Pok 72 JUNY S 54,539 Land Esin Jung Ba 109 McDowell 73 December $ 45453 Residential Eun Jung Bae 109 Buncombe 74 UNY $ 1,150,000 Residential Mitch David 110 Rutherford 75 November $ 1,033,688 Land Mitch David 110 Cleveland 76 Oktober $ 221,750 Commercia Mitch Das 110 Polk 77 October $ 197,300 Residential Mitch Davis DIN 110 Henderson 78 December $ 122,234 Residenti Mitch Davis 110 Buncombe 79 October $ 95,750 Residential Mitch David 110 POR 80 January $ 42,840 Commercial Mitch David 110 Cleveland 81 October $ 312,500 Residential Nicole Ashby 111 McDowell 82 January $ 163,500 Commercial Nicole Ashby 111 McDowed B3 November $ 156,313 Commercial Nicole Ashby 111 Henderson 34 November $ 130,875 Commercial Nicole Ashby 111 Buncombe 85 November $ 121.265 Residential Nicole Ashby 111 McDowed 26 January 5 95,000 Land Nicole Ashby 111 Buncombe 87 November 85.438 Commercial Nicole Ashby 113 Henderson 38 November $ 74,063 Commercia Nicole Ashby 121 Buncombe 89 December 5 69,078 Commercial Nicole Ashby 111 Polk 30 October $ 1.355,750 Commercial Pete lacobs 112 Ceveland 91 October $ 970.500 Commerce Pete Jacobs 112 Suncombe 92 October $ 505 250 Commercial Pete Jacobs 112 Ceveland 93 January $ 186,800 Commercial Pete Jacobs 112 Polk 94 January $ 138,150 Land Pete lacobs 112 Cleveland 95 January $ 129.000. Residential Pete Jacobs 212 Buncombe 96 November 5 61,813 Residential Pete Jacobs 112 Buncombe 97 November $ 54,688 Commercia Petit lacobs 112 Pok 98 November $ 46.969 Residents Pete Jacobs 112 Rutherford 99 January 5 41.420 Comercia Pete lacobs 112 Pok 100 December 5 40.38 Lund Petecobs 101 112 Henderson 102 103 104 105 106 107 108 109 110 Pivot Table PivotChart IF Statements EA 6-3 + Da Check my work 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 PivotCharts in Excel Click here for a brief tutorial on IF Statements in Excel 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. >$500,000 Type 1 Month Selling Price 2 October $ 157.500 Commercial 3 January $ 88,800 Commercial 4 November $ 67,875 Commercial 5 November $ 53,938 Commercial 6 October $ 2,989,500 Commercial 7 November $ 2,027,375 Commercial 8 January $ 505,000 Commercial 9 January $ 242,500 Land 10 January S 236,300 Commercial 11 October $ 127250 Residential 12 November $ 108,125 Commercial 13 October $ 100,000 Land 14 November $ 98,750 Residential 15 January $ 64 400 Residential 16 November $ 62,719 Commercial 17 December $ 51,359 Commercial 18 January $ 44 258 land 19 October $ 3,014,750 Commercial 20 Ianuary 5 717,000 Commercial 21 October $ 585,000 Commercial 22 December $ 288422 Commercial 23 November $ 272,625 Land 24 December 5 204 469 Land 25 November $ 83,625 Residential 26 December s 49,831 Commercial 27 November $ 47,500 Residential 28 December $ 536 844 Commercial 29 January $ 81,117 Commercial 30 December $ 50.158 Commercial 31 January $ 45,680 Land 32 December $ 41.875 Commercial 33 October 5 403.500 Commercial 34 November 5 368,938 Commercial 35 October $ 365,060 Land 36 January $ 287.000 Commercial 37 October s 275,000 Residential 38 December 5 218.000 Commercial 39 October 5 214,500 Residential 40 November $ 98.156 Commercial 41 January $ 66,000 Residential 42 December $ 57,031 Commercial 43 January $ 44,916 Residential 44 January $ 22.000 Land 45 December $ 950,000 Commercial 46 January $ 164 211 Commercial 47 October 5 151 SOO Residential Realtor Realtori County David Pullen 101 McDowell David Pullen 101 Rutherford David Pullen 101 Buncombe David Pullen 101 Rutherford David Willis 102 Buncombe David Willis 102 Henderson David Willis 102 McDowell David Willis 102 McDowell David Willis 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Willis 102 Polk David Willis 102 McDowell David Willis 102 Henderson David Willis 102 Buncombe David Willis 102 Polk David Willis 102 Henderson Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Polk Hal Keefer 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowell Jon Dolan 101 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 106 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo lames 105 Rutherford Arturo James LOS Buncombe Arturo James 105 Henderson Arturo James 105 Buncombe Artur James 105 McDowell Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo ames 105-bun.combe Arturs James 105 Henderson Arturo lames 105 Polk Marcus lackson 106 Henderson Marcus adson 106 buncombe Marcus lackson 106 Cleveland I Statement FA 43 January 49 December 50 January 51 November 52 lanuary 59 January 54 October 55 November 56 November 57 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 lanuary 81 October 82 January 83 November B4 November 85 November 86 January 87 November 88 November 89 December 90 October 91 October 92 October 93 January 94 January $ 102,105 Residential Marcus Jackson 106 Rutherford $ 106 Polk 60,316 Commercial Marcus lackson $ 48,516 Residential Marcus Jackson 106 Buncombe $ 43,750 Residential Marcus leckson 106 Polk S 445,000 Commercial Megan Cooper 107 Buncombe $ 245,000 Commercial Megan Cooper 107 Buncombe S 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 S 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 5 79,325 Land Eun Jung Bae 109 Cleveland $ 67,500 Residential Eun Jung Bae 109 Polk $ 54.539 Land Eun Jung Bae 109 McDowel $ 45,453 Residential Eun Jung Bae 109 Buncombe $ 1.150,000 Residential Mitch Davis 110 Rutherford $ 2,033,688 Land Mitch Davis 110 Cleveland $ 221,750 Commercial Mitch Davis 110 Polk 5 197,300 Residential Mitch Davis 110 Henderson $ 122,234 Residential Mitch Davis 110 Buncombe $ 95,750 Residential Mitch Davis 110 Polk S 42.840 Commercial Mitch Davis 110 Cleveland $ 312,500 Residential Nicole Ashby 111 McDowell 5 163,500 Commercial Nicole Ashby 111 McDowell $ 156,313 Commercial Nicole Ashby 111 Henderson $ 130,875 Commercial Nicole Ashby 111 Buncombe $ 121.265 Residential Nicole Ashby 211 McDowell $ 95.000 Land Nicole Ashby 111 Buncombe $ 85438 Commercial Nicole Ashby 111 Henderson $ 74,063 Commercial Nicole Ashby 111 Buncombe $ 69,078 Commercial Nicole Ashby 111 Polk 5 1,355,750 Commercial Pete Jacobs 112 Cleveland 5 970,500 Commercial Pete Jacobs 112 Buncombe $ 505 250 Commercial Pete lacobs 112 Cleveland S 486 800 Commercial Pete Jacobs 112 Polk 5 138,150 Land Pete lacobs 112 Cleveland Pivot Table PivotChart IF Statements EA 6-3 + A B $ $ $ $ $ $ 129,000 Residential 61,813 Residential 54,688 Commercial 46,969 Residential 41,420 Commercial 40,938 Land Pete lacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete lacobs 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson 95 January 96 November 97 November 98 November 99 January 100 December 101 102 103 104 105 105 102 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 192 233 234 235 135 239