Excel table regression line how to make

Everyone in the use of office2010 to make Excel tables when you do not know how to make a return line Office2010excel table, in fact, the method is very simple Oh, Just open the Office2010excel form to enter the required regression data and then click on the scatter map to install the following steps can be made in a step-by-step process Oh, take a look.

Office2010excel table to make regression line method:

First step: Enter the data you want to return

Step Two: Click Insert, select Scatter plot.

Step three: After the scatter chart is selected, the chart appears and clicks on any point above. Then right-click and select Add Trendline.

Step fourth: Pop Up a window, select the two options shown by the arrow in the window, and you must select the two options to see the correlation between the data.

Fifth step: Click the grid line in the icon, right button, select Delete

Sixth step: A regression line is complete, if the chart is not very beautiful, you can drag, change its size.