I am looking for a specific graphing software that can take in values for X axis and Y axis and then output a best fit curve.

By using Excel 2010, I am able to output this nice curve:

example graph 1

However, I want the points to be connected by a curve like this:

example graph 2

Are there any graphing softwares out there, free or paid (as long as they have free trial or free demo), that will allow me to get a best fit curve like in the 2nd picture not like the 1st one without manually inputting the equation to plot the curve?

I have tried using Graph 4.4.2, Geogebra, Graphical Analysis and TI-Nspire student software but I couldn't quite get the curve I want. Maybe I am not doing the right way?

  • If you have a MATLAB licence you can do it easily with the built-in function interp1 (it.mathworks.com/help/matlab/ref/interp1.html). You can choose the properties of the lines to get the best result.
    – user19124
    Nov 28 '15 at 17:49
  • Hmmm... those are two different curves that can both approximate the same data set (given the data points provided). However, given the first data point, the first curve is more accurate. No matter the application, you'll have to provide the application with more data or parameters to generate the second curve. Nov 28 '15 at 23:02

The software that I've used in the past to come up with best-fit curves is LoggerPro by Vernier. It's really powerful and has many different options. It should be able to calculate an equation of the best fit curve (if you give me the data, I can try it now). LoggerPro does have a demo here along with a lite version, Logger Lite.

Logger Pro (commercial w/ demo)

  • Auto-ID sensors make setup effortless.
  • Collect live data from more than 80 different sensors and devices.
  • Draw predictions on a graph before collecting data.
  • Use a variety of data-collection modes, as needed, for your experiment: time-based data, selected events, events with typed-in entries, photogate, radiation counting, and more.
  • Manually enter data for graphing and analysis.
  • Import data from Vernier interfaces.
  • Layout graphs, tables, and text as needed across multiple pages to describe your experiment.
  • Read values and slope from graphs using examine and tangent line tools.
  • Print graphs and data tables.

Logger Pro GUI

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.