
zetreque » 20 May 2017 02:39 pm wrote:Switching axis worked but I don't know why
zetreque » 20 May 2017 03:03 pm wrote:The strange thing is the =Forecast function works which appears to do the same thing.
=FORECAST(X, Yrange, Xrange)
https://excel.tips.net/T002573_Using_th ... ction.html
zetreque » Sat May 20, 2017 11:22 am wrote:Not sure what I am doing wrong here.
y = (59.423 * 43240)  2000000
y = 569450.5
zetreque » 20 May 2017 04:41 pm wrote:Don't know why that formula doesn't work though but since forecast function does it's not important.
zetreque » 20 May 2017 04:41 pm wrote:Don't know why that formula doesn't work though but since forecast function does it's not important.
BioWizard » Sat May 20, 2017 4:53 pm wrote:Zet, the problem was that the formula you were using had a huge error in the intercept. When displaying the equation on the graph, Excel was rounding the intercept to the nearest million! LOL
I solved the linear regression using Excel's data analysis module, which makes all the details of the regression explicit, and that allowed me to see that the exact value of the intercept is 2404952.91880844 and NOT 2000000. Try it now.
Users browsing this forum: No registered users and 3 guests