Access Millions of academic & study documents

Exp19 Excel Ch05 Ml1 Realestate

Content type
User Generated
Subject
Excel
School
Holland College
Type
Homework
Showing Page:
1/8

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/8

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/8

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 8 pages?
Access Now
Unformatted Attachment Preview
Number Address City Selling Agent Asking Price Selling Price Alpine Average American Fork Average Cedar Hills Average Eagle Mountain Average Lehi Average Grand Average $ $ $ $ $ $ Answer these questions: What is the average selling price in Alpine? Which city has the highest average % of asking price? Which city has the least number of average days on market? What is the average days on market for all cities? Which city had the lowest average selling price? 504,911 367,445 398,187 344,698 224,424 369,596 % of Asking 95.4% 96.4% 95.5% 94.2% 94.5% 95.2% $ 504,911 American Fork Cedar Hills 72 Lehi Days on Market 70 85 46 83 56 72 Column Labels Average of Average of Asking Price Selling Price Agent Alpine Cedar Hills Alpine Bethune $ 147,800 $ 150,000 Carey $ 500,000 $ 522,500 $ 465,000 Goodrich $ 908,457 $ 851,667 Hernandez $ 513,400 Lugo $ 219,000 $ 335,000 $ 215,000 Merkin $ 450,000 $ 289,900 $ 382,500 Minkus $ 362,225 $ 352,463 Pijuan $ 825,000 $ 800,000 Reuter $ 310,000 $ 215,700 $ 291,400 Grand Total $ 532,219 $ 418,458 $ 504,911 Total Average Total Average of Asking Price of Selling Price Cedar Hills $ 502,675 $ $ $ 477,312 322,000 279,000 $ $ 206,303 398,187 $ $ $ $ $ $ $ $ $ $ 147,800 518,000 908,457 513,400 296,333 369,950 362,225 825,000 247,133 479,714 $ $ $ $ $ $ $ $ $ $ 150,000 495,140 851,667 477,312 286,333 330,750 352,463 800,000 234,668 455,654 Average of Asking PriceAverage of Selling Price $1,000,000 $900,000 $800,000 $700,000 $600,000 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents