search for: excelsheet

Hello I have to solve a multiple linear regression. Most programs like Excel or Mathlab only support 5-10 dimensions. Now I have installed CRAN and I have no clue what to do next. At the moment I am entering my data into an excelsheet (for quick copy- paste). The Y-array will be 20 columns (=dimensions) and 128 rows (=variables). The X-array may also be 128 rows in Excel. Which package do I need - or does it work without any package? What commands do I have to enter? I'm not familiar with CRAN and I didn't find any exa...

...Excel data area - values which cannot be converted become NA (for double it was NaN before) o write.xls - naStrings the DEFAULT CHANGES from NA to '', i.e. cells will be cleared o read.xls/write.xls - rows/cols arguments can be used together. This is kind of subsetting Excel: 'ExcelSheet[<rows>, <cols>]', i.e. 'ExcelSheet[c(3, 4, 6), c(2, 4)]' - colNames - supports scalar number to denote row to be used for column names - several default related changes 'X', 'X.1', 'V1' (see ?read.xls) - rowNames: character scalars do no l...

...hanges from xlsReadWrite 1.0.0 to 1.1.1 -> added colClasses argument ("rowname", "integer", "double", "factor", "character" and "NA" to determine type of data.frame column) -> "NA" values are no longer written into the Excelsheet. -> vector will be written as a column instead of a a row -> FIXED IMPORTANT BUG which could happen in rare cases in a RKRecord cell and led to numbers not divided by 100, e.g. wrong by this factor. (thanks to Eric Rexstad for reporting!) -> fixed bug with colNames: character vecto...