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

  Рет қаралды 51,548

Ian Thompson

Ian Thompson

Күн бұрын

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.

Пікірлер: 39
@youprobablywontrememberme4087
@youprobablywontrememberme4087 Жыл бұрын
Absolute legend bro ur helping me more than my actual physics teacher senior year at KGSC
@Beamz-
@Beamz- 7 ай бұрын
Bro what teacher you had?
@hm-gl3ih
@hm-gl3ih 4 ай бұрын
cuz you should already be able to do it. evidently i don’t know either cuz i’m here but i’m aware of my mistakes
@xdfluffyturtle9025
@xdfluffyturtle9025 Жыл бұрын
thanks mate! physics assignment due tomorrow and I had no clue how to do this until after this video
@raccondolphin
@raccondolphin 2 ай бұрын
same bro
@luna_lovegood4904
@luna_lovegood4904 2 жыл бұрын
Thankyou!!!!!! Stressing about trendlines at 11:30 at night for physics assignment, absolute life saver
@dangomangothe1941
@dangomangothe1941 2 жыл бұрын
I'm in the exact same position mate
@ashar4121
@ashar4121 Жыл бұрын
Literally me right now...
@vmpscd1360
@vmpscd1360 Жыл бұрын
same bro
@simonvutov7575
@simonvutov7575 8 ай бұрын
same, writing physics IA
@Jel06
@Jel06 2 жыл бұрын
Amazing dude very well explained helped me out a ton with my IB physics IA thank you very much!
@devanshsoni5151
@devanshsoni5151 2 жыл бұрын
send me ur ia I copy
@devanshsoni5151
@devanshsoni5151 2 жыл бұрын
inshallah allah will praise u
@mrt1n.
@mrt1n. 2 жыл бұрын
Lol thats what it helped me for as well
@billieswig8658
@billieswig8658 6 ай бұрын
damn im also tryna learn this for my ia
@kaki9073
@kaki9073 22 күн бұрын
TYSM bro it helps a lot for my physics IA ur ma goat
@Ducklingfatigueserious
@Ducklingfatigueserious 2 жыл бұрын
very useful video, very good thank you very much, much love from Australia
@lachlan-mastermind6781
@lachlan-mastermind6781 2 жыл бұрын
Thanks so much! Helps a lot.
@LordCoye
@LordCoye 2 жыл бұрын
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.
@junaidmirza2984
@junaidmirza2984 2 жыл бұрын
so helpful thanks man
@flvorian6001
@flvorian6001 Жыл бұрын
Love Ya Mr Thompson!
@hallburger5961
@hallburger5961 Жыл бұрын
i keep getting an error whenever try to select my y values even though im doing exactly as you are
@joshsoolee
@joshsoolee Жыл бұрын
Great explanation.
@naurahalimanasution9463
@naurahalimanasution9463 9 ай бұрын
THANK YOU SO MUCH
@JourdanLaGrange
@JourdanLaGrange 5 ай бұрын
life saver
@hayleyshearer9631
@hayleyshearer9631 6 ай бұрын
Thanks sir!
@dutche737
@dutche737 Жыл бұрын
Thank you so much
@thenoobgam3r190
@thenoobgam3r190 Жыл бұрын
The first line went fine but the second min line doesn't show up and doesn't have a r squared value of 1
@e-scott600
@e-scott600 3 жыл бұрын
Class Vid Ian
@devanshsoni5151
@devanshsoni5151 2 жыл бұрын
paan thuk peel
@Vizion69
@Vizion69 11 ай бұрын
Ty mate
@mongomonkee5071
@mongomonkee5071 3 жыл бұрын
Cheers bud
@spleeqy2555
@spleeqy2555 Жыл бұрын
How do you add the individual error bars? :)
@randomclips850
@randomclips850 Жыл бұрын
delete the graph and try do it again, and if that doesn't work keep deleting and trying
@crazygamers2767
@crazygamers2767 2 жыл бұрын
ty bro
@kellyjin2469
@kellyjin2469 Жыл бұрын
THANK YOU VERY MUCH!
How To Add Error Bars In Excel Scatter Plot (Custom Error Bars)
7:56
Teaching Junction
Рет қаралды 87 М.
Whoa
01:00
Justin Flom
Рет қаралды 58 МЛН
Nurse's Mission: Bringing Joy to Young Lives #shorts
00:17
Fabiosa Stories
Рет қаралды 19 МЛН
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 1,5 МЛН
09 Understanding Max & Min Gradients
11:10
Shem Thompson
Рет қаралды 43 М.
IB Physics: Formulas, Trendlines and Error bars in Excel
11:29
Chris Doner
Рет қаралды 26 М.
Using LINEST to determine the uncertainty on slope in Excel
5:00
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 519 М.
9 Exciting NEW Excel Functions for Shaping Arrays - Incredible!
12:28
MyOnlineTrainingHub
Рет қаралды 38 М.
12 Dashboard design tips for better data visualization
9:51
Geckoboard
Рет қаралды 178 М.
How to make a scatter plot and add  uncertainty bars on excel ?
12:38
Whoa
01:00
Justin Flom
Рет қаралды 58 МЛН