Adding Max and Min Slope lines in Excel (QCAA approach)

For my Senior Physics Class: I promised you a video showing how to add lines of max and min slopes to an excel graph. Here 'tis. Enjoy!

EDIT: There's one more step I'd recommend, and that is to remove the "markers" from the max and min slope lines to make them a bit cleaner. (Double-click on those lines and use the menu on the right of the screen)

CAVEAT: To the mathematical purists: This video is a simple (simlistic?) implementation of the QCAA Physics syllabus's prescribed approach to creating max and min sloped lines. It is definitely NOT the most mathematically precise or elegant solution. It would be better to use Std. Dev. or Std. Err. instead of uncertainty of the mean, and there are better ways to determine the min and max lines. I'm not endorsing this method, just showing you how to implement it in Excel.

[youprobablywontrememberme]

Absolute legend bro ur helping me more than my actual physics teacher senior year at KGSC

[Jel]

Amazing dude very well explained helped me out a ton with my IB physics IA thank you very much!

[xdfluffyturtle]

thanks mate! physics assignment due tomorrow and I had no clue how to do this until after this video

[Ducklingfatigueserious]

very useful video, very good thank you very much, much love from Australia

[luna_lovegood]

Stressing about trendlines at 11:30 at night for physics assignment, absolute life saver

[LordCoye]

The video is very useful. Where can I find the theory? The reason for choosing the penultimate point for the last case is not clear to me. Thanks for the help.

[kaki]

TYSM bro it helps a lot for my physics IA ur ma goat

[norbipiotrowski]

shame it doesnt go through every bar :(

[hallburger]

i keep getting an error whenever try to select my y values even though im doing exactly as you are

[thenoobgamr]

The first line went fine but the second min line doesn't show up and doesn't have a r squared value of 1

[spleeqy]

How do you add the individual error bars? :)