Exploratory Data Analysis (Python, Pandas, Seaborn):

• Optimal States for Expansion: Identified B8, B10, A3 as top states (high sales/SGM percentiles, >80% store sustainability, and statistically significant store counts). Rejected outliers with low sample sizes or inconsistent performance.

• Best Opening Months: Recommended December, August, March, November based on peak sales/SGM and historical store opening trends.

• Outlet-Type Risk: Flagged "Strip" outlets (58% closure rate despite 37.7% sales contribution). Advised prioritizing mall/outlet formats due to declining closure trends post-2016.

• KPIs: Validated recommendations via percentile analysis, active store metrics, and comparative sales graphs against state averages.

Report

Objective

This analysis identifies the top three optimal states for ABC's retail expansion by evaluating sales performance and market sustainability, determines the most favorable months for store openings based on seasonal sales trends, and examines how different outlet formats impact long-term store viability through closure rate patterns