Skip to content

Is there a way to export regression output to an excel spreadsheet?

5 messages · chuck.01, hoguejm, Jeff Newmiller +1 more

#
Yes.

see:
?lm
?coef
?write.csv

also, if 
fit <- lm(Y~X)
then:
slope_p-value <-  summary(fit)[[4]][2,4]

Double check that last one for yourself. 
Good luck. 




hoguejm wrote
--
View this message in context: http://r.789695.n4.nabble.com/Is-there-a-way-to-export-regression-output-to-an-excel-spreadsheet-tp4649155p4649156.html
Sent from the R help mailing list archive at Nabble.com.
#
I am very very new with R. 

Needless to say, your comment is a bit confusing.  My regression name is
"mylogit"  

Anyway to write a code that I can copy paste? Thanks



--
View this message in context: http://r.789695.n4.nabble.com/Is-there-a-way-to-export-regression-output-to-an-excel-spreadsheet-tp4649155p4649157.html
Sent from the R help mailing list archive at Nabble.com.
#
This is the help-you-learn-R mailing list, not the do-my-work-for-me mailing list. I don't know where the latter is.

To assist you in the former vein, I recommend that you read the posting guide mentioned at the footer of every email on this list. It will tell you some useful hints on interpreting the assistance you have already received. Think of it like surfing the web... each bit of information is related to another, and all you have to do is follow the clues. We are also busy following our own clues, and should not be chauffeuring you around, but we don't mind giving you pointers.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.
hoguejm <hoguejm at gmail.com> wrote:

            
#
Hi

If you want a formatted output then some of the packages may be of use

library(R2THML)
?HTML.ftable
library(xtable)
? xtable

there may be functions in the Hmisc /rms packages as well

Duncan


Duncan Mackay
Department of Agronomy and Soil Science
University of New England
Armidale NSW 2351
Email: home: mackay at northnet.com.au
At 13:13 10/11/2012, you wrote: