Predictive Rental Market Segmentation Analysis Tool

Build an Excel-based predictive analytics tool that segments rental markets using machine learning-inspired clustering techniques. Utilize advanced statistical functions to analyze historical rental data, incorporating variables like neighborhood demographics, economic indicators, property type, and seasonal trends. Develop a dynamic dashboard that provides real-time rental price predictions and market opportunity scoring using Power Query and sophisticated statistical regression models.