Understanding house prices

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!

This exercise is part of the course

Introduction to Excel

BeginnerSkill Level

4.8+

Start Course for Free

In this chapter, you’ll learn how to navigate Excel and understand how best to work with tables. You will cover topics such as navigating the grid layout, importing data, manipulating data with tables, and creating basic formulas.

Exercise 1: Introduction to Excel Exercise 2: The possibilities of Excel Exercise 3: Navigating Excel Exercise 4: Loading workbooks Exercise 5: Working with data Exercise 6: Creating first formula Exercise 7: Working with tables Exercise 8: Referencing cells Exercise 9: Managing data with tables Exercise 10: Working with structured cell references Exercise 11: Filtering data Exercise 12: Formatting tables

In this chapter, you’ll learn how to work with data in a tabular layout. You will cover topics such as creating named ranges, using subtotals to summarize groups of data, and applying data validation rules. Additionally, you’ll learn how to use aggregate functions in Excel to help summarize your data.

Exercise 1: Managing and formatting data Exercise 2: Manage vs. Format Exercise 3: Managing data Exercise 4: Naming ranges Exercise 5: Sub-totals Exercise 6: Custom formats and validation Exercise 7: Aggregate and Arithmetic operations Exercise 8: Order of operations Exercise 9: Understanding house prices

Current Exercise

Exercise 10: Summarizing sales Exercise 11: Calculating sales and profit

Finally, in this chapter, we’ll finish by looking at the various functions available within Excel and learn how to start visualizing basic data. You will cover text, date and time, statistical functions, and learning to use built-in Excel features to visualize your data.

Exercise 1: Other functions in Excel Exercise 2: To the left, to the left Exercise 3: Applying formatting functions Exercise 4: Product profiles Exercise 5: Profit performance Exercise 6: Formatting with functions Exercise 7: Visualizing data in Excel Exercise 8: Do you know the meaning of data viz?Exercise 9: How to visualize data Exercise 10: Visualizing categories Exercise 11: Capturing parts of a whole Exercise 12: Capturing a trend Exercise 13: Congratulations!