Analyzing the Changes in California Housing Prices from 1990s to 2022 (10 points)
Data File: MedianPricesofExistingDetachedHomesHistoricalData.xlsDownload Data File: https://peralta.instructure.com/courses/58148/files/6578640?wrap=1
MedianPricesofExistingDetachedHomesHistoricalData.xls https://peralta.instructure.com/courses/58148/files/6578640/download?download_frd=1
Assignment Instructions
Refer to the embedded MS Excel data file sourced from the California Association of Realtors, which shows the median selling price detached single family
homes for each county in the State of California from 1990 to 2022.
Answer the following questions by analyzing the data presented.
Question #1
1a) Which county has the highest median selling price as of February 2022? (1 point)
1b) And the lowest? (1 point)
Question #2
2a) What was the median price of a detached single family home in Alameda County in 1992? (1 point)
2b) And how much is it now (as of February 2022)? (1 point)
2c) How much has the median home price increased during that time, in absolute dollars and percentage-wise (2 points)
Question # 3
3a) Do you find any time periods where most counties in the State experienced an extended period of decreases in the median selling price for detached
single family homes? (2 points)
3b) If so, when were these time periods, and can you correlate these time periods with any other events or causes? (2 points)
What to Upload:
file with your responses to the seven questions 1 a,b; 2 a,b,c, and 3 a,b as outlined above. Please be sure to include your name, class #, and date on your
response.
