How can I fit a sigmoid line to data points using Excel or Maple?

In summary, fitting a trendline to data points involves using statistical software or programming languages such as Excel, R, or Python. The purpose of fitting a trendline is to visually represent the overall trend in the data and identify patterns or correlations between variables. The best type of trendline depends on the type of data and the relationship between variables. A trendline can be used to make predictions about future data points, but with caution. The accuracy of the trendline can be affected by factors such as data quality, type of trendline used, assumptions made, outliers, missing data, and changes in the underlying relationship between variables.
  • #1
Supfresh
4
0
Hi

I used plot digitizer software to pull data points off a picture of a graph and i need to fit a line to the points (and get an equation for the line). I know the data points fit to an s-curve from the picture. I'm thinking excel doesn't do this, or maybe I missed it?

I have access to maple, can this do s-curves?

thanks in advance
 
Last edited:
Physics news on Phys.org
  • #2
Google

Excel fit sigmoid

to find 585000 hits and it looks like you should find what you need to do there
 

1. How do I fit a trendline to my data points?

To fit a trendline to your data points, you can use a statistical software or programming language such as Excel, R, or Python. These tools have built-in functions or packages that allow you to easily plot a trendline on your data.

2. What is the purpose of fitting a trendline to data points?

The purpose of fitting a trendline to data points is to visually represent the overall trend or pattern in the data. It can help identify any patterns or correlations between the variables in your data.

3. How do I choose the best type of trendline for my data?

The best type of trendline to use depends on the type of data you have and the relationship between your variables. Linear trendlines are best for data that follows a straight line, while exponential, logarithmic, or polynomial trendlines are better for data that follows a curve.

4. Can I use a trendline to make predictions about future data points?

Yes, a trendline can be used to make predictions about future data points, but it should be done with caution. The accuracy of the predictions depends on the reliability of the data and the assumptions made when fitting the trendline.

5. What factors can affect the accuracy of a trendline?

The accuracy of a trendline can be affected by the quality of the data, the type of trendline used, and the assumptions made when fitting the trendline. Other factors such as outliers, missing data, and changes in the underlying relationship between variables can also impact the accuracy of the trendline.

Similar threads

Which software to use to create this graph?
    • MATLAB, Maple, Mathematica, LaTeX
Replies
3
Views
141
Analyzing Hysteresis Curve Fitting: Overfitting or Not?
    • MATLAB, Maple, Mathematica, LaTeX
Replies
9
Views
1K
MATLAB Troubleshooting Best Fit Line and Distance Calculation in MATLAB
    • MATLAB, Maple, Mathematica, LaTeX
Replies
14
Views
2K
MATLAB Forcing the best fit line to pass through a certain point (Octave)
    • MATLAB, Maple, Mathematica, LaTeX
Replies
12
Views
5K
MATLAB Weighting data points with fitted curve in Matlab
    • MATLAB, Maple, Mathematica, LaTeX
Replies
6
Views
3K
MATLAB To what extent is the fit to experimental data good?
    • MATLAB, Maple, Mathematica, LaTeX
Replies
12
Views
3K
GNUplot -- how to improve image definition?
    • MATLAB, Maple, Mathematica, LaTeX
Replies
6
Views
2K
Data analysis by guessing, checking and fixing
    • STEM Educators and Teaching
Replies
5
Views
654
Mathematica [Mathematica] How to use for loop to process a list of data
    • MATLAB, Maple, Mathematica, LaTeX
Replies
6
Views
2K
Fitting data to a Gaussian Distribution in Excel
    • MATLAB, Maple, Mathematica, LaTeX
Replies
11
Views
26K

Hot Threads

Recent Insights

Back
Top