Ask Your Question

How can I change the variable letters in a trendline equation? [closed]

asked 2014-10-06 03:11:45 +0200

Shdow gravatar image

updated 2020-07-27 11:19:33 +0200

Alex Kemp gravatar image

Right now my equations reads: f(x) = 3.11x + 0.038, however I need to change f(x) and x to different variables. This is in the Calc Spreadsheet.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 19:20:37.526759


I believe the asker wants to do something like change the equation to "g(t) = 3.11t + 0.038" instead.


Default equation uses x for abscissa variable, and f(x) for ordinate variable. To change these names, select the trend line, choose Format - Format Selection – Type and enter names in X Variable Name and Y Variable Name edit boxes.

ahiijny gravatar imageahiijny ( 2018-11-08 21:10:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-10-06 08:32:37 +0200

ROSt52 gravatar image

In a spreadsheet F(x) and x refer to cells. Thus, if you change the cells the values will change.

e.g. A1, 2, 3, 4, 5,... contains the x values B1, 2, 3, 4, 5,... contains the F(x) values, which means for the first row B1 contains "=3.11*A1+0.038" Now you can replace the A1, 2, 3, 4, .... with other cells and can place the related formula into other cells as well.

edit flag offensive delete link more

Question Tools



Asked: 2014-10-06 03:11:45 +0200

Seen: 1,308 times

Last updated: Oct 06 '14