Also, how do I get it to show me the equation of this line?
2006-09-06 13:19:09 · 3 answers · asked by otexasgirlo 3 in Entertainment & Music ➔ Other - Entertainment
If you have a line charted in Excel, just right-click on it and choose Add Trendline. Then you can right-click on the trendline and choose Options... | Show equation in chart.
You can even extend the line from the Options dialog box to "predict" the future.
2006-09-06 16:20:37 · answer #1 · answered by O Caçador 6 · 1⤊ 0⤋
A regression line is basically a line that goes from the upper left corner to the lower right corner (basically, a business that isn't doing too well...)
You can make one by entering data on different cells that go from 10 to 1, select these cells and then use the options to generate a graph.
2006-09-06 13:26:17 · answer #2 · answered by germ 2 · 0⤊ 0⤋
Regression line. Try "slope". Just list columns of Xs and Ys highlight both of them and push "Chart". Then make your choices. (try scatter) Thats all I remember.
2006-09-06 13:24:51 · answer #3 · answered by lil'oleJewler 2 · 0⤊ 0⤋