AutoSave Off Hb el big data sky assignment 1.xlsx File Home Insert Page Layout Formulas Data Review View Developer Help Power X Cut Arial ~10 ~A AP === ab Wrap Text General LECopy Paste arA- - Merge & Center $ - % Format Painter Clipboard Font Alignment Numb D84 alpine Carey A B C D E 44 43 61 East Walnut Grove American Fork Goodrich S 375,000 $ 45 44 1414 N Sheridan Road Alpine Pijuan s 1,250,000 $ 46 45 487 Blue Skies Drive American Fork Goodrich $ 365,750 $ 47 46 10700 Lake Shore Lane Cedar Hills Carey s 650,000 $ 48 47 73 East Oak Street Eagle Mountain Merkin s 325,000 s 49 48 81 Island Drive South Alpine Bethune S 147,800 $ 50 49 3412 Kilmer Street Lehi $ 180,000 $ $ 51 50 605 Reservoir Drive Alpine Reuter $ 310,000 $ 52 51 77 East Oak Street Eagle Mountain Bethune $ s 345,000 $ 53 52 400 lvy Lane Eagle Mountain Bethune $ 375,000 $ 54 53 1 Southampton Place Lehi Goodrich s $ 215,000 $ 55 54 3418 North Sunset Lane Eagle Mountain Bethune $ 450,000 $ 56 55 1892 North 250 West American Fork Carey S 315,250 $ 57 56 1629 NW 43rd Street Cedar Hills Carey $ 475,000 $ 58 57 3400 North Sunset Lane Eagle Mountain Merkin S 400,000 $ 59 58 876 South California Way American Fork Hen S 316,000 $ 60 59 21 Compass Road Cedar Hills Merkin S 289,900 $ 61 60 34 West Oakley Drive American Fork Carey $ 345,000 $ 62 61 30 Kent Road Lehi Bethune s 259,900 $ 63 62 140 East 3rd Street Eagle Mountain Hen S 399,000 $ 64 63 160 West 5th Street Eagle Mountain Carey s 410,000 $ 65 64 240 West 5th Street Eagle Mountain Reuter $ 285,750 $ 66 65 520 E Spring Street Alpine Minkus $ 189,900 $ 67 66 678 Mountain Circle American Fork Goodrich $ 335,000 $ 68 67 3490 North Sunset Lane Eagle Mountain Minkus $ 250,000 $ 69 68 4916 Rock Spring Road Cedar Hills Lugo S 275,000 $ 70 69 8923 Harris Drive Alpine Minkus S 589,000 $ S 71 70 876 West Hadley Way American Fork Hernandez S 345,670 $ 72 71 1132 SW 52nd Street Cedar Hills Hernandez S 254,500 $ 73 72 416 East Oak Eagle Mountain Merkin S 300,000 $ 74 73 10 Vestal Drive Cedar Hills Carey s 555,000 $ 75 74 425 East Oak Eagle Mountain Bethune S 275,900 $ 76 75 876 West Holiday Alpine Goodrich $ 475,000 $ 77 76 103 Jasper Drive Lehi Bethune $ 165,900 $ 78 77 516 East Oak Eagle Mountain Pijuan $ 299,999 $ 79 78 123 Oak Avenue American Fork Carey S 400,000 $ 80 79 600 Ivy Lane Eagle Mountain Pijuan $ s 339,999 $ 81 80 144 Oak Avenue American Fork Goodrich $ 380,500 $ 82 81 1600 Reeves Street Cedar Hills Reuter $ 245,900 $ 83 90 91 92 93 94 95 96 97 98 99 100 Based on your analysis, answer the following questions related to the home sales. 101 What is the average selling price in Alpine? $504,911 102 Which city has the highest average % of asking price? 103 Which city has the least number of average days on market? Cedar Hills 46 104 What is the average days on market for all cities? 334 Sales Subtotals Sales Data + Ready Accessibility: Investigate : F 376,000 1,225,000 355,000 598,000 325,000 150,000 175,000 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 316,000 279,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 236,685 250,000 565,000 250,000 455,000 159,264 280,000 400,000 310,000 365,000 233,605 G 5/6/2016 5/12/2016 5/13/2016 5/15/2016 5/18/2016 5/22/2016 5/23/2016 5/22/2016 5/23/2016 5/26/2016 5/28/2016 5/28/2016 5/28/2016 5/31/2016 5/31/2016 5/31/2016 5/31/2016 6/1/2016 6/2/2016 6/2/2016 6/3/2016 6/5/2016 6/6/2016 6/10/2016 6/12/2016 6/13/2016 6/18/2016 6/20/2016 6/23/2016 6/23/2016 6/24/2016 6/24/2016 6/24/2016 6/29/2016 6/29/2016 6/30/2016 6/30/2016 6/30/2016 6/30/2016 H 5/15/2016 6/6/2016 8/15/2016 6/9/2016 5/31/2016 6/16/2016 7/15/2016 6/29/2016 6/23/2016 8/30/2016 6/18/2016 8/15/2016 8/1/2016 8/19/2016 7/15/2016 6/30/2016 6/1/2016 8/15/2016 9/2/2016 11/30/2016 10/15/2016 7/1/2016 7/26/2016 9/15/2016 6/25/2016 7/21/2016 7/8/2016 9/30/2016 9/21/2016 11/2/2016 6/30/2016 8/15/2016 9/18/2016 9/6/2016 9/30/2016 7/15/2016 10/1/2016 9/1/2016 8/16/2016 93 94 95 96 97 98 99 100 Based on your analysis, answer the following questions related to the home sales. 101 What is the average selling price in Alpine? $504,911 102 Which city has the highest average % of asking price? 103 Which city has the least number of average days on market? Cedar Hills 46 104 What is the average days on market for all cities? 334 105 Which city had the lowest average selling price? Lehi 106 107 108 109 110 AutoSave Off Hb el big data sky assignment 1.xlsx File Home Insert Page Layout Formulas Data Review View Developer Help Power X Cut Arial ~10 ~A AP === ab Wrap Text General LECopy Paste arA- - Merge & Center $ - % Format Painter Clipboard Font Alignment Numb D84 alpine Carey A B C D E 44 43 61 East Walnut Grove American Fork Goodrich S 375,000 $ 45 44 1414 N Sheridan Road Alpine Pijuan s 1,250,000 $ 46 45 487 Blue Skies Drive American Fork Goodrich $ 365,750 $ 47 46 10700 Lake Shore Lane Cedar Hills Carey s 650,000 $ 48 47 73 East Oak Street Eagle Mountain Merkin s 325,000 s 49 48 81 Island Drive South Alpine Bethune S 147,800 $ 50 49 3412 Kilmer Street Lehi $ 180,000 $ $ 51 50 605 Reservoir Drive Alpine Reuter $ 310,000 $ 52 51 77 East Oak Street Eagle Mountain Bethune $ s 345,000 $ 53 52 400 lvy Lane Eagle Mountain Bethune $ 375,000 $ 54 53 1 Southampton Place Lehi Goodrich s $ 215,000 $ 55 54 3418 North Sunset Lane Eagle Mountain Bethune $ 450,000 $ 56 55 1892 North 250 West American Fork Carey S 315,250 $ 57 56 1629 NW 43rd Street Cedar Hills Carey $ 475,000 $ 58 57 3400 North Sunset Lane Eagle Mountain Merkin S 400,000 $ 59 58 876 South California Way American Fork Hen S 316,000 $ 60 59 21 Compass Road Cedar Hills Merkin S 289,900 $ 61 60 34 West Oakley Drive American Fork Carey $ 345,000 $ 62 61 30 Kent Road Lehi Bethune s 259,900 $ 63 62 140 East 3rd Street Eagle Mountain Hen S 399,000 $ 64 63 160 West 5th Street Eagle Mountain Carey s 410,000 $ 65 64 240 West 5th Street Eagle Mountain Reuter $ 285,750 $ 66 65 520 E Spring Street Alpine Minkus $ 189,900 $ 67 66 678 Mountain Circle American Fork Goodrich $ 335,000 $ 68 67 3490 North Sunset Lane Eagle Mountain Minkus $ 250,000 $ 69 68 4916 Rock Spring Road Cedar Hills Lugo S 275,000 $ 70 69 8923 Harris Drive Alpine Minkus S 589,000 $ S 71 70 876 West Hadley Way American Fork Hernandez S 345,670 $ 72 71 1132 SW 52nd Street Cedar Hills Hernandez S 254,500 $ 73 72 416 East Oak Eagle Mountain Merkin S 300,000 $ 74 73 10 Vestal Drive Cedar Hills Carey s 555,000 $ 75 74 425 East Oak Eagle Mountain Bethune S 275,900 $ 76 75 876 West Holiday Alpine Goodrich $ 475,000 $ 77 76 103 Jasper Drive Lehi Bethune $ 165,900 $ 78 77 516 East Oak Eagle Mountain Pijuan $ 299,999 $ 79 78 123 Oak Avenue American Fork Carey S 400,000 $ 80 79 600 Ivy Lane Eagle Mountain Pijuan $ s 339,999 $ 81 80 144 Oak Avenue American Fork Goodrich $ 380,500 $ 82 81 1600 Reeves Street Cedar Hills Reuter $ 245,900 $ 83 90 91 92 93 94 95 96 97 98 99 100 Based on your analysis, answer the following questions related to the home sales. 101 What is the average selling price in Alpine? $504,911 102 Which city has the highest average % of asking price? 103 Which city has the least number of average days on market? Cedar Hills 46 104 What is the average days on market for all cities? 334 Sales Subtotals Sales Data + Ready Accessibility: Investigate : F 376,000 1,225,000 355,000 598,000 325,000 150,000 175,000 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 316,000 279,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 236,685 250,000 565,000 250,000 455,000 159,264 280,000 400,000 310,000 365,000 233,605 G 5/6/2016 5/12/2016 5/13/2016 5/15/2016 5/18/2016 5/22/2016 5/23/2016 5/22/2016 5/23/2016 5/26/2016 5/28/2016 5/28/2016 5/28/2016 5/31/2016 5/31/2016 5/31/2016 5/31/2016 6/1/2016 6/2/2016 6/2/2016 6/3/2016 6/5/2016 6/6/2016 6/10/2016 6/12/2016 6/13/2016 6/18/2016 6/20/2016 6/23/2016 6/23/2016 6/24/2016 6/24/2016 6/24/2016 6/29/2016 6/29/2016 6/30/2016 6/30/2016 6/30/2016 6/30/2016 H 5/15/2016 6/6/2016 8/15/2016 6/9/2016 5/31/2016 6/16/2016 7/15/2016 6/29/2016 6/23/2016 8/30/2016 6/18/2016 8/15/2016 8/1/2016 8/19/2016 7/15/2016 6/30/2016 6/1/2016 8/15/2016 9/2/2016 11/30/2016 10/15/2016 7/1/2016 7/26/2016 9/15/2016 6/25/2016 7/21/2016 7/8/2016 9/30/2016 9/21/2016 11/2/2016 6/30/2016 8/15/2016 9/18/2016 9/6/2016 9/30/2016 7/15/2016 10/1/2016 9/1/2016 8/16/2016 93 94 95 96 97 98 99 100 Based on your analysis, answer the following questions related to the home sales. 101 What is the average selling price in Alpine? $504,911 102 Which city has the highest average % of asking price? 103 Which city has the least number of average days on market? Cedar Hills 46 104 What is the average days on market for all cities? 334 105 Which city had the lowest average selling price? Lehi 106 107 108 109 110