Equation error for linear trendline with dates

[davemcwish]

I have the following data that I've plotted and trying to forecast when 'Value' reaches 8

Date Value 01 Feb 2015 6.9330 04 Mar 2015 6.9588 04 April 2015 6.9847 04 May 2015 7.0697 04 June 2015 7.1576 <tbody> </tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

Using a linear forecast trendline, I get the equation

y=0.0019x-71.545

which gives a value of x as 41865, for y=8

This doesn't seem right as the first value I have is for 01 Feb 2015 (42036)


Interestingly, if I switch to a Logarithmic trendline I get

y=78.558ln(x)-829.44

which gives a reasonable value of 42622 (9 Sep 2015)


Anyone got an answer to why the linear trendline equation gives a seemingly incorrect value ?

 

[pgc01]

Hi

The way you display the coefficients, it seems out of proportion. You have 2 significant digits in the x coefficient but 5 significant digits in the x values and in the other coefficient.

Try for ex. 12 decimals. (in the chart, right-click on the equation label, choose Format Trendline Label->Number->Category: Number->Decimal Places: 12)