Machine Learning in Excel

Curriculum

• Introduction Free

  3 Lessons 18 Min

  In this introductory section, we will discuss why you need to learn advanced statistics, what sets this discipline apart from machine learning, and how you can get the most out of the Machine Learning in Excel course.

  Course Introduction Free

  What Is Machine Learning? Free

  Types of Machine Learning Free
• Simple Linear Regression

  10 Lessons 49 Min

  Join us to create your first simple regression in Excel and get familiar with a very important statistical concept – the Ordinary least squares framework. You will learn about OLS assumptions, how to interpret regression results, as well as how to decompose variability.

  Linear Regression: Introduction Free

  Linear Regression Free

  Linear Regression Model (Graphical Representation) Free

  Formatting Excel Spreadsheets Free

  First Regression in Excel Free

  What Is OLS? Free

  Interpreting Regression Tables (Part 1) Free

  Decomposition of Variability Free

  Interpreting Regression Tables (Part 2)

  Interpreting Regression Tables (Part 3)
• Multiple Linear Regression

  11 Lessons 47 Min

  In section 3 you will discover multiple linear regression. We will expand on the simple linear regression techniques we covered in the previous section and discuss some practical considerations such as working with dummy variables and how to make predictions with more than one independent variable using Excel.

  Multiple Regression Analysis

  Multiple Linear Regression (Example)

  Multiple Linear Regression (Results)

  OLS Assumptions

  OLS Assumptions: Linearity

  OLS Assumptions: No Endogeneity

  OLS Assumptions: Normality and Homoscedasticity

  OSL Assumptions: No Autocorrelation

  OLS Assumptions: No Multicollinearity

  Dummy Variables

  Making Predictions Using Linear Regression
• Linear Regression Practical Example

  6 Lessons 41 Min

  An all-in-one use case that tests your understanding of each of the concepts you mastered so far. We will focus on a property price dataset and create a linear regression model to predict house prices.

  Practical Example (part 1)

  Practical Example (part 2)

  Practical Example (part 3)

  A note on multicollinearity

  Feature Scaling

  Practical Example (part 4)
• Logistic Regression

  12 Lessons 70 Min

  This section of the course covers logistic regression. You will grasp the difference between logistic and logit regression, the concepts of ROC curve, underfitting and overfitting, and how to interpret results from a logistic regression. Of course, you will see a practical example of how to perform this type of regression in Excel and calculate the accuracy of your model.

  Introduction to Logistic Regression

  From Linear to Logistic Regression

  Logistic vs. Logit Function

  Applying Logistic Regression in Excel

  Interpreting Regression Coefficients

  Logistic Regression with Xreal

  Understanding the Logistic Regression Summary (part 1)

  Understanding the Logistic Regression Summary (Part 2)

  ROC Curve

  Binary Predictors for Logistic Regressions

  Underfitting and Overfitting

  Testing the Logistic Model
• Cluster Analysis

  4 Lessons 15 Min

  Cluster analysis is the most intuitive and important example of unsupervised learning. However, to be able to understand cluster analysis, you must first become familiar with the mathematics behind it. Here we will explore the fundamentals of cluster analysis and have a look at the differences between clustering and classification.

  Cluster Analysis (Definition)

  Cluster Analysis (Application)

  Clustering vs Classification

  Cluster Analysis (Math Prerequisites)
• K-means Clustering

  11 Lessons 58 Min

  Master K-means clustering in Excel by learning how to choose the number of clusters in your analysis and determine when to standardize or not standardize your data. At the end of this section, we will go through a complete practical example that includes marketing segmentation with cluster analysis.

  K-means Clustering

  K-means Clustering in Excel

  K-means Clustering with Xreal

  Choosing the Number of Clusters

  Clustering Categorical Data

  Standardization

  Clustering and Regression

  Clustering (Pros and Cons)

  Types of Clustering

  Market Segmentation (Part 1)

  Market Segmentation (Part 2)
• Decision Trees

  6 Lessons 28 Min

  With the use of visual examples this section of the course introduces you to the concept of decision trees. We will cover the advantages and disadvantages of this method and explore its inner workings – how is the tree constructed and what metrics are used in its construction. This will be followed up by a practical example showcasing how to create decision trees in Excel.

  Decision Trees

  Entropy (Loss function)

  Information Gain

  Decision Trees in Excel (Part 1)

  Decision Trees in Excel (part 2)

  Decision trees (Prediction)
• Machine Learning in the Cloud

  7 Lessons 28 Min

  In the final section of the course, we will combine Azure and Microsoft Excel to run ML experiments in the cloud. In our case, we’ll create a predictive analytics model in Azure Machine Learning Studio.

  Machine Learning in the Cloud

  Setting up Azure Machine Learning Studio (AMLS)

  First Experiment in AMLS (Part 1)

  First Experiment in AMLS (Part 2)

  Publishing a Web Service

  Azure Assignment

  The Future of Machine Learning