Dear , I want to import Excel data (.XLS). Can you help me to this. Best regards. Nour-Eddine HAKIM -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
HAKIM Nour-Eddine <noureddine.hakim at axa-corporatesolutions.com> writes:> Dear , > > I want to import Excel data (.XLS). Can you help me to this. >It's difficult without going via a text file, so you need to have Excel on the machine. This is what I have been telling students (part of the information is described for SPSS, so you get that as well): \item[SPSS:] Use |File, Export| menu in the data editor and export as a tab-separated file (for simplicity, say |mydata.txt| in the top directory on the |C:| drive). Make sure that it contains a header line with the variable names and use |read.csv2("C:/mydata.txt",sep="\t")| to read it in. This refers to locales where the comma is used as decimal separator, otherwise use |read.csv|. Alternatively, one can copy the data or a section of it directly to a text editor such as Notepad via the Windows copy and paste mechanism. Note however that the variable names are not copied in this way, so one must either add them by hand (recommended) or use |read.csv2("C:/mydata.txt",sep="\t",header=F)| and add variable names later. \item[Excel:] Use |File,Save as...| and choose tab-sep (|.txt|) or use the clipboard. Subsequent data handling is similar to SPSS. Note that a header line will only be present if it was in the spreadsheet to begin with. -- O__ ---- Peter Dalgaard Blegdamsvej 3 c/ /'_ --- Dept. of Biostatistics 2200 Cph. N (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>From Excel save your data as a *.csv and then use "read.csv" to read it in Rworkspace. YG -----Message d'origine----- De : owner-r-help at stat.math.ethz.ch [mailto:owner-r-help at stat.math.ethz.ch]De la part de HAKIM Nour-Eddine Envoy? : Wednesday, December 06, 2000 6:03 AM ? : 'R-help at r-project.org' Objet : Dear , I want to import Excel data (.XLS). Can you help me to this. Best regards. Nour-Eddine HAKIM -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-. -.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._. _._ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hello, Wed, 6 Dec 2000 12:02:51 +0100, HAKIM Nour-Eddine <noureddine.hakim at axa-corporatesolutions.com> wrote>I want to import Excel data (.XLS). Can you help me to this.I use Excel data. save as CVS File (.cvs) ------ miyamura masashi (@_@; -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hakim, I don't believe there is any direct way of doing this. Here are some options: 1) If you have Excel, save the file as text or csv. 2) Convert the .xls to text. One way to do this is to go to http://www.freeviewer.com. You can use their web page to produce a text version that you can paste into a data file. Rick Bilonick HAKIM Nour-Eddine wrote:> Dear , > > I want to import Excel data (.XLS). Can you help me to this. > > Best regards. > > Nour-Eddine HAKIM > > > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
HAKIM Nour-Eddine <noureddine.hakim at axa-corporatesolutions.com> writes:>Dear , > >I want to import Excel data (.XLS). Can you help me to this.Save as .CSV (comma separated) and use read.table() in R. Mark -- Mark Myatt -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hi all, A couple of days ago, I posted a message regarding the support for heteroscedasticity testing in R. In fact, there are several tests and methods to assess whether the residuals of a model are heteroscedastic or not. The one for which I was claiming information can be found in William Greene's "Econometric Analysis", chapter 12. It's about White's *estimator*, not test, and it consists in replacing the beta's variance's traditionnal estimator by a new one calculated with the least squares residuals (instead of sigma square).>From there, a new regression is performed that supposedly corrects the coefficents.There is also a White test for heteroscadsticity, but it is said to be extremely general (Greene, p.508), and it uses the White's estimator described above. SO, the only thing that seems to be missing in R is the calculation of that very estimator, and the new regression that can be performed from it. If, anyone else than myself is interested in this feature, please let me know. Bye! Vincent. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Is there an implementation of the Dirichlet distribution somewhere in one of the libraries? Or for S-plus somewhere? John -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
I am looking for what is described in Mardia, Kent and Bibby as multi-sample clustering where the point is to establish the clusters of already-defined groups - actually with different variances (MKB describe the homogeneous case). That is, the case where it is the pre-determined groups (of different sizes) that need to be clustered, not the individual data. Having trawled through the R-pages and also an extensive Google search, I haven't found anything to wet my appetite. Have I missed anything in the present libraries (quite possible) or can anyone direct me to (preferably) R code (or perhaps S-Plus) that may help? TIA -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._