Regression in Excel
Excel
Cubic Regression in Excel (Step-by-Step)
Cubic regression is a regression technique we can use when the relationship between a predictor variable and a response variable is non-linear.
The following step-by-step...
Excel
How to Perform Power Regression in Excel (Step-by-Step)
Power regression is a type of non-linear regression that takes on the following form:
y = axb
where:
y: The response variable
x: The predictor variable
a, b: The...
Excel
How to Calculate SST, SSR, and SSE in Excel
We often use three different sum of squares values to measure how well a regression line actually fits a dataset:
1. Sum of Squares Total...
Excel
Exponential Regression in Excel (Step-by-Step)
Exponential regression is a type of regression model that can be used to model the following situations:
1. Exponential growth: Growth begins slowly and then...
Excel
How to Calculate Adjusted R-Squared in Excel
R-squared, often written R2, is the proportion of the variance in the response variable that can be explained by the predictor variables in a linear...
Excel
How to Calculate the Standard Error of Regression in Excel
Whenever we fit a linear regression model, the model takes on the following form:
Y = β0 + β1X + … + βiX +ϵ
where ϵ...
Excel
Logarithmic Regression in Excel (Step-by-Step)
Logarithmic regression is a type of regression used to model situations where growth or decay accelerates rapidly at first and then slows over time.
For...
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