Message-ID: <B6A7478E-13AE-48DD-B8E7-74F59B79FF23@gmail.com>
Date: 2016-12-28T23:48:11Z
From: Bryan Mac
Subject: [FORGED] Export R output in Excel
In-Reply-To: <40e0f72d-6f0a-0fae-c875-264176a1ad1a@auckland.ac.nz>
Hi Rolf,
I wanted to export the output/results of R to an Excel file for easier comparisons/reporting. When I tried to copy and paste my output to an excel file the formatting was off.
I want to export my descriptive stats and the linear regression.
I googled ?Export R output to excel? but did not find most of the hints ?useful?. if anything, it got me more confused.
Thanks.
Bryan Mac
bryanmac.24 at gmail.com
> On Dec 28, 2016, at 3:15 PM, Rolf Turner <r.turner at auckland.ac.nz> wrote:
>
> On 29/12/16 10:45, Bryan Mac wrote:
>> Hi,
>>
>> How do I export results from R to Excel in a format-friendly way? For
>> example, when I copy and paste my results into excel, the formatting
>> is messed up.
>
>
> Short answer: *Don't*. ("Friends don't let friends use excel for statistics.")
>
> Longer answer: Googling on "export R data to excel" yields lots of "useful" hits --- "useful" given the (false) assertion that it is useful to export things to excel.
>
> cheers,
>
> Rolf Turner
>
> --
> Technical Editor ANZJS
> Department of Statistics
> University of Auckland
> Phone: +64-9-373-7599 ext. 88276