[R] Excel can do what R can't?????
spencer.graves at pdf.com
Thu Jul 17 11:28:36 CEST 2003
For "lexical scoping", read some of the better documentation on R. At
minimum, check "www.r-project.org" -> search -> "R site search".
Michael Rennie wrote:
> Quoting "Roger D. Peng" <rpeng at stat.ucla.edu>:
>>I'm having a little difficulty understanding this thread. If Excel can
>>do the job correctly and suits your needs, why not just use Excel?
> Primarily because I don't know how to automate this in excel. The reason for
> me doing this is I eventually need it to go through 1000 rows of input
> variables so that I can get output with error associated with it. Plus, people
> think your cool if you can do it in R.
>>As far as I know, 'optim' cannot optimize a function subject to
>>arbitrary equality constraints. The 'constrOptim' function allows for
>>linear inequality constraints but in general, you will either have to
>>reformulate the problem or add your own penalty into the objective
>>function. Also, just a small note, but using lexical scoping in your
>>problem would eliminate the need to have all those variables defined in
>>the global environment (but otherwise it won't change anything).
> What's lexical scoping?
More information about the R-help