7 Replies Latest reply on Nov 23, 2018 6:42 AM by Suvojit Basu

    Trend line R-squared and P-values different when date is discrete vs. continuous. Which is correct?

    Suvojit Basu

      Hello,

       

      A question on trend line...The R-Squared and P-Values for a Trend Line (linear) on the same data set changes when the date pill is changed from discrete to continuous. Why is that? Which trend line is correct?

       

      Below is an image detailing the question and also attached is a workbook.

       

      Thanks in advance for your clarification.