About The Dataset
The Office of Policy and Management maintains a listing of all real estate sales with a sales price of $2,000 or greater that occur between October 1 and September 30 of each year. For each sale record, the file includes: town, property address, date of sale, property type (residential, apartment, commercial, industrial or vacant land), sales price, and property assessment.
Data are collected in accordance with Connecticut General Statutes, section 10-261a and 10-261b: https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261a and https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261b. Annual real estate sales are reported by grand list year (October 1 through September 30 each year). For instance, sales from 2018 GL are from 10/01/2018 through 9/30/2019.
Data are collected in accordance with Connecticut General Statutes, section 10-261a and 10-261b: https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261a and https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261b. Annual real estate sales are reported by grand list year (October 1 through September 30 each year). For instance, sales from 2018 GL are from 10/01/2018 through 9/30/2019.
Tasks
1.) The first 20 years of the 21st century saw real estate prices skyrocket. Use a pivot table to compare the average assessed value with the average sale amount for each year from 2001 to 2020.
2.) Which year (between 2001 and 2020) saw the most real estate transactions?
3.) Explain two ways that you can find the highest sale amount on the spreadsheet. Show me that sale.
4.) What city had the highest volume of real estate sales? Answer this question for each year between 2001 and 2020.
5.) What city had the highest average value of real estate sales? Answer this question for each year between 2001 and 2020.
2.) Which year (between 2001 and 2020) saw the most real estate transactions?
3.) Explain two ways that you can find the highest sale amount on the spreadsheet. Show me that sale.
4.) What city had the highest volume of real estate sales? Answer this question for each year between 2001 and 2020.
5.) What city had the highest average value of real estate sales? Answer this question for each year between 2001 and 2020.