Regression in Excel
Excel
How to Create Dummy Variables in Excel (Step-by-Step)
A dummy variable is a type of variable that we create in regression analysis so that we can represent a categorical variable as a...
Excel
How to Add a Regression Line to a Scatterplot in Excel
A simple linear regression line represents the line that best “fits” a dataset.
This tutorial provides a step-by-step example of how to quickly add a...
Excel
How to Calculate Residual Sum of Squares in Excel
A residual is the difference between an observed value and a predicted value in a regression model.
It is calculated as:
Residual = Observed value –...
Excel
How to Calculate Standardized Residuals in Excel
A residual is the difference between an observed value and a predicted value in a regression model.
It is calculated as:
Residual = Observed value –...
Excel
How to Calculate R-Squared in Excel (With Examples)
R-squared, often written as r2, is a measure of how well a linear regression model fits a dataset.
In technical terms, it is the proportion...
Excel
How to Perform Polynomial Regression in Excel
Regression analysis is used to quantify the relationship between one or more explanatory variables and a response variable.
The most common type of regression analysis...
Excel
How to Perform Logistic Regression in Excel
Logistic regression is a method that we use to fit a regression model when the response variable is binary.
This tutorial explains how to perform logistic regression in...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read