2. Then use the mouse to select these data and click the "Insert" option in the menu bar.

3. Then in the Insert menu, select a scatter plot, as shown.

4. Then right-click the scatter points in the chart and click Add Trend Line in the right-click menu.

5. Then, in the page that appears, select "Linear", select the "Show Formula" option, and close the window.

6. After the above settings are completed, you can use excel to make a linear diagram.

Precautions:

A chart showing the correlation between two variables in a rectangular coordinate system. In industrial production and scientific research, the relationship between two quantities is often encountered: one is that the relationship between the two quantities is completely determined; The other is that the corresponding relationship between the two quantities is not completely determined. For this kind of relationship that is both relevant and not completely certain, it is called correlation.

People use the method of drawing correlation diagram and finding correlation coefficient to determine the correlation between two quantities, which is called correlation analysis. When the correlation is determined, the method of judging the correlation coefficient and finding the regression equation through statistical test and estimation is called regression analysis.