A residual is the difference between an observed value and a predicted value in a…
Category:
Regression in Excel
-
-
ExcelRegression in ExcelSoftware Tutorials
How to Calculate R-Squared in Excel (With Examples)
by Erma Khanby Erma KhanR-squared, often written as r2, is a measure of how well a linear regression model…
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform Polynomial Regression in Excel
by Erma Khanby Erma KhanRegression analysis is used to quantify the relationship between one or more explanatory variables and…
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform Logistic Regression in Excel
by Erma Khanby Erma KhanLogistic regression is a method that we use to fit a regression model when the response variable is…
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform Multiple Linear Regression in Excel
by Erma Khanby Erma KhanMultiple linear regression is a method we can use to understand the relationship between two or more…
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform Simple Linear Regression in Excel
by Erma Khanby Erma KhanSimple linear regression is a method we can use to understand the relationship between an explanatory variable,…
-
ExcelRegression in ExcelSoftware Tutorials
How to Create a Q-Q Plot in Excel
by Erma Khanby Erma KhanA Q-Q plot, short for “quantile-quantile” plot, is often used to assess whether or not a…
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform a Breusch-Pagan Test in Excel
by Erma Khanby Erma KhanA Breusch-Pagan Test is used to determine if heteroscedasticity is present in a regression analysis.…
-
Multicollinearity in regression analysis occurs when two or more explanatory variables are highly correlated to each other, such…
-
ExcelRegression in ExcelSoftware Tutorials
How to Construct a Prediction Interval in Excel
by Erma Khanby Erma KhanIn statistics, simple linear regression is a technique we can use to quantify the relationship…