Trendline Slope and Intercept Formulas in Microsoft Excel

avatar
(Edited)

▶️ Watch on 3Speak


In this video I go over two very useful formulas in Microsoft Excel. These questions are the SLOPE and INTERCEPT equations which calculate the slope and y intercept of a trendline fitted to a table of data. These are the same calculations that the trendline automatically calculates when you display the formula on a chart. Thus instead of manually typing the slope or intercept into another equation you can simply use the formulas in Excel.

Download the notes in my video: https://1drv.ms/x/s!As32ynv0LoaIiMMBTdt6yJGv46c2sg?e=fZQthr

Related Videos:

ISERROR and ISERR Functions in Microsoft Excel: http://youtu.be/MrZLtpsLktM
Transparent Images in Microsoft Excel + Useful Tip: http://youtu.be/uKjtsQZ5Ow0
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI
Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec
Intro to Tables in Excel 2007: http://youtu.be/B_zXmunqrl4
Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4
Numbered Headings and Automated Table of Contents - Office Word 2007: http://youtu.be/e00xCQ0MClg
Microsoft Excel Tips: -22 = +4 and NOT -4!!!: http://youtu.be/9QC3ZboI3wo
Skip Blanks when Graphing in Microsoft Excel: http://youtu.be/HcCJVUd7a5Q
Automate Formulas using INDIRECT() Function in Excel: http://youtu.be/9WiBtrNq9yU .


SUBSCRIBE via EMAIL: https://mes.fm/subscribe

DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate

Like, Subscribe, Favorite, and Comment Below!

Follow us on:

Official Website: https://MES.fm
Hive: https://peakd.com/@mes
Gab: https://gab.ai/matheasysolutions
Minds: https://minds.com/matheasysolutions
Twitter: https://twitter.com/MathEasySolns
Facebook: https://fb.com/MathEasySolutions
LinkedIn: https://mes.fm/linkedin
Pinterest: https://pinterest.com/MathEasySolns
Instagram: https://instagram.com/MathEasySolutions
Email me: [email protected]

Try our Free Calculators: https://mes.fm/calculators

BMI Calculator: https://bmicalculator.mes.fm
Grade Calculator: https://gradecalculator.mes.fm
Mortgage Calculator: https://mortgagecalculator.mes.fm
Percentage Calculator: https://percentagecalculator.mes.fm

Try our Free Online Tools: https://mes.fm/tools

iPhone and Android Apps: https://mes.fm/mobile-apps


▶️ 3Speak



0
0
0.000
0 comments