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]]