Excel CH 9 Challenge

profileScampuss
EX2019-ChallengeYourself-9-3.xlsx

Summary

Sales Summary 2019-2020
Number of Sales Average Selling Price
One BR, One BA
One BR, Two BA +
Two BR, One BA
Two BR, Two BA
Two BR, Two BA +
Three BR, One BA
Three BR, Two BA
Three BR, Three BA +
Four BR, One BA
Four BR, Two BA
Four BR, Three BA+
Five BR+, One BA
Five BR+, Two BA+

Condo

Number of Sales Average Selling Price
1 BR, 1 BA 14 $ 332,067
1 BR, 2 BA + 19 $ 306,861
2 BR, 1 BA 0 $ 383,199
2 BR, 2 BA 2 $ 316,284
2 BR, 2 BA + 11 $ 165,769
3 BR, 1 BA 1 $ 181,726
3 BR, 2 BA 7 $ 211,902
3 BR, 3 BA + 6 $ 254,679
4 BR, 1 BA 16 $ 354,925
4 BR, 2 BA 13 $ 303,992
4 BR, 3 BA+ 9 $ 390,899
5 BR+, 1 BA 13 $ 274,979
5 BR+, 2 BA+ 4 $ 238,278

Townhouse

Number of Sales Average Selling Price
1 BR, 1 BA 5 $ 430,872
1 BR, 2 BA + 10 $ 482,954
2 BR, 1 BA 2 $ 479,896
2 BR, 2 BA 2 $ 304,878
2 BR, 2 BA + 3 $ 287,546
3 BR, 1 BA 17 $ 509,124
3 BR, 2 BA 6 $ 405,788
3 BR, 3 BA + 2 $ 317,397
4 BR, 1 BA 16 $ 340,085
4 BR, 2 BA 13 $ 401,437
4 BR, 3 BA+ 17 $ 372,143
5 BR+, 1 BA 19 $ 560,943
5 BR+, 2 BA+ 13 $ 556,431

Single Family

Number of Sales Average Selling Price
1 BR, 1 BA 14 $ 368,210
1 BR, 2 BA + 10 $ 525,477
2 BR, 1 BA 12 $ 282,077
2 BR, 2 BA 9 $ 519,800
2 BR, 2 BA + 16 $ 554,020
3 BR, 1 BA 8 $ 342,218
3 BR, 2 BA 8 $ 345,351
3 BR, 3 BA + 13 $ 286,947
4 BR, 1 BA 15 $ 466,560
4 BR, 2 BA 13 $ 263,587
4 BR, 3 BA+ 4 $ 399,456
5 BR+, 1 BA 10 $ 271,373
5 BR+, 2 BA+ 19 $ 548,163

Select Sales

Property Types

Property Types
Condo
Townhouse
Single Family
Multi-Unit