Price Per Square Foot Analysis & Trends
Operations Data Analyst Real Estate
The prompt
Analyze price per sq ft trends to identify market movement.
{{historical_sales_data_by_property_type_t}}
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 this works
Price per sq ft trends reveal market movement quickly. Simple metric for rapid analysis.
Risks & review
Price per sq ft alone ignores quality differences. Must adjust for condition and amenities.