Page 331 - AI Ver 3.0 Class 11
P. 331
Next, to get the Regression Equation, click on Add Chart Element → Trendline → More Trendline Options. A
Format Trendline dialogbox will open on the right. Click on Display Equation on Chart checkbox..
You will get the Regression Equation on the chart as follows:
Marks (y)
120
100
y = 2.8076x + 57.764
80
60
40
20
0
0 1 2 3 4 5 6 7 8 9 10
Step 3: You can also calculate the value of slope by using the slope function in Excel. Click on any cell, and
type =slope((select all y values) , (select all x values). Press enter key to see the answer.
Step 4: You can also calculate the value of intercept by using the intercept function in Excel. Click on any cell, and
type =intercept ((select all y values) , (select all x values). Press enter key to see the answer.
Using the regression equation, we can calculate predicted values of y using any values of x.
Machine Learning Algorithms 329

