Making a scatter graph and line of best fit in Excel

Поделиться
HTML-код
  • Опубликовано: 25 авг 2020
  • Step by step instructions on entering data and then creating a graph with a trend line (line of best fit) in MS Excel. This is the Windows desktop version, if using a Mac or Office 365 yours may be slightly different.
    To see the Google Sheets version of this video: • Making a scatter graph...

Комментарии • 15

  • @dinohall2595
    @dinohall2595 2 года назад +11

    "What Excel calls a trend line and everyone else in the world calls a best-fit line..."
    The shade thrown here, intentional or not, is legendary. Thank for the video!

  • @this_is_gold_leader2229
    @this_is_gold_leader2229 3 года назад +4

    Thank you! You're video is the only one that actually shows how you can find the y= equation from your graph, thank you!

  • @RussischQ
    @RussischQ 3 месяца назад

    THANK YOU VERY MUCH YOU'RE THE ONLY ONE THAT EXPLAINS IT FAST AND CLEARLY❤

  • @julissaa.godinez1262
    @julissaa.godinez1262 3 года назад +4

    Thank you, this helped me with my homework assignment!

  • @aqmi
    @aqmi 3 года назад +1

    Thank you so much for this!

  • @yousefdimian1903
    @yousefdimian1903 3 года назад +2

    thank you, this is very helpful

  • @tavsklucis4742
    @tavsklucis4742 2 года назад +1

    Thank you, very helpful

  • @amadif1793
    @amadif1793 2 года назад +1

    Very helpful thank you

  • @aatifrashid5413
    @aatifrashid5413 2 года назад +1

    Very helpful

  • @samanthaly7910
    @samanthaly7910 3 года назад +3

    that plus sign doesn't come up for me?

  • @tatyanavlogs541
    @tatyanavlogs541 2 года назад +1

    Thank you

  • @PNWSurvivor
    @PNWSurvivor 6 месяцев назад

    okay but what if its office 365 excel? i am having the hardest time even finding similar options and tabs needed and the value inputs seem to not let me add values exither. and these wierd red blue and purple boxes appear around some of my selected values.

    • @dr.stepheng.prilliman8726
      @dr.stepheng.prilliman8726  6 месяцев назад

      My understanding is that the Office 365 version of Excel does not support this function. I usually recommend my students who only have Office 365 access use Google sheets for this instead. See this video for Sheets instructions: ruclips.net/video/rJXz1qVYFu4/видео.html

    • @PNWSurvivor
      @PNWSurvivor 6 месяцев назад

      @@dr.stepheng.prilliman8726 thanks! i installed the desktop app and it works great!

  • @Canvas58027
    @Canvas58027 Месяц назад

    2:30 trendline