Which of the following sample correlation coefficients shows the strongest association between X and Y?
A simple linear regression line represents the line that best “fits” a dataset. Show This tutorial provides a step-by-step example of how to quickly add a simple linear regression line to a scatterplot in Excel. Step 1: Create the DataFirst, let’s create a simple dataset to work with: Step 2: Create a ScatterplotNext, highlight the cell range A2:B21. On the top ribbon, click the INSERT tab, then click INSERT Scatter (X, Y) or Bubble Chart in the Charts group and click the first option to create a scatterplot: The following scatterplot will appear: Step 3: Add a Regression LineNext, click anywhere on the scatterplot. Then click the plus (+) sign in the top right corner of the plot and check the box that says Trendline. This will automatically add a simple linear regression line to your scatterplot: Step 4: Add a Regression Line EquationYou can also add the equation of the regression line to the chart by clicking More Options. In the box that appears to the right, check the box next to Display Equation on chart. The simple linear regression equation will automatically appear on the scatterplot: For this particular example, the regression line turns out to be: y = 0.917x + 12.462 The way to interpret this is as follows:
We can also use this equation to estimate the value of y based on the value of x. For example, when x is equal to 15, the expected value for y is 26.217: y = 0.917*(15) + 12.462 = 26.217 Find more Excel tutorials here.
|