Data Analysis

Data file is a Excel File
1. Data Visualization
a. Correlation Matrix
b. Explore correlation between Architecture type – Block
c. Explode correlation between Architecture type – Built Year
2. Sampling for Architecture Type
a. Unform Sampling
b. Stratified Sampling
1. Stratify by Block
2. Stratify by Built Year

3. Compare results from Different sampling and validate the best sampling type
a. Calculate and Compare Metrics
1. For each sample type (uniform, stratified by block, stratified by built year), calculate relevant metrics such as mean, median, and standard deviation for critical columns
b. Visualize the Comparison
Need different graphics

c. Analyze and Determine the Best Sampling Type
Over all I need to see all calculations for every step.