- Thread starter RHassanpour
- Start date

This kind of resembles the confidence interval of the curve fit (also known as the ScheffÃ© band), although unless you set the confidence level extremely high, it would be a much tighter fit than that.

You could also estimate a precision interval of the curve fit using the same technique.

In both of these cases, you would start by curve-fitting the data (which you can do in Excel) and then calculating the standard error of the fit (which you can also do in Excel.

I don't know if this is what you want, though.

What I need here is the slope and intercept of the two upper and lower lines. As far as I know, in Excel, only one line fits into the data.

Yes, but the red curves are not straight lines if you look at it. So you can't get a slope and intercept.

What I need here is the slope and intercept of the two upper and lower lines. As far as I know, in Excel, only one line fits into the data.

Try quantile regression for what you want.

Last edited by a moderator:

That's not even the problem. Polynomial, exponential,Yes, but the red curves are not straight lines if you look at it. So you can't get a slope an intercept.

The problem is, regressions try to fit the data set (as a whole). OP is trying to fit the upper limit and lower limit of the data set. There is no simple or unique way to define this.

Does quantile regression address this somehow? (I'm honestly not familiar with the concept, and couldn't follow the Wikipedia article at first glance.)

That was totally not my remark. Please read it more carefully.That's not even the problem. Polynomial, exponential,etc.regressions are totally possible; even a linear regression would get you some kind of estimate.

No, I know. He was asking how to get the slope and intercept of a curve, and you were pointing out neither curve was a straight line and therefore neither had a singular slope or intercept. I got that.That was totally not my remark. Please read it more carefully.

I was skipping ahead and responding to the

And that's kind of why I was asking what the lines were supposed to represent in the first place. Is OP looking for something like, "draw a curve that will contains 95 % of the data points from an infinite set?" Because we can do this with some assumptions about the probability distribution. Or do they just want a curve that looks somewhat like the general shape we discern as humans? Because in that case, I'd just grab a French curve, pick three points, and trace it.

(And seriously, if quantile regression does what they want, then I have egg on my face. I still don't understand what it is or does.)

As I mentioned above, I need the slope and intercept of the upper limit and lower limit of the data set in both linear and nonlinear fitting. My question was, is there any particular software or method to do this or should it be done manually? The red lines drawn do not matter.