Price Per Square Foot Analysis & Trends Prompt
Prompt
Analyze price per sq ft trends to identify market movement. [PASTE: Historical sales data by property type, time period, neighborhood] Steps: 1) Calculate price per sq ft for all comps 2) Group by property type and neighborhood 3) Calculate median price per sq ft by period 4) Trend month-over-month and year-over-year 5) Identify anomalies and address 6) Project forward with trend analysis 7) Compare to national/state averages Output: Price per sq ft trend chart, historical table, market movement summary, forward projection.
Why it works
Price per sq ft trends reveal market movement quickly. Simple metric for rapid analysis.
Watch out for
Price per sq ft alone ignores quality differences. Must adjust for condition and amenities.
Used by
Data Analysts