Search for question
Question

Continue to work with the Real Estate data set from Assignment 2. Use the Data Analysis add-in to create a table that presents the descriptive statistics for the following data: price,

bedrooms, age, acreage, real estate taxes and assessed value. Demonstrate good table design as covered in the lecture notes and readings. The table should be in a separate worksheet (tab) which is labeled. Within this worksheet, please write a brief discussion which highlights important elements and demonstrates your understanding of standard deviation. Create a correlation table for the following data: price, bedrooms, age, acreage, real estate taxes and assessed value. Please format the table professionally and save the table on a separate, labeled tab/worksheet. Within this worksheet, please discuss 3 of the correlation coefficients. Please recall that to run descriptive statistics within the Data Analysis ToolPak, the data of interest must be in one continuous block. This may require moving other columns or cutting and pasting the data you are interested in analyzing into a new worksheet.

Fig: 1