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

