Excel assignment due after 1 hour. please read the the message below
magic_1
chapter_4_excel_file.xlsxSales Data
| Address | City | List Price | Selling Price | Percent of list Price Winthrop University Lab User: Winthrop University Lab User: | Listing Date | Sale Date | Dayas on Market |
| 575 South Choctaw | Alpine | $ 750,250 | $ 700,000 | 93% | 4/12/16 | 11/1/16 | 203 |
| 8030 Steeplechase Drive | Alpine | $ 450,000 | $ 382,500 | 85% | 4/15/16 | 6/30/16 | 76 |
| 4081 Lybyer Avenue | Alpine | $ 325,000 | $ 308,750 | 95% | 4/19/16 | 7/2/16 | 74 |
| 7 Kingston Court | Alpine | $ 500,000 | $ 465,000 | 93% | 4/3/16 | 6/10/16 | 68 |
| 2006 Cutwater Court | Alpine | $ 345,000 | $ 339,999 | 99% | 4/18/16 | 6/23/16 | 66 |
| 1370 Pinellas Road | Alpine | $ 219,000 | $ 215,000 | 98% | 4/8/16 | 6/2/16 | 55 |
| 224 Rockaway Street | Alpine | $ 400,000 | $ 375,000 | 94% | 4/30/16 | 6/19/16 | 50 |
| 1414 N Sheridan Road | Alpine | $ 1,250,000 | $ 1,225,000 | 98% | 5/12/16 | 6/6/16 | 25 |
| 29 East Oak Circle | American Fork | $ 555,000 | $ 500,000 | 90% | 4/13/16 | 10/15/16 | 185 |
| 321 North Choctaw | American Fork | $ 565,000 | $ 535,000 | 95% | 4/6/16 | 9/30/16 | 177 |
| 3461 East Lindon Way | American Fork | $ 450,000 | $ 400,000 | 89% | 5/2/16 | 9/30/16 | 151 |
| 831 South Weber | American Fork | $ 425,815 | $ 400,000 | 94% | 4/28/16 | 9/15/16 | 140 |
| 714 Timp View Lane | American Fork | $ 250,000 | $ 232,000 | 93% | 4/29/16 | 9/1/16 | 125 |
| 143 North Mountain View | American Fork | $ 314,250 | $ 304,000 | 97% | 4/13/16 | 8/5/16 | 114 |
| 487 Blue Skies Drive | American Fork | $ 365,750 | $ 355,000 | 97% | 5/13/16 | 8/15/16 | 94 |
| 321 West Walnut Grove | American Fork | $ 425,000 | $ 415,000 | 98% | 4/18/16 | 6/30/16 | 73 |
| 11 West Oak Circle | American Fork | $ 350,000 | $ 340,000 | 97% | 4/1/16 | 5/15/16 | 44 |
| 876 South California Way | American Fork | $ 316,000 | $ 316,000 | 100% | 5/31/16 | 6/30/16 | 30 |
| 750 South Apple Way | American Fork | $ 385,900 | $ 385,900 | 100% | 4/1/16 | 4/30/16 | 29 |
| 1629 NW 43rd Street | Cedar Hills | $ 475,000 | $ 450,000 | 95% | 5/31/16 | 8/19/16 | 80 |
| 8687 Kenwood Road | Cedar Hills | $ 725,000 | $ 645,250 | 89% | 4/1/16 | 6/16/16 | 76 |
| 16235 Orange Boulevard | Cedar Hills | $ 395,000 | $ 380,000 | 96% | 5/5/16 | 7/16/16 | 72 |
| 11971 SW 269 Terrace | Cedar Hills | $ 410,000 | $ 397,700 | 97% | 5/1/16 | 6/26/16 | 56 |
| 1857 Pine Drive | Cedar Hills | $ 560,700 | $ 550,000 | 98% | 5/1/16 | 5/30/16 | 29 |
| 10700 Lake Shore Lane | Cedar Hills | $ 650,000 | $ 598,000 | 92% | 5/15/16 | 6/9/16 | 25 |
| 421 Ivy Lane | Eagle Mountain | $ 500,000 | $ 425,000 | 85% | 5/5/16 | 11/15/16 | 194 |
| 765 East Sheridan Lane | Eagle Mountain | $ 460,750 | $ 435,500 | 95% | 5/5/16 | 11/1/16 | 180 |
| 260 East Jefferson Way | Eagle Mountain | $ 450,000 | $ 400,000 | 89% | 4/30/16 | 10/1/16 | 154 |
| 614 Lincoln Drive | Eagle Mountain | $ 475,000 | $ 425,250 | 90% | 5/5/16 | 9/23/16 | 141 |
| 245 Ivy Lane | Eagle Mountain | $ 395,000 | $ 375,000 | 95% | 5/1/16 | 7/16/16 | 76 |
| 3400 North Sunset Lane | Eagle Mountain | $ 400,000 | $ 375,000 | 94% | 5/31/16 | 7/15/16 | 45 |
| 8432 South Sunset Avenue | Eagle Mountain | $ 285,750 | $ 300,000 | 105% | 4/28/16 | 6/3/16 | 36 |
| 77 East Oak Street | Eagle Mountain | $ 345,000 | $ 335,000 | 97% | 5/23/16 | 6/23/16 | 31 |
| 9000 South Sunset Avenue | Eagle Mountain | $ 325,000 | $ 320,000 | 98% | 4/28/16 | 5/28/16 | 30 |
| 73 East Oak Street | Eagle Mountain | $ 325,000 | $ 325,000 | 100% | 5/18/16 | 5/31/16 | 13 |
| 9876 South Sunset Avenue | Eagle Mountain | $ 300,000 | $ 300,000 | 100% | 4/18/16 | 4/30/16 | 12 |
| 123 Ivy Lane | Eagle Mountain | $ 375,500 | $ 375,500 | 100% | 5/1/16 | 5/5/16 | 4 |
| 1971 Glenview Road | Lehi | $ 165,000 | $ 156,750 | 95% | 4/12/16 | 6/12/16 | 61 |
| 614 West Cedar Drive | Lehi | $ 215,800 | $ 200,000 | 93% | 4/1/16 | 5/25/16 | 54 |
| 3412 Kilmer Street | Lehi | $ 180,000 | $ 175,000 | 97% | 5/23/16 | 7/15/16 | 53 |
| 8307 S Indian River Drive | Lehi | $ 250,000 | $ 255,000 | 102% | 5/1/16 | 6/18/16 | 48 |
| 1900 Glenview Road | Lehi | $ 325,000 | $ 302,250 | 93% | 4/28/16 | 6/1/16 | 34 |
| Averages | 95% | 3283 |
Filtered Data
| City | List Price | Selling Price | Percent of List Price | Days on Market |
| Cedar Hills | $ 725,000 | $ 645,250 | 89.0% | 76 |
| American Fork | $ 350,000 | $ 340,000 | 97.1% | 44 |
| American Fork | $ 418,000 | $ 400,000 | 95.7% | 61 |
| Lehi | $ 215,800 | $ 200,000 | 92.7% | 54 |
| American Fork | $ 385,900 | $ 385,900 | 100.0% | 29 |
| Alpine | $ 500,000 | $ 465,000 | 93.0% | 68 |
| Lehi | $ 300,000 | $ 290,000 | 96.7% | 59 |
| American Fork | $ 565,000 | $ 535,000 | 94.7% | 177 |
| Alpine | $ 219,000 | $ 215,000 | 98.2% | 55 |
| Lehi | $ 165,000 | $ 156,750 | 95.0% | 61 |
| American Fork | $ 325,000 | $ 320,000 | 98.5% | 48 |
| Alpine | $ 750,250 | $ 700,000 | 93.3% | 203 |
| Lehi | $ 110,000 | $ 106,000 | 96.4% | 82 |
| American Fork | $ 314,250 | $ 304,000 | 96.7% | 114 |
| American Fork | $ 555,000 | $ 500,000 | 90.1% | 185 |
| Alpine | $ 450,000 | $ 382,500 | 85.0% | 76 |
| Alpine | $ 345,000 | $ 339,999 | 98.6% | 66 |
| Eagle Mountain | $ 300,000 | $ 300,000 | 100.0% | 12 |
| American Fork | $ 425,000 | $ 415,000 | 97.6% | 73 |
| Alpine | $ 325,000 | $ 308,750 | 95.0% | 74 |
| Lehi | $ 325,000 | $ 302,250 | 93.0% | 34 |
| Eagle Mountain | $ 325,000 | $ 320,000 | 98.5% | 30 |
| Eagle Mountain | $ 285,750 | $ 300,000 | 105.0% | 36 |
| American Fork | $ 425,815 | $ 400,000 | 93.9% | 140 |
| American Fork | $ 250,000 | $ 232,000 | 92.8% | 125 |
| Eagle Mountain | $ 515,000 | $ 485,750 | 94.3% | 118 |
| Alpine | $ 400,000 | $ 375,000 | 93.8% | 50 |
| Eagle Mountain | $ 450,000 | $ 400,000 | 88.9% | 154 |
| Eagle Mountain | $ 310,000 | $ 300,000 | 96.8% | 62 |
| Lehi | $ 250,000 | $ 255,000 | 102.0% | 48 |
| Eagle Mountain | $ 375,500 | $ 375,500 | 100.0% | 4 |
| Cedar Hills | $ 185,500 | $ 179,000 | 96.5% | 36 |
| Eagle Mountain | $ 395,000 | $ 375,000 | 94.9% | 76 |
| Cedar Hills | $ 410,000 | $ 397,700 | 97.0% | 56 |
| Cedar Hills | $ 560,700 | $ 550,000 | 98.1% | 29 |
| American Fork | $ 450,000 | $ 400,000 | 88.9% | 151 |
| Cedar Hills | $ 395,000 | $ 380,000 | 96.2% | 72 |
| Eagle Mountain | $ 475,000 | $ 425,250 | 89.5% | 141 |
| Lehi | $ 450,000 | $ 382,500 | 85.0% | 42 |
| Alpine | $ 1,500,120 | $ 1,400,000 | 93.3% | 148 |
| Eagle Mountain | $ 500,000 | $ 425,000 | 85.0% | 194 |
| Eagle Mountain | $ 460,750 | $ 435,500 | 94.5% | 180 |
| American Fork | $ 375,000 | $ 376,000 | 100.3% | 9 |
| Alpine | $ 1,250,000 | $ 1,225,000 | 98.0% | 25 |
| American Fork | $ 365,750 | $ 355,000 | 97.1% | 94 |
| Cedar Hills | $ 650,000 | $ 598,000 | 92.0% | 25 |
| Eagle Mountain | $ 325,000 | $ 325,000 | 100.0% | 13 |
| Alpine | $ 147,800 | $ 150,000 | 101.5% | 25 |
| Lehi | $ 180,000 | $ 175,000 | 97.2% | 53 |
| Alpine | $ 310,000 | $ 291,400 | 94.0% | 38 |
| Eagle Mountain | $ 345,000 | $ 335,000 | 97.1% | 31 |
| Eagle Mountain | $ 375,000 | $ 330,000 | 88.0% | 96 |
| Lehi | $ 215,000 | $ 195,000 | 90.7% | 21 |
| Eagle Mountain | $ 450,000 | $ 400,000 | 88.9% | 79 |
| American Fork | $ 315,250 | $ 300,000 | 95.2% | 65 |
| Cedar Hills | $ 475,000 | $ 450,000 | 94.7% | 80 |
| Eagle Mountain | $ 400,000 | $ 375,000 | 93.8% | 45 |
| American Fork | $ 316,000 | $ 316,000 | 100.0% | 30 |
| Cedar Hills | $ 289,900 | $ 279,000 | 96.2% | 1 |
| American Fork | $ 345,000 | $ 330,000 | 95.7% | 75 |
| Lehi | $ 259,900 | $ 246,905 | 95.0% | 92 |
| Eagle Mountain | $ 399,000 | $ 350,000 | 87.7% | 181 |
| Eagle Mountain | $ 410,000 | $ 350,750 | 85.5% | 134 |
| Eagle Mountain | $ 285,750 | $ 300,000 | 105.0% | 26 |
| Alpine | $ 189,900 | $ 186,102 | 98.0% | 50 |
| American Fork | $ 335,000 | $ 330,000 | 98.5% | 97 |
| Eagle Mountain | $ 250,000 | $ 275,000 | 110.0% | 13 |
| Cedar Hills | $ 275,000 | $ 264,000 | 96.0% | 38 |
| Alpine | $ 589,000 | $ 575,000 | 97.6% | 20 |
| American Fork | $ 345,670 | $ 345,000 | 99.8% | 102 |
