Note that it doesn’t always make sense to interpret the intercept value in a regression equation.įor example, it’s not possible for a player to score negative points. For a player who practices zero hours, average points scored is expected to be -0.8929.
For each additional hour spent practicing, average points scored increases by 2.3095.The line of best fit along with the equation for the line will appear on the chart:įrom the chart we can see that the line of best fit has the following equation: In the Format Trendline panel that appears, click the button next to Linear as the trendline option, then check the box next to Display Equation on chart: Then click the arrow next to Trendline, then click More Options: To add a line of best fit to the scatter plot, click anywhere on the chart, then click the green plus (+) sign that appears in the top right corner of the chart. The following scatter plot will automatically be created: To do so, highlight the cells in the range A2:B9, then click the Insert tab along the top ribbon, then click the option titled Scatter in the Charts group: Next, let’s create a scatter plot to visualize the relationship between the two variables. Step 1: Enter the Dataįirst, let’s enter the following dataset that shows the number of hours spent practicing and the total points scored by eight different basketball players:
#MAKE A SCATTER PLOT WITH LINE OF BEST FIT HOW TO#
The following step-by-step example shows how to create a line of best fit in Excel.
In statistics, a line of best fit is the line that best “fits” or describes the relationship between a predictor variable and a response variable.
0 kommentar(er)
