ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get standard errors from the Solver results ? (https://www.excelbanter.com/excel-discussion-misc-queries/125326-how-get-standard-errors-solver-results.html)

Euh

How to get standard errors from the Solver results ?
 
Hi there,

hope someone can help.

I'm using the Excel Solver to find the parameters (A,B,C,D) of a
logistic equation:

y= A/(exp(B*t)+C*exp(-D*t) )

How can I compute in Excel the standard error of the estimated
parameters ?


Dave F

How to get standard errors from the Solver results ?
 
Standard deviation can be found using either the function STDEV or STDEVP,
the latter of which calculates the standard deviation of a population as
opposed to a sample.

Is that what you're looking for?
--
Brevity is the soul of wit.


"Euh" wrote:

Hi there,

hope someone can help.

I'm using the Excel Solver to find the parameters (A,B,C,D) of a
logistic equation:

y= A/(exp(B*t)+C*exp(-D*t) )

How can I compute in Excel the standard error of the estimated
parameters ?




All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com