Is it possible to get a “best-fit” curve using Excel? By best fit curve, I mean a curve (in this case a straight line) that does not connect all the dots but instead is drawn so as to follow the general trend and keep as many values as possible near the line.
Everytime I try to do this kind of line, the Excel program just connects all the dots, making a crooked line. This is not what I need, can any of you give me any help? Thanks.