Assignment:
The project is to "use the data file provided to prepare a statistical analysis of single-family home values currently in three zip codes in West County St. Louis.
You are asked to "prepare a workbook that summarizes and charts data you feel is relevant to understanding the characteristics of single family residential homes in this area overall and differences between zip codes".
That is intentionally an open ended assignment similar to what you might receive in industry Use your descriptive statistics chapters for ideas and label your worksheets D1, D2, . . . etc and use text boxes to describe the contents and conclusions for each sheet.
Your sheets should summarize a single characteristics and use any descriptive statistics you feel useful to presenting the data including summary measures, pivot table reports and charts.
A minimum of three characteristics (three sheets) is required and you can have multiple items on each sheet summarizing that characteristic. Select the most important characteristics you feel like list price and other characteristics that might impact the value of the home and make sure at least one of the characteristics is a categorical (qualitative) data item.
Format the sheets and contents appropriately and consistently to communicate your summary to your audience.
You are summarizing, so avoid too much information.
The data has not been "cleansed" so it may be necessary to remove observations (rows) that seem inappropriate for your summary.
Document any data elements item you removed and why by cutting and pasting them below the original data table and adding a comment after the item summarizing your justification for removing the data.
Attachment:- Statistical analysis of single-family.rar