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.
I believe the asker wants to do something like change the equation to “g(t) = 3.11t + 0.038” instead.
See: Trend Lines
Default equation uses
x
for abscissa variable, andf(x)
for ordinate variable. To change these names, select the trend line, choose Format - Format Selection – Type and enter names inX Variable Name
andY Variable Name
edit boxes.
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.