Regression in Excel
Excel
How to Perform Multiple Linear Regression in Excel
Multiple linear regression is a method we can use to understand the relationship between two or more explanatory variables and a response variable.
This tutorial explains how...
Excel
How to Perform Simple Linear Regression in Excel
Simple linear regression is a method we can use to understand the relationship between an explanatory variable, x, and a response variable, y.
This tutorial explains how...
Excel
How to Create a Q-Q Plot in Excel
A Q-Q plot, short for “quantile-quantile” plot, is often used to assess whether or not a set of data potentially came from some theoretical distribution....
Excel
How to Perform a Breusch-Pagan Test in Excel
A Breusch-Pagan Test is used to determine if heteroscedasticity is present in a regression analysis.
This tutorial explains how to perform a Breusch-Pagan Test in...
Excel
How to Calculate VIF in Excel
Multicollinearity in regression analysis occurs when two or more explanatory variables are highly correlated to each other, such that they do not provide unique or independent information...
Excel
How to Construct a Prediction Interval in Excel
In statistics, simple linear regression is a technique we can use to quantify the relationship between a predictor variable, x, and a response variable,...
Excel
How to Create a Residual Plot in Excel
A residual plot is a type of plot that displays the fitted values against the residual values for a regression model.
This type of plot...
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