Search for question
Question

Assignment Instructions: Start exploring the Real Estate data set and create two pivot tables. Please demonstrate your ability to group a continuous variable in at least one of the pivot tables. The variables you select and the data summarization (sum, average or count?) is your discretion. Please explain the decisions you made and how this data table helps you understand the Real Estate data set. Your discussion should be in Excel and on the appropriate worksheet (tab). From at least one of the pivot tables, create a graph that shows the data simply and compellingly. Demonstrate good graph design as covered in the lecture notes and readings. The graph should be displayed on the same worksheet (tab) as the pivot table. Briefly discuss the graphing decisions you made. The 2 pivot tables should be in labelled in separate worksheets (tabs) in the Real Estate data file. Please format the output professionally. You should post one Excel file. CAN EXPLORE ANY DATASET, RELATED TO REAL ESTATE.