Key Observations
1. Weak Overall Relationship
Across all categories, there is no strong relationship between housing median age
and house value. The regression lines are nearly horizontal, indicating that age alone
does not explain much variation in house prices.
2. High Variability in House Values
The data points are widely scattered, and high variability is present at almost every
age level. This suggests that house prices are influenced far more by other factors
such as location, income levels, room counts, or proximity to key economic areas.
Category-Wise Interpretation
1. ISLAND
Shows a slight positive slope, but the sample size is extremely small. As a result, the
observed trend cannot be considered reliable.
2. INLAND
Displays a noticeable negative slope. This indicates that, within inland areas, older
homes tend to have lower values. This pattern aligns with economic intuition: inland
homes generally have lower land appreciation and may depreciate more with age.
3. <1H OCEAN
Shows a mild positive trend. Older properties closer to the ocean may retain or gain
value because coastal areas tend to be more desirable, and land value increases over
time.
4. NEAR BAY
Also has a weak positive trend. Homes near the bay area may appreciate regardless
of age due to high demand in these regions.
5. Combined Sample Plot
When all categories are combined, the regression line is slightly positive, but the
overall relationship remains weak. Housing age is a minor predictor, and its influence
varies significantly by geographic category.
This correlation matrix shows how strongly each pair of numeric variables is related.
Correlation values range from -1 to 1:
+1 → perfect positive correlation
-1 → perfect negative correlation
0 → no linear relationship
Longitude vs Latitude - Very Strong Negative Correlation (~–0.97)
This is because the dataset is from California.
As you move west (more negative longitude), you also move south (lower latitude).
This is a geographical artifact, not meaningful for housing prices.
2. Strong Positive Correlations Among Housing Count Variables
total_rooms – total_bedrooms (0.93)
total_rooms – households (0.94)
population – households (0.92)
population – total_bedrooms (0.90)
households – total_bedrooms (0.99)
This tells us:
Areas with more total rooms also tend to have more bedrooms, more households,
and higher population.
These variables are highly collinear — they provide similar information.
3. Income Strongly Predicts House Value
median_income – median_house_value (0.70)
This is one of the strongest meaningful correlations in the dataset.
Higher-income areas tend to have significantly higher home prices.
This is expected in most real-estate datasets.
4. Weak or No Correlation with House Value
The following have low or no correlation with median_house_value:
longitude (-0.28)
latitude (0.14)
housing_median_age (-0.027)
total_rooms (0.22)
total_bedrooms (0.15)
population (0.018)
households (0.15)
Indicates:
Housing age doesn’t strongly predict price.
Raw counts (like population, rooms) don't directly predict price without
normalization.
Better features: rooms_per_household, bedrooms_per_room,
population_per_household.
These derived ratios often correlate much better.
5. Moderate Correlations
median_income – total_rooms (0.30)
Higher-income neighborhoods tend to have more rooms but the relationship is not very
strong.
6. Insights Related to Modeling
Multicollinearity Warning 🚨
Several variables are too strongly correlated (>0.90).
This can cause instability in linear regression.
You may consider:
Dropping one of: total_rooms, total_bedrooms, households, population
Or deriving new features (density ratios)
7. Spatial Effects
Even though longitude and latitude don’t correlate strongly with price directly, they
often matter in models due to location-based clustering, but correlation alone
cannot capture this.
Summary (If You Had to Explain in One Slide)
Strongest predictor of house value = median_income (0.70).
Housing density variables (total_rooms, total_bedrooms, population, households)
are highly collinear.
Geographic variables (longitude, latitude) have little direct relationship to house
value.
Housing median age has almost no correlation with value.
Derived features will likely improve predictive power.
1. Total Rooms vs Median House Value
Interpretation:
The plot shows wide vertical spread: for a given number of rooms, house values vary
greatly.
There is no strong linear relationship (matches correlation ≈ 0.22).
Many points cluster around 0–4000 rooms, but house prices even in this range vary
from 50k to 500k.
Key Insight:
Raw total room count is not a good predictor of house price.
But derived ratios like:
o rooms_per_household
o rooms_per_bedroom
o rooms_per_person
often correlate better because they capture density and housing quality.
✅ 2. Total Bedrooms vs Median House Value
Interpretation:
Similar pattern to total rooms.
No clear upward trend → weak correlation (≈ 0.15).
Points are very scattered.
Higher bedroom counts do not guarantee higher home values.
Key Insight:
Total bedrooms is also not useful in raw form.
Derived feature bedrooms_per_room is much more predictive and commonly used
in models.
✅ 3. Households vs Median House Value
Interpretation:
Again, heavily scattered.
Weak correlation (≈ 0.15).
Even when households increase to 4000, home prices remain spread across entire
range.
Key Insight:
The number of households in a block group does not directly predict house value.
But population per household or rooms per household often bring meaningful
predictive power.
✅ 4. Population vs Median House Value
Interpretation:
No meaningful trend (correlation ≈ 0.018 — almost zero).
Neighborhoods with very high population do not necessarily have expensive homes.
High-population areas often have lower-value or average homes due to density.
Key Insight:
Raw population count does not explain house value.
But population density often matters:
o population / households
o population / area (if area data is available)
✅ 5. Housing Median Age vs Median House Value
Interpretation:
Completely scattered.
Almost no correlation (≈ –0.03).
Newer houses don't have consistently higher values.
Older houses don’t necessarily have lower values either.
Why?
California housing is unique:
Some older neighborhoods are extremely expensive (e.g., coastal areas).
Some newer developments are in cheaper inland areas.
Key Insight:
Housing age alone is not a good predictor.
But:
o age grouped into bins (e.g., 0–10, 10–20 years)
o or age interacting with location
can provide more insight.
NOTE: Step 1: Identify the variables
Note the labels on the x-axis (independent variable) and y-axis (dependent variable)
to understand what is being measured.
Step 2: Determine the direction of the correlation
Positive Correlation: Points trend upward from the bottom-left to the top-right. As
one variable increases, the other also tends to increase.
Negative Correlation: Points trend downward from the top-left to the bottom-right.
As one variable increases, the other tends to decrease.
No Correlation: Points are scattered with no discernible upward or downward trend.
Step 3: Analyse the strength of the correlation
Strong: Points are clustered tightly around an imaginary line. This can be a perfect
straight line (perfect correlation) or a tight band.
Weak: Points are widely scattered, with little to no clear pattern.
Moderate: Points show a general trend but are not tightly clustered or completely
scattered.
Step 4: Identify the form of the relationship
Linear: The points tend to follow a straight line. This is the most common type of
relationship analysed with scatter plots.
Nonlinear: The points follow a curved pattern.
Step 5: Look for outliers
Identify any data points that are far away from the general pattern. These outliers
can have a significant impact on the overall analysis.
1. ISLAND
Very few data points, so conclusions are limited.
The ratio rooms_per_bedroom ranges only between 3 and 4, indicating consistent
housing structure.
House values are relatively high (300,000 to 500,000).
Interpretation:
Even with little variation in room–bedroom ratio, ISLAND properties tend to be expensive
due to location rather than house structure.
2. INLAND
A moderate positive trend is visible.
As rooms_per_bedroom increases, house values generally increase.
Most values fall between 150k and 350k.
Interpretation:
For inland locations, a higher room–bedroom ratio (indicating larger or less crowded houses)
correlates with higher property value.
3. <1H OCEAN
Displays a clearer positive relationship.
Higher ratios of rooms per bedroom tend to be associated with higher-priced
houses.
House values show a broad spread but trend upward.
Interpretation:
Closer proximity to the ocean amplifies the positive influence of better housing structure on
value.
4. NEAR BAY
Shows the strongest dispersion.
Many houses cluster at the maximum allowed value (500k), suggesting a capped
value effect.
There is still a slight positive slope between rooms_per_bedroom and house value.
Interpretation:
Bay areas are premium locations, and house structure matters less than location. Many
values hit a ceiling, masking the true relationship.
5. NEAR OCEAN
The pattern resembles <1H OCEAN but with more density around mid-range prices.
Higher rooms_per_bedroom ratios are weakly associated with higher house values.
Interpretation:
Ocean-adjacent properties show a modest but visible upward trend: more spacious houses
tend to be more valuable.
Summary Statement
The ratio rooms_per_bedroom is mildly to moderately predictive of house value, but
location heavily modifies the strength of this relationship. Properties closer to the ocean or
bay tend to be higher valued regardless of structural ratios, while inland areas show a more
direct relationship between spatial house characteristics and price.