# How can I change the variable letters in a trendline equation? [closed] 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 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.

Sort by » oldest newest most voted 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.

more