Descriptive Statistics – Real Estate Data Part 1
Search the Internet for a realty site.
Please answer and complete the following and use references:
Selected hometown for this assignment: OCEANSIDE, CALIFORNIA (ZIP CODES: 92056 OR 92054)
**When all of the listings populate, make sure that the sort criteria reads "New Listings." This ensures that you are searching a random cross-section of listings rather than favoring one price range.
Review the new listings that populate.
Create an Excel® spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses.
Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms.
Prepare a frequency distribution for listing prices, including relative frequencies.
Create your frequency distribution as identified in Chapters 2, 3, and 4.
Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2.
Summarize your findings from your frequency distribution and your histogram.
Create either a pie chart or a bar graph of the number of bedrooms in your 100 homes.
TextBook used in my class:
Lind, D., Marchal, W., & Wathen, S.A. (2015). Statistical techniques in business & economics(16th ed.). McGraw-Hill. 9780078020520
10 years ago
15
Purchase the answer to view it

- book1.xlsx
- rosely.docx
Purchase the answer to view it

- answer.zip