Re: [R] How to adjust plot size?

I'm not sure what part of the process is giving you trouble, but if you play around with the mar part of the code, you get a lot of flexibility over the margins. Also, if you pre-set the dimensions of the window the plot is created in, you get even more control. E.g. x11(width=9, height=6,

Re: [R] how to use Excel VBA's Shell() to call and execute R file

Hi KZ, I don't think that I can answer what I think is the precise question - how to run the R file from VBA but without using RExcel. However with RExcel installed, I have found it very straightforward to run R code from within VBA (thanks Erich Neuwirth - RExcel is great). The VBA code is:

Re: [R] Problems getting symbols() to show table data

Thanks. I don't think I would ever have worked that twist out. It is perfect. Guy -- View this message in context: http://n4.nabble.com/Problems-getting-symbols-to-show-table-data-tp1839676p1989384.html Sent from the R help mailing list archive at Nabble.com.

Re: [R] run R script from Excel VBA

See RExcel, http://rcom.univie.ac.at/ http://rcom.univie.ac.at/ and especially the video demo http://rcom.univie.ac.at/RExcelDemo/ http://rcom.univie.ac.at/RExcelDemo/ Guy -- View this message in context: http://n4.nabble.com/run-R-script-from-Excel-VBA-tp2009478p2011942.html Sent from the

Re: [R] Problems getting symbols() to show table data

Thanks, balloonplot() is great and gets me really close to what I am after. However it then brings me to a slightly different problem - I wonder if anyone can suggest where I am going wrong? Again with simplified data ( http://n4.nabble.com/file/n1890724/test-data.txt test-data.txt ):

[R] Problems getting symbols() to show table data

Hello, I am trying to create a graphic to help me visualise data. A (very simplified) sample of the data is http://n4.nabble.com/file/n1839676/circle_data.txt circle_data.txt : Aug-07 Nov-07 Feb-08 data1 1 1.5 -1 data2 1

[R] Help with Hmisc, cut2, split and quantile

Hello, I have a set of data with two columns: Target and Actual. A http://n4.nabble.com/file/n1584647/Sample_table.txt Sample_table.txt is attached but the data looks like this: Actual Target -0.125 0.016124906 0.135 0.120799865 ... ... ... ... I want to

Re: [R] Help with Hmisc, cut2, split and quantile

/n1585427/Sample_table.txt Sample_table.txt . Thanks, Guy Peter Ehlers wrote: On 2010-03-08 8:47, Guy Green wrote: Hello, I have a set of data with two columns: Target and Actual. A http://n4.nabble.com/file/n1584647/Sample_table.txt Sample_table.txt is attached but the data looks like

[R] Alternatives to linear regression with multiple variables

I wonder if someone can give some pointers on alternatives to linear regression (e.g. Loess) when dealing with multiple variables. Taking any simple table with three variables, you can very easily get the intercept and coefficients with: summary(lm(read_table)) For obvious reasons, the

Re: [R] How to detect and exclude outliers in R?

I had a similar problem. In my case, I had a large table of data and wanted to find and exclude a single huge value in one column (i.e. remove the entire row). There were thousands of rows of data, and this single value was more than 3x the next value, and at least 30x the typical value. I

[R] Manipulating data, and performing repeated simple regressions, not multiple regression

I have a simple table of data: ResultVar1Var2Var3 1 0.100.780.120.38 2 0.200.660.390.12 3 0.100.830.090.52 4 0.150.410.630.95 5 0.600.880.910.86 6 -0.020.140.690.94 I am trying to achieve two