Adding Max and Min Slope lines in Excel (QCAA approach)
HTML-код
- Опубликовано: 5 фев 2025
- 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.