[R] Excel can do what R can't?????

[Spencer Graves]

For "lexical scoping", read some of the better documentation on R.  At 
minimum, check "www.r-project.org" -> search -> "R site search".

spencer graves

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?
> 
> Mike
>