[R] i need same function solver in excel..

Gabor Grothendieck ggrothendieck at gmail.com
Wed Jul 8 06:07:26 CEST 2009


Check out the Optimization Task View:

http://cran.r-project.org/web/views/Optimization.html

On Wed, Jul 8, 2009 at 12:00 AM, leecholho<rokmn3309 at hotmail.com> wrote:
>
>
> thanks...
>
> i do homework..  my professor said , to use slover function in excel.
> but i used R , so i want to find same function.
>
> question is " Max(x,y)  x*E(R.a) + y*E(R.b)" , and x+y=1,
> E(R.a) and E(R.b) is average of the special data..
>
> special data is this
>        -------------------------------
>         Nippon Steel Corp
>        -------------------------------
>                 E(R)            = 4.65752
>                 V(R)            = 99.05973
>                 sqrt(V(R))      = 9.95288
>        -------------------------------
>         Chubu Electric
>        -------------------------------
>                 E(R)            = 2.19316
>                 V(R)            = 40.42778
>                 sqrt(V(R))      = 6.35828
>        -------------------------------
>         TDK Corporation
>        -------------------------------
>                 E(R)            = 1.10754
>                 V(R)            = 24.24186
>                 sqrt(V(R))      = 4.92360
>
>
>> Date: Tue, 7 Jul 2009 20:48:51 -0700
>> From: m_olshansky at yahoo.com
>> Subject: Re: [R] i need same function solver in excel..
>> To: rokmn3309 at hotmail.com
>>
>>
>> Can you be a bit more specific?
>>
>> --- On Wed, 8/7/09, leecholho <rokmn3309 at hotmail.com> wrote:
>>
>> > From: leecholho <rokmn3309 at hotmail.com>
>> > Subject: [R] i need same function solver in excel..
>> > To: r-help at r-project.org
>> > Received: Wednesday, 8 July, 2009, 1:42 PM
>> >
>> > hi..
>> >
>> > i used R a few days..
>> >
>> > who can call me? same function solver in excel.
>> >
>> > _________________________________________________________________
>> > [[elided Hotmail spam]]
>> >     [[alternative HTML version deleted]]
>> >
>> > ______________________________________________
>> > R-help at r-project.org
>> > mailing list
>> > https://stat.ethz.ch/mailman/listinfo/r-help
>> > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> > and provide commented, minimal, self-contained,
>> > reproducible code.
>> >
>
> _________________________________________________________________
> [[elided Hotmail spam]]
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>




More information about the R-help mailing list