From the course: Advanced Python in Excel: Machine Learning
Join today to access over 25,300 courses taught by industry experts.
Building regression models in Excel
From the course: Advanced Python in Excel: Machine Learning
Building regression models in Excel
- [Instructor] Regression analysis is a powerful statistical method used to examine the relationship between variables. With Python in Excel, you will start by loading your dataset using the Excel function. This dataset might include variables like sales, marketing spend, and economic indicators, which you want to analyze to predict future sales orders. Next, you will need to import the necessary libraries such as Pandas for data manipulation and scikit-learn for building and evaluating regression models. Feature selection is key in regression modeling. You will need to identify the independent variables or features that have the most significant impact on your dependent variable or target to build an effective model. Then, you will split your dataset into training and testing sets. This approach allows you to train your model on one portion of the data and validate its performance on another, ensuring it generalizes well. Using scikit-learn, you will create a linear regression model.…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.