Take a sample of 100 homes for sale in your home town.?(please use zip cose 18964 for this portion ) Information about homes can be found on websites such as Realtor, Zillow, and Trulia.? For each

Take a sample of 100 homes for sale in your home town. (please use zip cose 18964 for this portion ) Information about homes can be found on websites such as Realtor, Zillow, and Trulia.  For each home, record the address, zip code, current price, number of bedrooms, number of bathrooms, square footage, and the company of the listing agent.  The use of EXCEL or other data software may be beneficial.  You will be creating a 2-3 page report describing the housing market in your home town.

1. Write an introduction that includes the context of the data that has been collected. The introduction should include an identification of who, what, where, how, and why.
2. Create frequency tables to organize the responses of EACH variable. For quantitative variables, it may be appropriate to bin data into groups; for example, you may wish to group home prices into bins of width 25k or 50k.  The variables are highlighted in green above.
3. Accompany each frequency table with an appropriate display/chart. Write a sentence that describes the distribution represented in each display. The description should include the context of the report.
4. Create a contingency table that compares the variables “zip code” and “company”. Accompany your contingency table with an appropriate display. Describe the marginal distribution of “zip code”.
5. Group your data by zip code and create a boxplot and 5-number summary describing the current home prices in each area. Note any outliers that may be present using the “fence” method.
6. Write a sentence describing the distribution of home prices using the 68%-95%-99.7% rule. Then comment on whether or not this rule is appropriate in estimating the distribution of home prices.
7. Write a conclusion summarizing the report.