Calculate Slope and Intercept in Excel (Formula + Scatter Chart Technique)
In this video, I will show you two really easy ways to calculate slope and intercept in Excel.
There are inbuilt SLOPE and INTERCEPT formula that instantly gives the result, and you can also get the equation (y = mx + b) by adding a trendline in a scatter chart.
00:00 Intro
00:10 Calculate SLOPE and INTERCEPT using formulas
01:46 Calculate SLOPE and INTERCEPT using Scatter Chart Trendline
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial
Watch video Calculate Slope and Intercept in Excel (Formula + Scatter Chart Technique) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 10 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 42,070 once and liked it 295 people.