1. Understanding house prices
In this video, we'll harness the power of Excel to delve into aggregate functions. If you're following along, open your Understanding House Prices starter file located in the Workbooks folder under the Demo subfolder. We're focusing on data exclusively from September 2014, aiming to extract valuable insights through several key questions about property sales.
First, let's lay the groundwork in column K. From K2 to K5, briefly describing each value. We aim to calculate the average sale price, lowest sale price, highest sale price, and average price per square foot. Diving into our calculations, we'll start with the average sale price.
Simply type the equal sign average and then select the entire price column by clicking its header. This calculation will yield the average sales price. Moving on to discover the range of sale prices, we employ the min and max functions in cells L3 and L4, respectively, which we'll format as currency for clarity.
These functions will reveal the lowest and highest property sale prices within our dataset. To tackle the average price per square foot, we first create a column to calculate the total square footage of each property, combining living and lot spaces. Then, we create another column to calculate the price per square foot.
Finally, we'll use the average function again in cell N5 to find the average price per square foot, formatting our result with two decimal places for precision. With these insights now clearly laid out in your data set, you're equipped to further explore and understand the intricacies of house pricing.
2. Let's practice!