Jared Spencer
Jared Spencer
  • Видео 1
  • Просмотров 594 141
Using LINEST in Excel
How to use the array formula LINEST in Excel for linear regression analysis
Просмотров: 594 306

Видео

Комментарии

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

    Thank you!

  • @dreamnightsky78
    @dreamnightsky78 7 месяцев назад

    Thank you I really needed this clear explanation

  • @ez4w1n
    @ez4w1n 9 месяцев назад

    Still useful after 10 years ^^

  • @JC-to3lq
    @JC-to3lq Год назад

    what do you mean when you say "Command" as the key stroke?

  • @payammahbobi8029
    @payammahbobi8029 Год назад

    Thank you! Excellent!

  • @user-vr7cd9ei2q
    @user-vr7cd9ei2q Год назад

    매우 유용한 정보 감사합니다!

  • @taylorchu-ye9hk
    @taylorchu-ye9hk Год назад

    Great video!

  • @macksoneh
    @macksoneh Год назад

    0:57 Right-clicking the mouse shows up a pop-up window. But mine does not contain menu options such as "Add Data Labels", "Add Trendline", etc. Do I need to install an optional plug-ins?

  • @theresa.gerges
    @theresa.gerges Год назад

    it keeps giving me error, anybody know how to help me pls

  • @catherinebarber348
    @catherinebarber348 2 года назад

    Thank you!

  • @weixinwang52
    @weixinwang52 2 года назад

    Thank you so much!!!!

  • @mihaimihai7531
    @mihaimihai7531 2 года назад

    Good explanation. Thanx

  • @mikelecurci2788
    @mikelecurci2788 2 года назад

    grande bro

  • @granthurlburt4062
    @granthurlburt4062 2 года назад

    THANK YOU! This is very clear and well-explained.But this is hugely awkward. Getting the Scatterplot IS a great idea BUT thie LINEST is so cryptic. Why dont you click "Data" (in the top lone) then the Data Analysis icon at the right? Then you can choose Regression which gives you a nice printout with the ANOVA table and without having to select "Ctrl+Shift+Enter" and type in SE etc? Maybe students find using "Data/Data Analysis" complicated.

    • @sonicandroxas
      @sonicandroxas Год назад

      To be fair, as a student, the data analysis icon was not originally added on my excel as I just right now had to look it up and add as a add-on, using your comment lol.

  • @stonedcodingtom9097
    @stonedcodingtom9097 2 года назад

    Thank you

  • @danny2767
    @danny2767 2 года назад

    Jared, Me again. You have failed me. I am sobbing crying. where is the standard deviation. please.

  • @bennguyen1313
    @bennguyen1313 2 года назад

    After entering LINEST for the given y, x columns... I then hightlight a group of cells (2 column wide by 5 rows deep) and finally highlight the entire formula in the command bar, before pressing CTRL-SHIFT-ENTER so that it treats returns an array of data in those cells. The problem is that the data that it shows is not exactly the same as the trendline equation shown on the scatter-chart! Why? And how would you programatically do the CTRL-SHIFT_ENTER?

    • @granthurlburt4062
      @granthurlburt4062 2 года назад

      Check whether you've select the same number of data values. It's easy to miss a row.

  • @geraldinechaplin5705
    @geraldinechaplin5705 3 года назад

    I very Confused because my physics task, but this video very help me

  • @tonygio
    @tonygio 3 года назад

    thank You

  • @abdulrahmanalkalbani1213
    @abdulrahmanalkalbani1213 3 года назад

    Still useful after 8 years ❤️🌹

  • @payalshah5106
    @payalshah5106 3 года назад

    YOUR AMAZINGGGGG

  • @PainfullyHonestTruth
    @PainfullyHonestTruth 3 года назад

    Thank you! Still helping Physics students 11 years to the date!!!

  • @drunkguardsman1454
    @drunkguardsman1454 3 года назад

    Thanks for the video, it's really helped me to get an uni assessment in on time.

  • @haminationclipsbutvocoded8969
    @haminationclipsbutvocoded8969 4 года назад

    I’m Jared ;-;

  • @yaroslavfrusov380
    @yaroslavfrusov380 4 года назад

    you super men. I lavyou

  • @keilahernandez191
    @keilahernandez191 4 года назад

    7 years later... LIFE SAVER!

  • @crouiseglenn9475
    @crouiseglenn9475 4 года назад

    just saved my assigment dude

  • @miguelespejel2462
    @miguelespejel2462 4 года назад

    hello, thanks for this video. I'm not sure if this is the best video but I need to know is how to best fit a set of measurements, for example if i measure the thickness of a table, if i take 10 points, probably two are out of the "optimal" measurement but the rest is "within" this optimal measurement then how can i change this measurement outputs for best fit and make everything within? For this example I'm trying to change the "Y" data. What i was thinking is to subtract the "slope" to every point and then redo the scatter? Thanks.

  • @syedahmer1928
    @syedahmer1928 4 года назад

    Very very nice

  • @stephrod3
    @stephrod3 4 года назад

    WOW DUDE THANK YOU

  • @benhoward9079
    @benhoward9079 4 года назад

    He sound exactly like Zach Galifiniakis

  • @B00yaB00
    @B00yaB00 5 лет назад

    Thanks!

  • @xingyuli82
    @xingyuli82 5 лет назад

    Thank you!

  • @juanmanuelvalerorodriguez616
    @juanmanuelvalerorodriguez616 5 лет назад

    Bless you child. This was a much needed information.

  • @veltasleze5719
    @veltasleze5719 5 лет назад

    you deserve a place in heaven, my child

  • @sharrowwallace4254
    @sharrowwallace4254 6 лет назад

    thanks

  • @jiahui313
    @jiahui313 6 лет назад

    thanks! this is so helpful!

  • @Joysphh
    @Joysphh 6 лет назад

    so helpful, thanks!

  • @aussie3851
    @aussie3851 6 лет назад

    Wow, you just saved me so much time haha! Thankyou!

  • @productivityaesthetic1621
    @productivityaesthetic1621 6 лет назад

    Still a great tutorial!

  • @Light-vu6ws
    @Light-vu6ws 6 лет назад

    Godlike Voice

  • @kennyd8536
    @kennyd8536 6 лет назад

    You saved me

  • @johnp4871
    @johnp4871 6 лет назад

    You're the best! Thank you!

  • @JaceTimes
    @JaceTimes 6 лет назад

    for excel 2017, you have to hold down shift+control then press enter

    • @rubenromeo1672
      @rubenromeo1672 6 лет назад

      It's 4:57am. I've been doing this for hours and nobody has said the correct new keys for excel mac 2017... thank you. you just got me closer to getting some sleep

    • @JaceTimes
      @JaceTimes 6 лет назад

      No problem :) struggling student myself and I thought someone would run into the same problem as me

    • @Drivenlemon
      @Drivenlemon 5 лет назад

      Careful, he's a hero

    • @loganphilpott9557
      @loganphilpott9557 5 лет назад

      i love u

    • @alirezasadeghifar3815
      @alirezasadeghifar3815 5 лет назад

      God bless you!

  • @toothless9000
    @toothless9000 6 лет назад

    thanks!

  • @oliviachom
    @oliviachom 6 лет назад

    Thank you! This helped a lot with my assignment

  • @stanislavdidenko8436
    @stanislavdidenko8436 6 лет назад

    Bro you are Pro. That's what I thank you for.

  • @rizz_razzle_boi369
    @rizz_razzle_boi369 6 лет назад

    Lowkey youtube mvp

  • @tarektohme2508
    @tarektohme2508 6 лет назад

    I am a more complete person after watching this

  • @sumaia4237
    @sumaia4237 6 лет назад

    Thank you for your help :)