Jared Spencer
Jared Spencer
  • 1
  • 596 978
Using LINEST in Excel
How to use the array formula LINEST in Excel for linear regression analysis
Переглядів: 597 064

Відео

КОМЕНТАРІ

  • @anasself4156
    @anasself4156 4 дні тому

    thank you so much

  • @tinanagy6185
    @tinanagy6185 6 місяців тому

    Thank you!

  • @dreamnightsky78
    @dreamnightsky78 8 місяців тому

    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!

  • @곽창식-f7b
    @곽창식-f7b Рік тому

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

  • @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 6 років тому

    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 7 років тому

    I am a more complete person after watching this