SOLVE TASK 6

For the following task use Group_XX_B file: Task-2: Draw the pair-wise plots between all the input variables and the output variable (Sale- Price). Task-3: Identify top and bottom three numerical variables that are strongly related to the output variable (Sale-Price)? Use the relevant analysis approach. Task-4: Show if the input variables have the information to separate low and high performing estat es? Use plots to justify, Task-5: What are the common patterns for the low performance of the estates? Use plots to justify Task-6: What are the common patterns for the high performance of the estates? Use plots to justify Class Table 1: Data Description (Any non-applicable value is set to NA) Fields Description Sale Price Sale Price of the property after 5 years from the date of purchase in millions of SAR. Purchase-Date Month and year, when the property was purchased. Purchase-Price Property's price at the time of purchase in millions of SAR. Type Type of the property. The property could be open-land, villa, duplex, flat. Legal classification of the property, could be one of the following options: residential, indus- trial, or commercial. Location Where the property is located w.r.t nearby city. 'Center' implies center of the city, Border implies at the entry/exit of city, 'Outskirts' implies on the outskirts of the city. Shape Shape of the property. It could be rectangle, trapezoid, irregular. U-Index Index based on number of utilities available on a scale of 1 to 5. A value of 5 indicates all utilities are available. Proximity Proximity to the nearest metro station in meters. N-Rank Rank based on neighborhood facilities that will make the property attractive on a scale of 1 to 10. A value of 1 indicates the best neighborhood. P-Chance Probability of finding parking space on adjacent roads at a given time. It is a value between 0 and 1, where 1 indicates sure a va ila bility of parking space. Built Original year of construction. Applicable for villa, duplex, flat. Renovate Latest renovation year. Applicable for villa , duplex, fiat. A value of 0 implies no renovation done so far or renovation not applicable. Access Type of direct access to the property, which could be street, alley or highway. Crime-Rate Average number of crimes reported per year in the neighborhood. C-Rating Plea santness of the climate throughout the year on a scale of 1 to 5. A value of 5 indicates pleasant climate. Gov-Index Expected level of government infrastructure project and/or developments in the neighbor hood on a scale of 1 to 10. A value of 10 indicates that there are huge developments planned by the government. Contour Flatness of the property. Applicable only for the open land type property. A value of C indicates the slope of the property is irregular. A value of F indicates the property has a smooth slope. Garage Is there a private parking garage? Yes or No. Applicable to the flat or duplex type. All villas have private garage. Swimming Is there a swimming pool? Yes or No. Applicable to the villa type. For the following task use Group_XX_B file: Task-2: Draw the pair-wise plots between all the input variables and the output variable (Sale- Price). Task-3: Identify top and bottom three numerical variables that are strongly related to the output variable (Sale-Price)? Use the relevant analysis approach. Task-4: Show if the input variables have the information to separate low and high performing estat es? Use plots to justify, Task-5: What are the common patterns for the low performance of the estates? Use plots to justify Task-6: What are the common patterns for the high performance of the estates? Use plots to justify Class Table 1: Data Description (Any non-applicable value is set to NA) Fields Description Sale Price Sale Price of the property after 5 years from the date of purchase in millions of SAR. Purchase-Date Month and year, when the property was purchased. Purchase-Price Property's price at the time of purchase in millions of SAR. Type Type of the property. The property could be open-land, villa, duplex, flat. Legal classification of the property, could be one of the following options: residential, indus- trial, or commercial. Location Where the property is located w.r.t nearby city. 'Center' implies center of the city, Border implies at the entry/exit of city, 'Outskirts' implies on the outskirts of the city. Shape Shape of the property. It could be rectangle, trapezoid, irregular. U-Index Index based on number of utilities available on a scale of 1 to 5. A value of 5 indicates all utilities are available. Proximity Proximity to the nearest metro station in meters. N-Rank Rank based on neighborhood facilities that will make the property attractive on a scale of 1 to 10. A value of 1 indicates the best neighborhood. P-Chance Probability of finding parking space on adjacent roads at a given time. It is a value between 0 and 1, where 1 indicates sure a va ila bility of parking space. Built Original year of construction. Applicable for villa, duplex, flat. Renovate Latest renovation year. Applicable for villa , duplex, fiat. A value of 0 implies no renovation done so far or renovation not applicable. Access Type of direct access to the property, which could be street, alley or highway. Crime-Rate Average number of crimes reported per year in the neighborhood. C-Rating Plea santness of the climate throughout the year on a scale of 1 to 5. A value of 5 indicates pleasant climate. Gov-Index Expected level of government infrastructure project and/or developments in the neighbor hood on a scale of 1 to 10. A value of 10 indicates that there are huge developments planned by the government. Contour Flatness of the property. Applicable only for the open land type property. A value of C indicates the slope of the property is irregular. A value of F indicates the property has a smooth slope. Garage Is there a private parking garage? Yes or No. Applicable to the flat or duplex type. All villas have private garage. Swimming Is there a swimming pool? Yes or No. Applicable to the villa type