search for: spreadsheet_addiction

There's a new page on the Burns Statistics website http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html that looks at spreadsheets from a quality assurance perspective. It presents R as a suitable alternative to spreadsheets. Also there are several specific problems with Excel that are highlighted, including the status of statistical functionality in Excel. Patrick Burns Burns Statistics patr...

I remember in one slide of Prof. Ripley's presentation overhead, he said the most popular data analysis software is excel. So is there any resource or tutorial on this topic? Thank you so much!

I am using MS Excel (Windos Operating system), how I import/export data between MS_Excel and R. Regds Faisal Afzal SIddiqui +92-300-9297089 fasidfas at yahoo.com ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page.

...letely. > But at times we can't change the rule, the only choice is to > follow the rule. > Most deliverables in my work are in excel format. > > On 7/20/05, Greg Snow <greg.snow at ihc.com> wrote: > > See: > > > > http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html > > and > > http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf > > > > Greg Snow, Ph.D. > > Statistical Data Center, LDS Hospital > > Intermountain Health Care > > greg.snow at ihc.com > > (801) 408-8111 > > > > >>> Wensui L...

Hello, I've been using odbcConnectExcel to connect to a spreadsheet database containing a single worksheet. Unfortunately when I try to access the data R cannot see the table. When I run sqlTables it shows the worksheet as a SYSTEM TABLE instead of as a TABLE that I can access. I am fairly certain that I am do all of the same things I've done in the past when it worked just fine.

Dear Colleagues, I've been searching for a post or article or something which explains why having na.rm=FALSE or na.action=na.fail as the default is a better choice than TRUE or na.omit. I understand the basic argument: it does not make sense to average a nonexistance into an aggregate, and removing them implicitly leads to accidental pairwise deletion in some cases, and sum(x) /

Dear R users, I have started work in a Statistics government department and I am trying to convince my bosses to install R on our computers (I can't do proper stats in Excel!!). They asked me to prove that this is a widely used software (and not just another free-source, bug infected toy I found on the web!) by suggesting other big organisations that use it. Are you aware of any reputable

Do you know of any references that verify the accuracy of R for basic statistical calculations and tests. The results of these studies should indicate that R results are the same as the results of other statistical packages to a certain number of decimal places on some benchmark calculations. Thanks, Corey Powell Clinical Data Analyst Broncus Technologies cpowell@broncus.com [[alternative

I just have a simple question. I'm using the predict function, and I get about 1000 values. Now, how would I make it into a data frame or a list so that I can easily use Excel to graph the data? Right now, it's in horizontal lines, and it would be a pain to copy and paste and make it into a vertical column. Thanks! -- View this message in context:

Dear all, I have a data which is in text file and i would like to import the data to R. From the manual, i?ve found the read.table command function is the most appropriate but when i wrote the command an error had occur. It say ?Error in read.table"C:/Users/user/Documents/cfa-1.txt", header = T, sep = "\t",skip=10) :more columns than column names?. Please help me with this as

hi, i am using the RODBC package to read excel files using odbcConnectExcel and susequently sqlFetch to read the contents of the file. the file that i use is just a matrix of numbers thats all. no headers and column names. what happens is that the sqlFetch is not reading my first row of numbers. i have tried different combinations of colnames and rownames logical values but that first row is not

Hi all, Is there a way to draw 3D pie with R (like excel does)? I know how to do it in 2D, just by using pie(something)... I know it isn't the best way to represent data, but people are sometimes more interested by the look and feel than by the accuracy of the results... If there is no way, have you another suggestion ? (i already use dotchart instead of pie) Thks to all of

Hey Seniors, Really new to R, please has anyone imported a dataset from MS office excel 2007 into R yet? It seem to be giving me hard times which I did not expect as it use to go well with the previous versions. Thanks in advance. arnoldo --------------------------------- [[alternative HTML version deleted]]

...n style, see: http://www.ddg.com/LIS/InfoDesignF96/Kelvin/Napoleon/map.html and then see how attention to such details improves the effect. > Before asking how to get R to produce a graph that looks like one > from a spreadsheet, you should study: > http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html and > some of the links from there. You may also want to run the following > in > R: > >> library(fortunes) >> fortune(120) > > In general I like OpenOffice, my one main complaint is that when faced > with the decision between doing something right or the same...

Hello All- I found an inconsistency between the R-squared reported in Excel vs. that in R, and I am wondering which (if any) may be correct and if this is a known issue. While it certainly wouldn't surprise me if Excel is just flat out wrong, I just want to make sure since the R- squared reported in R seems surprisingly high. Please let me know if this is the wrong list. Thanks!

Dear all, I am beginner using R. I have a question about it. When you use it, since it is written by so many authors, how do you know that the results are trustable?(I don't want to affend anyone, also I trust people). But I think this should be a question. Thanks, Ming

Dear all, I am beginner using R. I have a question about it. When you use it, since it is written by so many authors, how do you know that the results are trustable?(I don't want to affend anyone, also I trust people). But I think this should be a question. Thanks, Ming