How do I update an equation based upon the regression equation in a graph?
I am using some graphs which update with new data put in, and I am using the regression line equation from said graph to calculate some other values. Right now, I have to readjust the formula every time I put in new data, and manually delete the "x" from the regression equation and place in cell references. Any ideas?
Posted Dec 29, 2011, 1:47 AM UTC
26