How to get the equation of the plotted curve in Excel?

  • Thread starter Thread starter median27
  • Start date Start date
  • Tags Tags
    Curve Excel
Click For Summary
SUMMARY

The discussion focuses on obtaining the equation of a plotted curve in Excel without using trend lines, specifically utilizing the log-Pearson Type III Distribution. The user describes a method involving the manual entry of parameters into cells, calculating residuals, squaring them, and summing them to minimize the sum using Excel's Solver tool. This approach allows for fitting data points to a custom equation effectively, bypassing the need for built-in trend line functionalities.

PREREQUISITES
  • Excel Solver tool
  • Log-Pearson Type III Distribution knowledge
  • Understanding of residuals and least squares method
  • Basic Excel functions for calculations
NEXT STEPS
  • Learn how to use Excel's Solver for optimization tasks
  • Study the log-Pearson Type III Distribution in detail
  • Explore advanced Excel functions for statistical analysis
  • Research methods for calculating residuals in data fitting
USEFUL FOR

Data analysts, statisticians, and anyone looking to perform custom curve fitting in Excel without relying on trend lines.

median27
Messages
58
Reaction score
0
How can I get the equation of the plotted curve (see attachment) without using the trend line?
I've already fitted the random red points using the log-Pearson Type III Distribution (and the result is the blue curve) so I don't need to fit them anymore using any trend lines available in excel. Anyone? Thanks.
 

Attachments

  • log P.png
    log P.png
    8.7 KB · Views: 624
Physics news on Phys.org
Something I do in Excel is to put the parameters of whatever you are trying to fit into some cells. Then, calculate the residuals (the difference <your equation>-<the data>) into some more cells, where <your equation> is calculated from the parameters you entered. Square the residuals into some more cells. Sum them. Now apply Excel's solver to the parameters and the sum of the squares, trying to minimize the sum.
 

Similar threads

Analyzing Hysteresis Curve Fitting: Overfitting or Not?
  • · Replies 9 ·
Replies
9
Views
4K
Freemat - Plotting Two Curves on the same Plot
  • · Replies 1 ·
Replies
1
Views
2K
Mathematica - Plotting Two Curves on the same Plot
  • · Replies 1 ·
Replies
1
Views
1K
MATLAB Working out an equation on MATLAB using co-ordinates
  • · Replies 7 ·
Replies
7
Views
2K
Maple How can I fit a sigmoid line to data points using Excel or Maple?
  • · Replies 1 ·
Replies
1
Views
3K
Java Kotlin --> Plotting Two Curves on the Same Plot
  • · Replies 1 ·
Replies
1
Views
2K
How to Plot Multiple Data Series on a Single Excel Scatter Plot?
  • · Replies 3 ·
Replies
3
Views
2K
Fitting data to a Gaussian Distribution in Excel
  • · Replies 11 ·
Replies
11
Views
28K
Mathematica Coloring and legending issue
  • · Replies 1 ·
Replies
1
Views
3K
Mathematica Troubleshooting 'PlotLegend not showing' in Plot Function: Solutions & Examples
  • · Replies 4 ·
Replies
4
Views
4K