IB Physics: Using Excel to Draw Maximum and Minimum slopes & find uncertainty in slope and intercept

[@empirecrop]

not all heroes wear capes

[@adityapadia4286]

This man is a legend. Thank you so much :))))

[@donerphysics]

Thank you. Please spread the word about the channel, become a subscriber or a member.

[@jusong]

This was extremely helpful! I can't thank you enough for this! :)

[@donerphysics]

You are very welcome. Glad it helped!

[@Danieldsamaral]

Not the hero we deserve, but the hero we need.

[@camillarizzi6835]

thank you so much... saved my life in physics.

[@laithb4129]

When I select data, the "Series x Values" and Series y Values" don't show up. Only "Series Values" show up. Anyone know how to get the x values and y values options to show up?

[@roryhaman4376]

Thank you, you wonderful, wonderful person. This is exactly what I needed! :)

[@anant2795]

Thank you @Chris Doner saved my day!

[@donerphysics]

Thank you. Please spread the word about the channel, become a subscriber or a member.

[@vivian8707]

Thank you so so much sir! :D

[@donerphysics]

Most welcome!

[@zerfahansel6583]

can someone tell me how to find delta x from thats data?

[@vloggetts]

THANK GOD FOR KZbin

[@tecton9413]

IFKR, I cant imagine how our parents passed high school

[@okk3509]

tysm sir

[@donerphysics]

Most welcome

[@akamdhillon9528]

Is there any rule for the number of significant digits for the uncertainty of the slopes?

[@donerphysics]

Slopes are division (rise/run) so we add the percent uncertainties for the numerator and denominator.

[@BensonWallace]

Hi Chris, I don't suppose you'd be able to extend this example to show how to deal with uncertainties in both x and y, so you get uncertainty "boxes" rather than "bars" (as you illustrated in the "basic process" at the start of the video)? It's really hard to find any info out there on plotting uncertainties in both x and y in any software, and I'm beginning to wonder - is it really necessary? Cheers, Benson

[@donerphysics]

It is all one example with uncertainties in x and y. Only two points are needed for either the maximum line or the minimum lines, and these points were obtained using both uncertainties.

[@BensonWallace]

Hi Chris, What I meant was, in the final Excel graph in the video, there are only error bars in y. Would you be able to add error bars in x to the example, and then show how to draw an error box or "uncertainty zone" like the sketch you've got on the right of the screen at about the 7 minute mark? Thanks! Benson

[@donerphysics]

***** Thank you for your suggestion. The x error bars are simply small so it does show up on the graph. Though I could redo this, I don't think it would be the best use of my time.

[@avavknapp8449]

how do you get the delta x and delta y values

[@donerphysics]

Watch the video on recording uncertainties.

[@canonrocklmfao]

why is 3.2+0.3=3.19 for max slop x?

[@canonrocklmfao]

3.2+0.03*

[@MappaPetts1999]

This is bothering me!!!

[@dionshen]

@@MappaPetts1999 because sqrt(10) = 3.16227766 and max slope x = (x + delta x) where delta x = abs uncertainty = 0.03 so max slope x = (sqrt(10) + 0.03) = 3.19 excel just rounded the values from 3.16 to 3.2 which is why it seemed like 3.2+0.03=3.19

[@jaanaliaminzadah]

thank you sir

[@donerphysics]

Most welcome

[@DukeReds7]

god bless

[@donerphysics]

Thank you.

[@Danu_Nanu]