Posts

Showing posts from July, 2026

Predictive Model Analysis (2011 Predictors on 2013 Market Value). Using Thads Dataset

Image
  Stakeholder Report: Predictive Model Analysis (2011 Predictors on 2013 Market Value) Problem Statement The primary business objective is to understand and predict the market value of properties. Specifically, this analysis aims to determine how well observable housing characteristics from 2011 can predict the natural logarithm of the Market Value ( LN(VALUE) ) in 2013. Accurate predictions can assist in strategic planning, investment decisions, and market valuation assessments. 1. Data Importation Objective: To establish a foundational dataset for predicting 2013 property values. Method: Two datasets, Thads 2011.txt and Thads 2013.txt , containing housing characteristics and market values respectively, were imported from Google Drive into the Colab environment using pd.read_csv() . 2. Data Wrangling and Preprocessing This phase was critical to transform raw data into a clean, normalized, and model-ready format. Initial Merging & Filtering: Relevant variables from 2011 (e....

PREDICTING SINGLE HOUSING FAMILY UNIT USING THADS 2013 DATASET

Image
  Task The goal is to identify and quantify the factors that statistically predict or contribute to the current market value (VALUE) of single-family housing units using a Multiple Linear Regression model based on the THADS 2013 dataset. The task involves summarizing the OLS regression results, interpreting descriptive statistics and skewness of 'VALUE' and 'LN_VALUE', drafting a stakeholder report combining these findings, and proposing a follow-up plan for further investigation or model refinement. Subtask: Synthesize the key findings from the statsmodels OLS regression summary, including R-squared, F-statistic, significant coefficients, and potential issues like multicollinearity. 1. Executive Summary This report presents key findings from a Multiple Linear Regression analysis conducted on the THADS 2013 dataset to identify and quantify factors statistically predicting single-family housing market values. Our model, which explains approximately 67.6% of the variatio...

ANALYZING CHANGE IN MEAN MARKET VALUE THADS DATASET

Image
  1. Objective The primary objective of this assessment is to analyze the change in the Mean Fair Market Rent (FMR) across five distinct THADS years (2005, 2007, 2009, 2011, 2013). By conducting pairwise comparisons of FMR values between these years, we aim to understand the potential impact of the 2008 Subprime Mortgage Crisis on rental markets. 2. Methodology Data Source: The analysis utilizes THADS (The American Housing Survey) datasets for the years 2005, 2007, 2009, 2011, and 2013. Data Preparation: Individual year datasets were loaded and concatenated into a single DataFrame. A 'Year' column was added to each dataset to identify the origin year of the data. The 'FMR' (Fair Market Rent) column was converted to a numeric type, with non-convertible values coerced to NaN . An 'Occupancy_Status' column was derived from the 'STATUS' variable, categorizing units as 'Occupied' or 'Vacant'. Crucially, data points with FMR values less than $...