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
   326   327   328   329   330   331   332   333   334   335   336