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,000 courses taught by industry experts.
Creating the linear regression model and model summary: Part 3 - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Creating the linear regression model and model summary: Part 3
- [Narrator] Okay, now let's take a look at some diagnostic statistics. Starting with omnibus, which is a test for balance. This test checks if your prediction errors behave like a well-balanced seesaw. A smaller omnibus value is better. An omnibus value of 30.699 indicates our seesaw is a bit wobbly, like having a few bumps on a smooth road, but it's generally okay for most cases. The Durbin Watson. Durbin Watson acts like a detective, checking if there's a hidden pattern in your data. A score of 1.923 tells you there's no noticeable pattern in your data, which is good news. Like a detective saying, "I couldn't find any clues of foul play." Now, the probability omnibus, this is the probability linked to our omnibus test. A super tiny value like zero suggests that your data doesn't follow a perfect pattern, but that's perfectly normal for real world data. It's like saying your cake didn't turn out perfectly round,…
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)
Creating the linear regression model and model summary: Part 19m 33s
-
(Locked)
Creating the linear regression model and model summary: Part 27m 16s
-
(Locked)
Creating the linear regression model and model summary: Part 35m 33s
-
(Locked)
Dropping insignificant variables and re-creating the model7m 57s
-
(Locked)
Checking assumptions for linear regression3m 18s
-
(Locked)
Assumption 1: Checking for mean residuals2m 47s
-
(Locked)
Assumption 2: Checking homoscedasticity3m 13s
-
(Locked)
Assumption 3: Checking linearity2m 12s
-
(Locked)
Assumption 4: Checking normality of error terms3m 24s
-
(Locked)
Q-Q plot for checking the normality of error terms3m 14s
-
(Locked)
Model performance comparison on train and test data6m 7s
-
(Locked)
Applying cross-validation and evaluation4m 40s
-
(Locked)
Challenge: Model building48s
-
(Locked)
Solution: Model building1m 16s
-
(Locked)
-
-
-