Finding Trendline with Online Excel and Desktop Version of Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024
  • Finding a trendline using Excel is different depending on the version you are using. This video looks at the different ways to find the trendline and correlation coefficient on the desktop and online version of Microsoft Excel.

ความคิดเห็น • 6

  • @TheF4TB4CK
    @TheF4TB4CK 4 หลายเดือนก่อน +1

    Hi Gail,
    I am currently enrolled in Applied Statistics at SNHU and I ran into this same problem needing to add a trendline to a scatterplot in the online version of excel. I searched google for about 30 minutes before finding your video. THANK YOU!!!

  • @BriSanders-nl9gb
    @BriSanders-nl9gb 5 หลายเดือนก่อน +1

    Thank you!!

  • @yousrabk1111
    @yousrabk1111 10 หลายเดือนก่อน +1

    you are a life savor thank you soooo much

  • @TharunAA123
    @TharunAA123 10 หลายเดือนก่อน +1

    Hi professor, I have a question , not related to the quiz but from a math perspective. Is it also valid to get the trendline using the regression option in the Data Analysis plugin under the Data tab ? (cause from my experience, doing so will give the intercept and x -coefficient value, which can then be used to plot the trend)

    • @TharunAA123
      @TharunAA123 10 หลายเดือนก่อน +1

      Twisted, I know hehe; but in this way, you get the numbers too.

    • @GailIllich
      @GailIllich  10 หลายเดือนก่อน

      Yes! Your method works as well!