Sumit.Gupta at ubs.com
2007-Oct-09 09:55 UTC
[R] Using Rexcel: How to work with a range of data?
Hi,
I am trying to use an R function over a column of data I have in my
excel spreadsheet. I do the following:-
1) assign an object (calling it xaxis) to the data by typing in
=Rput("xaxis",a1:a10), where my data is shown in cells
a1:a10
Now I wish to arrive at the mean of these numbers and am doing the
following in another cell:-
=Rapply("mean","xaxis")
This does not work. Neither does
=Rapply("mean",Reval("xaxis")) work? Is
there any other way to make an R function work over data stored in an
excel column? Or could I be doing something worng?
Sumit
[[alternative HTML version deleted]]
