Graphical steps for creating a regression line in Microsoft Office 2010

Time: 2019-12-25Source: Huajun Software TutorialAuthor: Aotuman

Microsoft Office 2010 is a commonly used office software that attracts many partners. So does everyone know how to create a regression line in Microsoft Office 2010? If you still don’t understand the relevant operations, then take a look at the graphic steps for creating a regression line in Microsoft Office 2010.

1: Enter the data you want to return

How to create a regression straight line in office 2010 Excel table?

2: Click Insert and select Scatter Plot

How to create a regression straight line in Office 2010 Excel table?

Three: After selecting the scatter chart, the chart will appear, click on any point on it. Right-click and select Add Trendline.

How to create a regression straight line in office 2010 Excel table?

Four: A window will pop up. Select the two options indicated by the arrows in the window. You must select these two options to see the correlation between the data.

How to create a regression straight line in Office 2010 Excel table?

Five: Click on the grid line in the icon, right-click and select Delete

How to create a regression straight line in Office 2010 Excel table?

Six: A regression line is completed. If the chart is not very beautiful, you can change its size by dragging it.

How to create a regression straight line in Office 2010 Excel table?

Dear friends, after reading the above exciting content, you all know how to create a regression line in Microsoft Office 2010!

Related articles更多>>

Popular recommendations