From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Unlock the full course today
Join today to access over 24,200 courses taught by industry experts.
Visualizing relationships: Age of homes and distance to work - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Visualizing relationships: Age of homes and distance to work
- [Instructor] You see, scatter plots are like special lenses that help us see hidden patterns in our data. But before we dive in, let's talk about why you're using them. Scatter plots are excellent for showing how two variables are related to each other. They're like detectives trying to solve a mystery. In your case, you want to investigate the connection between two specific variables: age of homes and distance to work. So why these two? Well, when variables have a strong correlation, it's like they're whispering secrets to each other. In this case, you're interested in variables that have a significant correlation that is greater than or equal to .7 or less than or equal to negative .7. Now, if you flip back to your heat map from the last step, you can see that these two variables meet that criteria, so they're perfect candidates for a scatter plot investigation. When the following Python code is run, it generates…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Bivariate analysis: Heat-map5m 23s
-
(Locked)
Visualizing relationships: Age of homes and distance to work3m 52s
-
(Locked)
Visualizing relationships: Highway access and property tax4m 9s
-
(Locked)
Checking correlation after removing outliers3m 40s
-
(Locked)
Visualizing relationships: Other pairs of variables5m 8s
-
(Locked)
Challenge: Visualization1m 9s
-
(Locked)
Solution: Visualization56s
-
(Locked)
-
-
-
-
-