R help - Jun 2012 - How can I export a paired t-test output table to an excel file?

Hi R users,
Could anyone let me know how to export a paired t-test output table (see
below) to an excel file?

Jason,




with(score2,pairwise.t.test(values,ind,
+         p.adjust.method="holm", paired=T))


Pairwise comparisons using paired t tests

data:  values and ind

                test1     test2    test3     test4     test5     test6
test1        1.0000  -       -       -          -       -
test2        1.0000  1.0000  -       -          -       -
test3        1.0000  1.0000  1.0000  -          -       -
test4        0.2110  0.4331  0.3402  0.0780     -       -
test5        8.2e-08 1.4e-05 6.7e-05 1.3e-05    3.1e-06 -
test6        1.0000  0.4851  1.0000  1.0000     0.0055  1.4e-05

	[[alternative HTML version deleted]]

Hello Jason,
if you put your t-test into an r-object, like here (taken from the documentary
example):

t.test <- pairwise.t.test(Ozone, Month)

you can get the table with

t.test$p.value

also you can get a lot of other stuff. you can see what's available with
"str(t.test)".
hope that's what you're looking for!

Am 02.06.2012 um 13:45 schrieb Jason Love:
> Hi R users,
> Could anyone let me know how to export a paired t-test output table (see
> below) to an excel file?
> 
> Jason,
> 
> 
> 
> 
> with(score2,pairwise.t.test(values,ind,
> +         p.adjust.method="holm", paired=T))
> 
> 
> Pairwise comparisons using paired t tests
> 
> data:  values and ind
> 
>                test1     test2    test3     test4     test5     test6
> test1        1.0000  -       -       -          -       -
> test2        1.0000  1.0000  -       -          -       -
> test3        1.0000  1.0000  1.0000  -          -       -
> test4        0.2110  0.4331  0.3402  0.0780     -       -
> test5        8.2e-08 1.4e-05 6.7e-05 1.3e-05    3.1e-06 -
> test6        1.0000  0.4851  1.0000  1.0000     0.0055  1.4e-05
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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.

If you wish to use the table in a write-up or something like this, there is a
package for exporting to MS Word - see  
http://cran.r-project.org/web/packages/R2wd/index.html
http://cran.r-project.org/web/packages/R2wd/index.html  and these examples 
http://thebiobucket.blogspot.co.at/2012/04/reproducible-research-export-regression.html
http://thebiobucket.blogspot.co.at/2012/04/reproducible-research-export-regression.html
. You could also copy-paste it to excel from there..

Yours,
Kay

--
View this message in context:
http://r.789695.n4.nabble.com/How-can-I-export-a-paired-t-test-output-table-to-an-excel-file-tp4632162p4632218.html
Sent from the R help mailing list archive at Nabble.com.