Hi Michael, Googling "export R data to Excel" gives LOTS of advice, including packages that can write your data directly to Excel spreadsheets.
I don't use Excel, so I haven't tried any of those, but using write.csv() to export your data will create something that my colleagues who use Excel have no trouble opening. Printing to the console, as you did by typing the object name, is not intended to be an export method. Sarah On Wed, Mar 2, 2016 at 3:31 PM, Michael <elopomo...@hotmail.com> wrote: > I can get R to calculate the distance that I want between my data points. > However, I am stuck trying to get R to output the data so I can paste it into > Excel. Instead, R outputs a matrix mess in the console. > > Below are the steps I am taking to calculate the distance between my data. > Also, I have 42 different data points. > > # Calculate the Euclidean distance between each datapoint using > # the function dist() > > PRdist = dist(my_data) ; PRdist > > I would greatly appreciate if someone can tell me how to output my matrix > from the dist function into something I can paste into Excel. > > Mike > > -- ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
