Discussion Re: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ? in Excel
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3447625#M148688
<BR />My objective is very simple. I used the scatter plot for my data set. Got the S shaped curve (shown in figure above). I just want to do curve fitting with these data sets using Weibull or Pseudologistic or sigmoidal function. I am not from mathematics background so i don't understand your question. Sorry for that<BR />Tue, 31 May 2022 05:43:19 GMTAnkit272022-05-31T05:43:19ZHow to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3385044#M146692
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Data of a Participant" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/372234iFC1CFA549632D81C/image-size/large?v=v2&px=999" role="button" title="Amit_data.png" alt="Data of a Participant" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Data of a Participant</span></span></P><P> </P><P>Hi Everyone,</P><P>I want to ask how i can do curve fitting of this scatter plot (both graphs). I tried using the option of <STRONG>Trendline</STRONG> but it is showing very few options like exponential, linear, polynomial, logarithmic, power etc. I don't need to use these curve fitting function, rather I need to do curve fitting with <STRONG>Weibull, Pseudo logistic and Sigmoidal functions with max R square value. Please help me out with this how i can implement these mentioned functions in excel. </STRONG></P><P><STRONG>Thanks in advance !!!</STRONG></P>Tue, 17 May 2022 07:41:02 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3385044#M146692Ankit272022-05-17T07:41:02ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3394747#M146964
Please Help me out with thisWed, 18 May 2022 16:22:54 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3394747#M146964Ankit272022-05-18T16:22:54ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3396071#M146995
<P>Pretty sure I can help out if I know to what your objective is. E.g., are you planning to generate random variates from the fitted distributions? IF you simply want to interpolate, you could always do a cubic spline fit, for which I can post code (not sure if I can do that in this forum). Don't use code I posted years back!</P><P>Why not use the moments of your data to derive your parameters if you want to stick with parametric models?</P><P> </P>Wed, 18 May 2022 20:26:20 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3396071#M146995David_Braden2022-05-18T20:26:20ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3397620#M147048
See also <A href="https://staff.washington.edu/glynn/r2pseudo.pdf" target="_blank">https://staff.washington.edu/glynn/r2pseudo.pdf</A>Thu, 19 May 2022 05:22:05 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3397620#M147048David_Braden2022-05-19T05:22:05ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3447625#M148688
<BR />My objective is very simple. I used the scatter plot for my data set. Got the S shaped curve (shown in figure above). I just want to do curve fitting with these data sets using Weibull or Pseudologistic or sigmoidal function. I am not from mathematics background so i don't understand your question. Sorry for that<BR />Tue, 31 May 2022 05:43:19 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3447625#M148688Ankit272022-05-31T05:43:19ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3461232#M149077
<P><LI-USER uid="1390626"></LI-USER> </P><P>Ok, it seems you want econometric models, for which you will probably need to use maximum likelihood to calculate the parameters of the distributions. Not that it can't be done in Excel, but I don't remember how to go about fitting the logistic function to the data (and the logistic IS sigmoidal, so I don't understand part of your question). But this isn't an Excel issue, but one of econometrics (or biostatistics, ...). You'll have better luck getting a book on the subject and finding a user group on, say, usenet, replete with statisticians.</P><P>I asked for your objective in order to get an idea of the intended use for your curve-fits. There are so many criteria that determine what you even mean by a fit. Some objectives - say Monte Carlo simulation - even obviate the need for a fit.</P><P>When posting, explain the axes; are you looking for, say,how the probability of the cream being useful varies with time of application? That points towards the logistic (aka logit) model; I don't see how the Weibul comes into the picture, which isn't to say it doesn't.</P><P>Excel's trendline/regression routines are using ordinary least squares for the fits. You cannot adapt them to what you stated you wanted: again, someone who knows statistics well will almost certainly recommend maximizing the likelihood (in this case the log-likelihood) of your data, which by the way seem overly aggregated for the task.</P><P>There are other ways to "fit a curve" that are nonparametric and might be more useful. Posting your intended use of the curve will make answering your question easier.</P><P>Groups dealing with R (the language) might be the first place to look. Given the breadth of topics on Usenet, there are probably groups just devoted to statistics. Worth a look. You could also try a local university: a lot of marketing professors and economists are well-versed in the use of the logit model, among others. And perhaps try Redit?</P><P>Hope this helped.</P>Thu, 02 Jun 2022 16:52:37 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3461232#M149077David_Braden2022-06-02T16:52:37ZRe: How to do curve fitting with Weibull, Pseudo logistic and Sigmoidal functions in Excel ?
https://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3461234#M149078
There isn't (AFAIK) a pseudo logistic curve. You might be referring to a logistic curve-fit that includes a pseudo R-square. The fit is still maximum-likelihood.Thu, 02 Jun 2022 16:57:01 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-do-curve-fitting-with-weibull-pseudo-logistic-and/m-p/3461234#M149078David_Braden2022-06-02T16:57:01Z