From the course: Complete Guide to AI and Data Science for SQL Developers: From Beginner to Advanced
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Applying cross-validation and evaluation - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL Developers: From Beginner to Advanced
Applying cross-validation and evaluation
- Welcome to the 20th step of your journey. Did you hear that? 20. Now if this moment doesn't deserve a pause of recognition, then I don't know what does. In the rain, in the sun, in the mud, you're the person that just does it and keeps going, so that's why I'm pausing to tell you keep your head up and keep pushing. The win is in your sights and there ain't no stopping now. All right. In this step, you'll apply cross validation and thoroughly evaluate your model, but before we dive into the details, let's recap why this step is so important. In the previous step, you assessed how well your model performs on both the training and test data sets. However, there's a concern with this approach. Imagine you're preparing for a big exam and you only practice with one set of questions. You might become really good at answering those particular questions, but it doesn't guarantee you'll excel at the actual exam, which…
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)
-
-
-