Challenge 7-4 EXCEL

profileSheial 234
Noor.Alyaqeen.Al.Ansari-EX2016-ChallengeYourself-7-4.xlsx
Home>Computer Science homework help>Challenge 7-4 EXCEL

Summary by Type

House Type
Modern $9,505,000
Condo $13,205,000
Ranch $18,515,000
Mediterranean $15,855,000

Sales by House Type

Modern Condo Ranch Mediterranean 9505000 13205000 18515000 15855000 Modern Condo Ranch Mediterranean 9505000 13205000 18515000 15855000

Sales by House Type

Modern Condo Ranch Mediterranean 9505000 13205000 18515000 15855000

Condo Sales

1 and 2 Bedroom Condo Sales

Purchase Price 42798 42798 42630 42630 42628 42567 42567 42567 42480 42480 425000 385000 225000 355000 440000 550000 550000 550000 385000 425000

Sales Data

Date of Purchase House Type Purchase Price Agent Buyers Bedrooms Bathrooms Fireplace Near Schools Rate Bank Mortgage Years
3/28/17 Ranch $425,000 By Owner Williams 3 2 No Yes 4.00% Citizens 15
3/28/17 Condo $390,000 Century 21 Hairless 4 1 Yes No 4.75% First Federal 30
3/28/17 Mediterranean $425,000 By Owner Johnson 1 1 No Yes 4.75% Citywide 30
3/28/17 Ranch $450,000 Remax Bryan 3 2 No Yes 5.00% Bank Of America 30
3/28/17 Modern $320,000 Remax Nicks 5 2 No Yes 5.50% Citizens 30
3/28/17 Ranch $225,000 Williman's Matherson 5 1 No Yes 5.50% Bank Of America 30
3/28/17 Ranch $575,000 Homes and Garden Smathers 4 1 No Yes 5.50% Bank Of America 30
3/28/17 Mediterranean $320,000 Homes and Garden Charles 5 1 Yes No 5.50% Bank Of America 30
3/28/17 Ranch $390,000 By Owner Pell 2 2 No Yes 5.75% Nations 15
3/28/17 Ranch $575,000 By Owner Negreedy 4 1 No Yes 5.75% Nations 40
3/28/17 Ranch $440,000 By Owner Chama 4 2 No Yes 5.75% Nations 15
3/28/17 Mediterranean $390,000 By Owner Nyne 2 2 Yes No 5.75% Citywide 15
3/28/17 Ranch $445,000 Century 21 King 3 1 Yes No 6.75% Citywide 15
3/28/17 Mediterranean $390,000 Remax Zimmerman 2 1 No Yes 6.75% First Federal 30
3/28/17 Modern $445,000 By Owner Bond 2 1 No Yes 6.75% Bank Of America 15
3/27/17 Condo $550,000 Century 21 Muchley 4 2 No Yes 4.75% Nations 30
3/27/17 Ranch $390,000 By Owner Lee 2 2 Yes No 4.75% Citywide 30
3/27/17 Modern $575,000 Century 21 Holland 4 2 Yes No 5.50% Nations 30
3/27/17 Modern $440,000 Century 21 Watkins 1 1 Yes No 5.50% Citywide 40
3/27/17 Modern $440,000 Remax Wilson 2 2 Yes No 5.50% Bank Of America 40
3/27/17 Modern $225,000 Remax Nettle 2 2 No Yes 5.50% First Federal 30
3/27/17 Condo $550,000 Homes and Garden Ace 3 1 Yes No 5.50% Nations 30
3/27/17 Condo $550,000 Remax Frost 4 2 Yes No 5.50% People's 30
3/27/17 Condo $390,000 Remax O'Neil 4 1 Yes No 5.50% People's 15
3/27/17 Ranch $440,000 By Owner Jones 2 1 Yes No 5.50% Nations 30
3/27/17 Ranch $320,000 Williman's Kenney 4 2 No Yes 5.50% Citywide 40
3/27/17 Mediterranean $440,000 Century 21 Charleson 5 1 No Yes 5.50% Nations 30
3/27/17 Mediterranean $355,000 Homes and Garden Young 5 1 No Yes 5.50% People's 30
3/27/17 Modern $445,000 Williman's Slocum 4 2 Yes No 5.75% Bank Of America 15
3/27/17 Mediterranean $575,000 Century 21 Smith 4 1 Yes No 5.75% Bank Of America 30
3/27/17 Ranch $440,000 By Owner Willows 1 1 No Yes 6.50% Bank Of America 40
3/27/17 Mediterranean $390,000 Homes and Garden Hesche 4 1 No Yes 6.50% Bank Of America 30
3/27/17 Modern $390,000 Century 21 Hairless 1 2 Yes No 6.75% People's 30
3/27/17 Ranch $385,000 Homes and Garden Pod 1 1 Yes No 6.75% People's 40
3/27/17 Ranch $385,000 Remax Kinnon 4 1 Yes No 6.75% Nations 15
3/27/17 Modern $355,000 Century 21 Sanchaz 5 1 Yes No 6.25% Bank Of America 15
3/27/17 Ranch $425,000 Homes and Garden Tithers 1 1 Yes No 6.25% Citywide 15
3/27/17 Mediterranean $225,000 Century 21 Victor 1 1 Yes No 6.25% Citywide 30
3/27/17 Mediterranean $385,000 Century 21 Smythe 1 2 Yes No 5.50% People's 30
3/4/17 Ranch $385,000 Williman's Bryant 3 2 Yes No 3.85% First Federal 15
3/4/17 Mediterranean $550,000 Century 21 Taylor 2 1 No Yes 4.75% Bank Of America 30
3/4/17 Modern $245,000 Remax O'Neil 3 1 Yes No 5.50% First Federal 15
3/4/17 Condo $355,000 Homes and Garden Roger 5 2 Yes No 5.50% First Federal 30
3/4/17 Ranch $550,000 By Owner Jones 2 1 No Yes 5.50% Bank Of America 30
3/4/17 Ranch $425,000 Century 21 Greenston 5 1 Yes No 5.50% Bank Of America 30
3/4/17 Ranch $385,000 Williman's Weston 2 1 Yes No 5.50% Citywide 30
3/4/17 Mediterranean $445,000 Williman's Xavier 2 1 Yes No 5.50% Citizens 40
3/4/17 Mediterranean $395,000 Williman's Young 2 2 No Yes 5.50% People's 15
3/4/17 Condo $425,000 Remax Wilson 2 2 Yes No 5.75% People's 15
3/4/17 Ranch $550,000 By Owner Castle 2 1 Yes No 5.75% Citywide 30
3/4/17 Ranch $445,000 Homes and Garden Smythe 5 2 Yes No 5.75% First Federal 30
3/4/17 Mediterranean $575,000 Remax White 1 2 Yes No 5.75% First Federal 15
3/4/17 Condo $385,000 By Owner Zimmerman 2 1 Yes No 6.75% Bank Of America 30
3/4/17 Ranch $385,000 By Owner Smith 5 2 Yes No 6.75% Bank Of America 30
3/4/17 Ranch $390,000 Homes and Garden Smithers 2 1 No Yes 6.75% Citizens 15
3/4/17 Mediterranean $395,000 Homes and Garden Harris 1 1 Yes No 6.75% Nations 30
3/4/17 Mediterranean $445,000 Remax Rodman 3 1 No Yes 6.75% Citywide 30
3/4/17 Mediterranean $575,000 Century 21 Bennett 2 2 Yes No 6.25% People's 15
1/15/17 Condo $550,000 Williman's Watkins 4 1 Yes No 4.75% Bank Of America 30
1/15/17 Condo $445,000 Homes and Garden Smith 5 2 No Yes 5.50% Bank Of America 30
1/15/17 Ranch $550,000 Williman's Timmerman 2 1 Yes No 5.50% Citywide 30
1/15/17 Ranch $225,000 Remax Able 2 1 No Yes 5.50% First Federal 30
1/15/17 Condo $425,000 Homes and Garden Cater 5 1 Yes No 5.75% Bank Of America 30
1/15/17 Ranch $385,000 By Owner Bond 2 2 No Yes 5.75% People's 40
1/15/17 Modern $225,000 By Owner Nosmiles 3 1 No Yes 6.50% People's 30
1/15/17 Condo $390,000 Williman's Sanchaz 3 1 Yes No 6.75% Nations 30
1/15/17 Ranch $390,000 Williman's Nelson 1 2 No Yes 6.75% Bank Of America 15
1/15/17 Ranch $440,000 Williman's Pippen 1 2 No Yes 6.25% Nations 30
9/17/16 Ranch $320,000 Century 21 Tinker 3 2 No Yes 4.75% Bank Of America 30
9/17/16 Condo $425,000 Remax Smith 3 2 No Yes 5.00% Nations 30
9/17/16 Modern $320,000 By Owner Scott 2 2 Yes No 5.50% Citywide 30
9/17/16 Modern $250,000 Century 21 Muchley 3 2 Yes No 5.50% Citywide 15
9/17/16 Modern $445,000 Remax Newman 2 1 No Yes 5.50% Citizens 15
9/17/16 Condo $550,000 Homes and Garden Slocum 4 2 Yes No 5.50% People's 30
9/17/16 Condo $225,000 Remax Jackson 2 2 No Yes 5.50% First Federal 30
9/17/16 Mediterranean $245,000 Williman's West 1 1 No Yes 5.50% First Federal 30
9/17/16 Mediterranean $440,000 Homes and Garden Zinker 1 1 Yes No 5.50% Nations 30
9/17/16 Modern $425,000 Williman's Melon 2 2 No Yes 5.75% Citywide 15
9/17/16 Modern $245,000 Remax Jackson 3 1 Yes No 5.75% Bank Of America 40
9/17/16 Modern $355,000 Williman's Ace 4 2 No Yes 6.50% Nations 30
9/17/16 Modern $355,000 Remax Frost 2 1 Yes No 6.50% Bank Of America 30
9/17/16 Condo $355,000 Century 21 Grande 2 2 No Yes 6.50% First Federal 30
9/17/16 Mediterranean $245,000 Williman's Bytes 3 1 Yes No 6.75% Citywide 40
9/17/16 Mediterranean $440,000 Homes and Garden Berquist 5 2 Yes No 6.75% People's 30
9/17/16 Ranch $320,000 Homes and Garden Grant 2 2 No Yes 5.50% People's 30
9/15/16 Modern $440,000 Williman's Roger 3 2 No Yes 5.25% People's 30
9/15/16 Modern $440,000 Century 21 Thatcher 3 1 Yes No 5.50% People's 40
9/15/16 Condo $245,000 By Owner Jacobs 3 1 No Yes 5.50% First Federal 30
9/15/16 Condo $390,000 Remax Newman 5 2 No Yes 5.50% People's 30
9/15/16 Ranch $550,000 Century 21 Scott 2 2 Yes No 5.50% Bank Of America 30
9/15/16 Ranch $445,000 Century 21 Cowoart 4 1 Yes No 5.50% Citizens 30
9/15/16 Ranch $425,000 Homes and Garden Smith 2 1 Yes No 5.50% Citizens 40
9/15/16 Mediterranean $390,000 Williman's Youngston 5 2 No Yes 5.50% People's 15
9/15/16 Mediterranean $390,000 Remax Reynolds 1 1 Yes No 5.50% People's 30
9/15/16 Condo $575,000 Williman's Thatcher 4 1 Yes No 5.75% Nations 30
9/15/16 Ranch $575,000 By Owner Nagato 1 1 No Yes 6.50% Citizens 30
9/15/16 Condo $440,000 By Owner Chipman 1 2 No Yes 6.75% Citywide 30
9/15/16 Ranch $225,000 Williman's Childs 4 1 No Yes 6.75% Nations 30
9/15/16 Mediterranean $320,000 Century 21 Perkins 3 1 No Yes 6.75% People's 40
7/16/16 Modern $425,000 Century 21 Grande 1 1 No Yes 4.80% Bank Of America 30
7/16/16 Condo $550,000 Century 21 Holland 2 1 Yes No 5.50% Citizens 30
7/16/16 Condo $575,000 Remax Hawkins 4 2 Yes No 5.50% Nations 30
7/16/16 Condo $425,000 Remax Na 5 1 Yes No 5.50% People's 30
7/16/16 Ranch $320,000 Williman's Zink 2 1 No Yes 5.50% People's 15
7/16/16 Mediterranean $550,000 Williman's Reynolds 1 2 No Yes 5.50% First Federal 30
7/16/16 Mediterranean $575,000 Williman's Henney 5 1 No Yes 5.50% First Federal 30
7/16/16 Ranch $320,000 Remax Collarserdo 2 1 Yes No 5.75% Bank Of America 30
7/16/16 Mediterranean $225,000 By Owner Snipes 4 2 Yes No 5.75% Bank Of America 40
7/16/16 Modern $550,000 By Owner Johnson 4 1 Yes No 5.80% Citizens 40
7/16/16 Ranch $445,000 Homes and Garden Sikes 4 2 Yes No 6.50% First Federal 15
7/16/16 Condo $395,000 By Owner Downing 4 1 Yes No 6.75% Citywide 15
7/16/16 Mediterranean $440,000 Williman's Nanowski 2 1 Yes No 6.75% Citizens 15
7/16/16 Mediterranean $245,000 Homes and Garden Smith 3 1 Yes No 6.75% Citizens 30
7/16/16 Condo $550,000 Remax Nettle 2 1 No Yes 6.25% First Federal 40
7/16/16 Ranch $425,000 Williman's Tinkleman 1 2 Yes No 6.25% Citywide 30
7/16/16 Condo $550,000 By Owner Hawkins 2 1 Yes No 6.75% People's 15
7/16/16 Ranch $355,000 Century 21 Johnson 3 1 No Yes 6.75% Citywide 30
4/20/16 Ranch $245,000 Homes and Garden Harris 3 2 Yes No 4.25% Nations 15
4/20/16 Ranch $355,000 By Owner Nagasaki 5 2 Yes No 4.75% Nations 30
4/20/16 Ranch $445,000 By Owner Lonsdale 5 2 Yes No 4.75% Nations 30
4/20/16 Mediterranean $425,000 By Owner Jackson 3 2 No Yes 5.00% First Federal 40
4/20/16 Condo $355,000 By Owner Bryant 3 1 No Yes 5.50% Citywide 15
4/20/16 Mediterranean $445,000 Williman's Thompson 5 2 No Yes 5.50% Bank Of America 30
4/20/16 Mediterranean $575,000 Homes and Garden Nelson 4 1 Yes No 5.50% People's 30
4/20/16 Mediterranean $355,000 Homes and Garden Whitman 3 2 Yes No 5.50% Nations 30
4/20/16 Mediterranean $425,000 Remax Nelson 3 2 Yes No 5.50% Citizens 30
4/20/16 Modern $575,000 Remax Smith 3 2 Yes No 5.75% People's 30
4/20/16 Condo $385,000 Homes and Garden Melon 2 1 No Yes 5.75% Nations 15
4/20/16 Ranch $355,000 Remax Bell 3 2 Yes No 5.75% Bank Of America 40
4/20/16 Mediterranean $245,000 Century 21 Millhouse 2 1 No Yes 5.75% Citywide 30
4/20/16 Mediterranean $320,000 Williman's Vu 4 2 Yes No 5.75% People's 30
4/20/16 Mediterranean $445,000 Williman's Victoria 4 1 Yes No 5.75% Nations 30
4/20/16 Ranch $575,000 Homes and Garden Bergquist 3 1 Yes No 6.50% Citizens 30
4/20/16 Modern $575,000 Century 21 Cater 4 1 Yes No 6.75% Bank Of America 15
4/20/16 Condo $425,000 Homes and Garden Perry 1 1 Yes No 6.75% Bank Of America 30
4/20/16 Mediterranean $445,000 Century 21 Taylor 5 1 Yes No 6.75% Bank Of America 30
4/20/16 Condo $385,000 Remax Nicks 4 1 No Yes 6.25% People's 40
4/20/16 Mediterranean $395,000 Century 21 Withers 2 2 Yes No 6.25% People's 40
Total $4,290,000 10 1.8 1.4 6.23% 26.5