Click here to Skip to main content
15,902,198 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a set of 2D coordinates(in an Excel Spreadsheet), from which I need to draw best fit lines/curves. I have to design a windows application in Visual Basic which will get the points from the spreadsheet and draw best fit curves. Can anyone please help me how to start this project, what libraries I might use and what things to keep in mind.

What I have tried:

I have no idea how to include graphics in VB. I have previous experience in VB, where I designed minor applications like calculator.
Posted
Updated 20-Dec-17 18:20pm
v2

Your question is a bit vague. For instance, what kind of regression do you need to use?
Note Excel does provide tools for best fit curves, see, for instance: Excel: Fitting curves to your data using least squares[^].
If you really need to compute least squares using VB.NET, then you will find many examples on the web, just Google for[^].
 
Share this answer
 
Quote:
I have a set of 2D coordinates(in an Excel Spreadsheet), from which I need to draw best fit lines/curves.

Do you know that Excel can plot your data?
And Excel have a feature to do curve fitting to your data, it is in Excel for 20+ years.
 
Share this answer
 
i have a set of 2d coordinates. I want to plot the points on a graph, the draw a best fit curve, and also get the equation of the curve.
 
Share this answer
 
Comments
Richard Deeming 20-Dec-17 12:09pm    
If you want to reply to a solution, click the "Have a Question or Comment?" button under that solution.

DO NOT post your reply as a new "solution".
Patrice T 21-Dec-17 0:12am    
Use button "Have a Question or Comment?" under a solution to talk with author.
Advantage, the author get noticed.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900