I have a CSV with me consisting of a few x-y coordinates. How can I form an equation for the graph using these points?
Asked
Active
Viewed 44 times
0
-
1Least squares regression (Assuming this is real data and not specifically picked as the points of a well-known function). – J P Oct 08 '19 at 01:15
-
@JackPfaffingerDoes least squares work for non linear data? – NoLand'sMan Oct 08 '19 at 02:14
-
1Yes, you can look up "Polynomial least squares" if you care about the theory. Otherwise, your options are to put it into Excel or Google Sheets and find a regression option. There are some numpy methods that can do this as well if you can program. – J P Oct 08 '19 at 02:19
-
Alright Cool, thanks! – NoLand'sMan Oct 08 '19 at 02:43
1 Answers
0
If you do an xy plot in a spreadsheet you can ask it to add trendline. You have a choice of linear, polynomial, log, or exponential. You can then format trendline and ask it to show the equation.
Ross Millikan
- 374,822