assignment instructions start exploring the real estate data set and c
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.