It finds the slope value of a given set of x-y coordinates in one step. The easiest way to calculate slope in Excel is to use the in-built SLOPE function. Thankfully, Excel has a formula for that as well, and I will cover how to calculate intercept in all the methods. In this equation, we have already calculated the slope, but to truly know what would be the Y value for a given X value, you also need to know the intercept. Let me explain it with the equation: Y = Slope*X + Intercept So if the height increases by 1 centimeter, the income is likely to increase by USD 138.Īpart from the slope, another thing you need to know about is the Intercept. In our example, if the slope value is 138, which means that there is a positive correlation between height and the income of people. The slope value can be positive or negative.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |