We now consider how to perform exponential regression, i.e. regression based on the following equation:
Our goal is to calculate the values of the coefficients α and β which minimize the sum of the squares of the observed y values minus the values of y predicted by the regression model.
We explore both linear and nonlinear exponential regression models as well as describe how to perform exponential regression using Real Statistics capabilities.
Topics
- Linear model using Excel capabilities
- Nonlinear model using Solver
- Nonlinear model using Newton’s Method
- Nonlinear model using Real Statistics capabilities
Hi there,
How do I use the standard error generated by the regression to know what the actual standard error is?
Paul,
What do you mean by “the actual standard error”?
Charles
Dear Charles,
I have 2 sets of data (decrease concentration of substance s1 with time and decrease concentration of substance s2 with time), which I described by exponential decay curve Conc (s1)=a1+a2*exp(-k*t) and Conc (s2)=a1+a2*exp(-k*t). I got the parameters from exponential curves: a1, a2 and k for both substances. Now was asked to compare these parameters (a1 for substance 1 and 2; a2 and k) to show that they are similar or different. My question is: which statistical test can I do to answer this question?
Thank you,
Anna
Anna,
If you treat Conc (s1)=a1+a2*exp(-k*t) as a linear regression model, then you can use the test described in the following webpage:
https://real-statistics.com/regression/hypothesis-testing-significance-regression-line-slope/comparing-slopes-two-independent-samples/
Charles