Page 267 - AI Ver 3.0 class 10_Flipbook
P. 267

xvi.  Choose Linear trendline.
                           xvii.  Select the Display Equation on Chart and Display R-squared Value on Chart checkboxes.
                                  This  displays  the  Linear  trendline,  Equation  (y  =  3.603x  –  10.835),  and  R-squared  Value

                                (R² = 0.5026) on the chart.






































                 Step 5   Perform Linear Regression Analysis
                          xviii.  Click on the Data Analysis option in the Data tab.
                                The Data Analysis window opens.

                          xix.    Select  the  Regression  option  under  the  Analysis

                                Tools list box in the Data Analysis window.
                          xx.   Click on the OK button.

                                The Regression window opens.
                          xxi.    Select the Distance column with header for the

                                Select Y Range option.
                          xxii.   Select  the  Speed  column  with  header  for  the

                                Select X Range option.
                          xxiii.   Select the Labels checkbox to include the column

                                names.
                          xxiv.   Specify the Output Range where you want the

                                regression results to be displayed.
                          xxv.  Click on the OK button.

                                 The  Summary Output  for  regression  statistics

                                displays in the worksheet.


                                                                                      Statisical Data (Practical)  265
   262   263   264   265   266   267   268   269   270   271   272