Using LINEST to determine the uncertainty on slope in Excel

[@gillamseddon-callaghan413]

I just spent 5 hours trying to do it manually and couldn't work it out. Thank you Brad Moyle you beautiful person.

[@TAHIRMAQSOOD15]

This is the best and simple and easy was to do LINEST in excel. I have watched many videos on it, but this guy explained it nice and easily. Thank you!

[@greggapowell67]

The LINEST Function returns an array with 10 values - not 4. If you highlight a 2x5 array (columns x rows), and hit control-shift+enter, it will return: y-int, se(slope), se (int), r^2, se(y), F, df, ss reg, and, ss resid. The array it LINEST returns contains more than 4 elements.

[@Jon1998109]

This man is a god! you just saved my master engineering degree!

[@JiggyGian]

This was so helpful, clear and concise explanation.

[@vedantkashyap5703]

Straightforward and simple explanation !

[@bleuemoone8710]

thanks, needed this for my chem homework

[@Firefist0123]

you just earned yourself a like for saving me

[@jeffrey_heo]

How do we account for the individual errors associated with the data points when calculating the slope uncertainty? Thanks!

[@Shieldcoomer]

Thank you so much. This really helped... Origin lab is so much more clearer on how to do these,but its crazy how many functions excel can do as well. Insane program,wish it was more clear on how to do these things.

[@aakashantony9419]

Im on a newer version of excel rt now, and for me it gives uncertainty if I press only ENTER. (essentially the opposite of the older version)

[@johnwade7842]

Thanks so much this will definitely be extremely useful.

[@calvingoldsmith3963]

You are the GOAT

[@mahendradhungel8011]

fucking finally a video that easy to understand about uncertainty and not to fuck around, thanks!

[@liosisbill]

Great video mate , short and helpful

[@Yun-rn1iz]

thank you for saving me on a physics lab!

[@PinkGem]

Hey, great video. I wanted to know. How do I press CTRL + SHIFT + ENTER on a phone. Do I just press enter?

[@chandlerguilfoyle3066]

Thanks for your help!

[@vaniabessos1691]

I'm doing control shift enter on excel on my macbook air but i only get one value

[@nalelimoeti6289]

This video was very helpful. Thank you

[@takashi-lee3943]

Hey not sure if this is new but at least for me you do not have to do ctrl shift enter Just enter works, doing all 3 didn’t fill them up and enter did now

[@bridgetbaber8718]

helped me pass pchem thank you

[@hilag.868]

best video out here

[@danielb8982]

helpful! especially the control shift enter reminder

[@lou.104]

For my old office 2010 it doesnt work, does not show 4 values, it shows only one

[@chimcjob]

All is not lost. See here for help kzbin.info/www/bejne/Z5iofKKAqKuejKs

[@SMBH-M87]

did you ever figure it out?

[@abdulrahmanmohamed8298]

Is this the uncertainty the same as standard deviation??

[@Axnjxn55]

no, very different. sometimes youll want to use st.dev but not always

[@SMBH-M87]

Why am only getting the slop value? Nothing else appears in the other 3 cells.

[@anilhugoabdulhaqwilliams4613]

Very straight-forward, thaks

[@davionsterling8784]

well thanks for the help with my physical chemistry write up

[@mohi582]

Thank you, very useful

[@joansebastianlozadapardo6273]

thank you so much.

[@liam8854]

Goat

[@josephtraverso5355]

Thank you

[@cardboardcoyote4730]

Ta very much lad 👍🏼 x

[@sa-vx5vi]

thank u sooo much

[@damukukandu8842]

control + shift + enter does not work for me.

[@juanfa98]

Grande

[@MrSteviejones94]

ASPC 101 brought me here

[@p.j.882]

You did not show how to calculate the standard error of slope and intercept.

[@pramodpokharel3311]

wrong confusing