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 –

✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:

Subscribe to get awesome Excel Tips every week:

#Excel #ExcelTips #ExcelTutorial

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

5/5 - (1 bình chọn)

Bài viết liên quan

Theo dõi
Thông báo của
guest
0 Comments
Phản hồi nội tuyến
Xem tất cả bình luận