Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Re:mixed exponential model fit (1 viewing) (1) Guest
You can request specific calculations in this area. Hopefully someone in the ExcelCalcs community can help.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:mixed exponential model fit
#164
mark mackay (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
mixed exponential model fit 1 Year, 1 Month ago Karma: 0  
does anyone have code for fitting a mixed exponential distribution?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#167
DaveCwork (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Re:mixed exponential model fit 1 Year, 1 Month ago Karma: 10  
Not sure if I totally understand the request but if you are looking for nonlinear regression tools "nonlin" is a good application to use.
http://archives.math.utk.edu/software/msdos/statistics/nonlin25/.html

The application is pretty old and runs in dos mode using a text file (with a .nlr extension) to contain the data and the problem definition.

to use I would copy one of the example .nlr files, open in a text editor and then change the parameters and equations to suit. The input data can be copied and pasted directly into the file from excel.

to run you can either enter the directory in the dos shell and type the following:-

nonlin datafit

(where your problem definition and data file is contained in a file called "datafit.nlr&quot

The results should appear in "datafit.lst"... but if they are displayed on the screen you should be able to pipe them to file by using the command

nonlin datafit > datafit.lst


or you can create a batch file and run it from there (see &quot;demo.bat&quot<br><br>Post edited by: DaveCwork, at: 2007/04/18 14:06
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#177
mark mackay (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:mixed exponential model fit 1 Year ago Karma: 0  
Dave, thanks for the response.

To give you more info, I have a data set that has an exponential distribution. I want to fit a mixed exponential equation to it. I can do this in other packages, but these packages are not widely available outside of the research area for a variety of reasons, including cost. However, excel is widely available. While fitting such curves to this data might be more &quot;clumsy&quot; in excel, I believe it's doable and would facilitate the use of research that relies upon the use of the exponential distribution parameters.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#178
BillyNoMates (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:mixed exponential model fit 1 Year ago Karma: -2  
I am not sure quite what you are after but will XlXtrFun™ Extra Functions for Microsoft Excel be any use to you?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#186
mark mackay (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:mixed exponential model fit 1 Year ago Karma: 0  
Many thanks BillyNoMates - have downloaded and will have a look at it.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply