Ask Your Question
0

automatically calculate straight line fit to data

asked 2018-08-07 21:52:04 +0200

pjpuchyr gravatar image

on chart, plot best straight line fit to data

edit retag flag offensive close merge delete

Comments

One way is to use the "xy (scatter)" type of diagram for your data. When choosing the type of line to join the points, instead choose a "trend" line and least-squares fit.

ve3oat gravatar imageve3oat ( 2018-08-07 22:42:28 +0200 )edit

@ve3oat: this is the answer, not a comment ;-)

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-08 07:07:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-08 20:27:28 +0200

ve3oat gravatar image

If you have plotted your data in an "xy (scatter)" type of chart :

Double click on the chart to enter Edit mode;

Right click on any data point;

In the dialog box, select Insert Trend Line;

In the dialog box, under Regression Type, select Linear;

Click OK.

Le voilà! You can edit the visual characteristics of the trend line and you might want to remove the lines that already join the different points.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-07 21:52:04 +0200

Seen: 386 times

Last updated: Aug 08 '18