Real Estate Project

Loads 2.2M residential listings from Realtor.com via Kaggle. Business goal is to establish the dataset foundation for analyzing what drives home prices.

Q1: Tests whether property characteristics significantly predict listing price.R2 = 0.1479 confirms house size is the strongest driver. Business goal is to identify which physical features matter most for pricing decisions.

Counts listings per state . Business goal is to understand geographic distribution of the dataset and identify which states are most represented.

Groups listings by state, calculates median listing price per state for Q2 visualization

Visualizes median listing price by state. Business goal is to communicate geographic price variation clearly to a business audience.

Plots house size against listing price. Business goal is to confirm relationship between square footage and price to support Q1 finding.

Filters extreme values for cleaner visual of house size vs price per sq ft. Business goal is to visually demonstrate that price per sq foot decreases as home size increases.

Filters extreme values for cleaner visual of house size vs price. Business goal is to produce a readable chart that clearly shows the upward price trend for business presentation.

Filter price per sq ft outliers then shows distribution Business goal is to show that most properties are priced between $50-300 square foot, confirming that price per square foot varies widely across the market and is a useful metric for identifying over or underpriced homes.

converts state categorical variable into binary dummy variables for regression

Q2: tests whether state level locatoin predicts listing price. r2 = 0.0131 confirms state explains just 1.3% of price variation. Business goal is to determine whether geographic location at state level is a useful pricing factor.

Q3: tests whether house size significantly predicts price per square foot. Coefficient = -0.027, p < 0.001 confirms larger homes cost less per square foot. Business goal is to validate price per square foot as a fair comparison metric across different sized homes.