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
Смотрите видео Calculate Slope and Intercept in Excel (Formula + Scatter Chart Technique) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TrumpExcel 10 Август 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42,070 раз и оно понравилось 295 людям.