Curve Fit Q: Balancing 1+m1*log(x) & 4.5+m2*log(x)

  • Context: Undergrad 
  • Thread starter Thread starter mikewinifred
  • Start date Start date
  • Tags Tags
    Curve Fit
Click For Summary
SUMMARY

The discussion focuses on fitting a third curve to balance two existing curves defined by the equations 1+m1*log(x) and 4.5+m2*log(x). The user is attempting to minimize the error between these curves and the new curve using Excel, specifically with the equation format a+b*log(x). Suggestions include incorporating a negative exponential component to achieve a better fit. The user seeks guidance on achieving an initial reduced slope for the third curve.

PREREQUISITES
  • Understanding of logarithmic functions and their properties
  • Familiarity with curve fitting techniques in Excel
  • Knowledge of error minimization methods in data analysis
  • Basic grasp of exponential functions and their applications
NEXT STEPS
  • Research advanced curve fitting techniques in Excel, including the Solver tool
  • Learn about incorporating exponential terms in regression models
  • Explore the use of statistical software like R or Python for curve fitting
  • Study error analysis methods to evaluate curve fitting accuracy
USEFUL FOR

Data analysts, statisticians, and anyone involved in mathematical modeling or curve fitting who seeks to optimize the balance between multiple data sets.

mikewinifred
Messages
8
Reaction score
0
I have two curves 1+m1*log(x) and 4.5+m2*log(x) [please see the attached picture]. I want to fit a third curve (which might of any equation), which should actually 'balance' the first two curves, so that the error is minimum. My problem is I am not able to get a initial reduced slope in the third curve when I try to fit with an eqn (in excel) of form a+b*log(x). I have a feeling like adding a negative exponential or something similar to that with eqn of form a+b*log(x) we might arrive at a curve similar to curve 3 [please see the attached picture]. Any suggestions? Thanks guys.
 

Attachments

  • curveFit.png
    curveFit.png
    13.9 KB · Views: 506
Mathematics news on Phys.org
mikewinifred said:
I have two curves 1+m1*log(x) and 4.5+m2*log(x) [please see the attached picture]. I want to fit a third curve (which might of any equation), which should actually 'balance' the first two curves, so that the error is minimum. My problem is I am not able to get a initial reduced slope in the third curve when I try to fit with an eqn (in excel) of form a+b*log(x). I have a feeling like adding a negative exponential or something similar to that with eqn of form a+b*log(x) we might arrive at a curve similar to curve 3 [please see the attached picture]. Any suggestions? Thanks guys.
What do you mean by "balance" the first two curves? And what error are you talking about?
 

Similar threads

Graduate Find a curve that fits this data please
  • · Replies 6 ·
Replies
6
Views
2K
Graduate Modified least squares fitting?
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad Fitting a curve in log-linear plot.
  • · Replies 6 ·
Replies
6
Views
4K
Finding the Parameters for the Curve y=asin(x-b)+c
  • · Replies 11 ·
Replies
11
Views
4K
Graduate Strange result from taking logs of logs in experimental data
  • · Replies 6 ·
Replies
6
Views
2K
Undergrad Pressure delta 1.0 bar: 0.0 to 1.0 vs 1.0 to 2.0
  • · Replies 10 ·
Replies
10
Views
2K
Sinusoidal fit with some points fixed
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Fitting two models in sequence with parameters in common
  • · Replies 12 ·
Replies
12
Views
3K
Undergrad Slope of LS line = Cov(X,Y)/Var(X). Intuitive explanation?
  • · Replies 1 ·
Replies
1
Views
5K
Using Mathematica to plot and fit data
  • · Replies 3 ·
Replies
3
Views
2K