Cubic regression is a regression technique we can use when the relationship between a predictor…
Category:
Regression in Excel
-
-
ExcelRegression in ExcelSoftware Tutorials
How to Perform Power Regression in Excel (Step-by-Step)
by Erma Khanby Erma KhanPower regression is a type of non-linear regression that takes on the following form: y…
-
ExcelRegression in ExcelSoftware Tutorials
How to Calculate SST, SSR, and SSE in Excel
by Erma Khanby Erma KhanWe often use three different sum of squares values to measure how well a regression…
-
ExcelRegression in ExcelSoftware Tutorials
Logarithmic Regression in Excel (Step-by-Step)
by Erma Khanby Erma KhanLogarithmic regression is a type of regression used to model situations where growth or decay…
-
ExcelRegression in ExcelSoftware Tutorials
Exponential Regression in Excel (Step-by-Step)
by Erma Khanby Erma KhanExponential regression is a type of regression model that can be used to model the…
-
ExcelRegression in ExcelSoftware Tutorials
How to Calculate Adjusted R-Squared in Excel
by Erma Khanby Erma KhanR-squared, often written R2, is the proportion of the variance in the response variable that can…
-
ExcelRegression in ExcelSoftware Tutorials
How to Calculate the Standard Error of Regression in Excel
by Erma Khanby Erma KhanWhenever we fit a linear regression model, the model takes on the following form: Y…
-
ExcelRegression in ExcelSoftware Tutorials
How to Create Dummy Variables in Excel (Step-by-Step)
by Erma Khanby Erma KhanA dummy variable is a type of variable that we create in regression analysis so…
-
ExcelRegression in ExcelSoftware Tutorials
How to Add a Regression Line to a Scatterplot in Excel
by Erma Khanby Erma KhanA simple linear regression line represents the line that best “fits” a dataset. This tutorial…
-
ExcelRegression in ExcelSoftware Tutorials
How to Calculate Residual Sum of Squares in Excel
by Erma Khanby Erma KhanA residual is the difference between an observed value and a predicted value in a…