0
$\begingroup$

Need to find curve/trendline and equation that fits the large data set. Looks as in the scatter plot given below. any suggestion in a particular direction are appreciated. Any libraries in java or python or any online tools. I have tried excels trendline option, but the equation underfits my data.x:price, y:time in days, total instance :8000

$\endgroup$
  • $\begingroup$ Try localized regression. If you're happy working with Python, you can use statsmodels.sourceforge.net/devel/generated/… $\endgroup$ – Jon Oct 12 '16 at 21:12
  • $\begingroup$ is there any way that u know of, to get the resulting equation for the fit? $\endgroup$ – asaini Oct 12 '16 at 21:46
  • $\begingroup$ Nah, I don't like to use Python for stats stuff. A simple Google search should help you out though. $\endgroup$ – Jon Oct 12 '16 at 21:59
  • $\begingroup$ Notice that the spread is related to the mean, If there are no exact zeros, it's probably worth taking log(y), and looking at that. It may also be worth considering log(x), but it depends on what it actually measures as to whether that will also make sense (if the origin is arbitrary, it probably doesn't). What do the y and x variables consist of? $\endgroup$ – Glen_b -Reinstate Monica Oct 13 '16 at 0:26
  • $\begingroup$ x is price , y is time $\endgroup$ – asaini Oct 13 '16 at 5:24
0
$\begingroup$

That looks like data you want to transform first and then maybe try a linear model. My first guess would be to try regressing $y$ against $1/x$

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.