IIRF Online > Finance & Accounting > Money Management Tools > Excel Analytics > Excel Analytics: Linear Regression Analysis in MS Excel
Excel Analytics: Linear Regression Analysis in MS Excel by Udemy
Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis
Course Highlights
- Learn how to solve real life problem using the Linear Regression technique
- Preliminary analysis of data using Univariate analysis before running Linear regression
- Predict future outcomes basis past data by implementing Simplest Machine Learning algorithm
- Understand how to interpret the result of Linear Regression model and translate them into actionable insight
- Indepth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem
- Course contains a end-to-end DIY project to implement your learnings from the lectures
Skills you will learn!
Curriculum
1 Topic
Introduction
17 Topics
Gathering Business Knowledge
Data Exploration
Course resources
This is a milestone!
The Data and the Data Dictionary
Univariate analysis and EDD
Discriptive Data Analytics in Excel
Outlier Treatment
Identifying and Treating Outliers in Excel
Missing Value Imputation
Identifying and Treating missing values in Excel
Variable Transformation in Excel
Dummy variable creation: Handling qualitative data
Dummy Variable Creation in Excel
Correlation Analysis
Creating Correlation Matrix in Excel
Quiz
12 Topics
The Problem Statement
Basic Equations and Ordinary Least Squares (OLS) method
Assessing accuracy of predicted coefficients
Assessing Model Accuracy: RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression
The F - statistic
Interpreting results of Categorical variables
Creating Multiple Linear Regression model
Quiz
Excel: Running Linear Regression using Solver
Quiz
11 Topics
Introduction
Goal-seek and Scenario Manager in Excel
Solver in Excel
Different Solving methods of Excel Solver
Quiz
Solving a Transportation problem
Price Skimming
Excel - Price Skimming model
Concept of Customer lifetime Value
Excel - Calculating customer lifetime value
Quiz
3 Topics
Popular Excel charts
The final milestone!
Bonus Lecture
Excel Analytics: Linear Regression Analysis in MS Excel
Related Excel Analytics Courses
Thank You!
Your review has been submitted successfully.