[R] Working with Numbers generated from Regression Output

David Winsemius dwinsemius at comcast.net
Fri Jul 27 11:11:29 CEST 2012 

On Jul 27, 2012, at 12:14 AM, Krunal Nanavati wrote:

> Hi Jeff,
>
> Sorry for the previous email.
>
> I tried using write function, and used the following syntax
>
> write(result,file="C:\\Users\\Krunal\\Desktop\\Book1.csv")
>
> but it is giving the following error
>
> Error in cat(list(...), file, sep, fill, labels, append) :
>  argument 1 (type 'list') cannot be handled by 'cat'
>
> Can you tell me where I am going wrong

(First off, we have no wat y=to know what result is. I'm guessing its  
an lm-object.

If that's correct, then you could try:

   write.csv( coef(result), file="C:\\Users\\Krunal\\Desktop\ 
\Book1.csv")

It is designed to write dataframes, but a simple list or vector of  
coefficients sould get written (after coercion).

I think you can also do this (in Windows)

   write.csv( coef(result), file="clipboard")  # and then paste into  
Excel

Excel doesn't really have a corresponding data structure to a named  
vector, so you won't get the names if you go the second route.

And finally, Excel has a /Data/Text to Columns facility that is useful  
for turning console output into columnar data. Choose the fixed format  
menu.

-- 
David.

>
>
>
>
> Thanks & Regards,
>
> Krunal Nanavati
> 9769-919198
>
> -----Original Message-----
> From: Jeff Newmiller [mailto:jdnewmil at dcn.davis.CA.us]
> Sent: 27 July 2012 12:11
> To: Krunal Nanavati; Jean V Adams
> Cc: r-help at r-project.org
> Subject: Re: [R] Working with Numbers generated from Regression Output
>
> Stop posting HTML. What you see is NOT what we see.
>
> As regards to your problems... you need to learn how to get data  
> into and
> out of R, so please read the R Input/Output document supplied with  
> R. The
> most foolproof way is to write the data to a CSV file and read it  
> from there
> into a spreadsheet. Depending on your operating system you may be  
> able to
> write into a clipboard for more convenience.
>
> As to your goal of making predictions, with only a few more steps  
> you can
> make those predictions using R. See the examples in the help for  
> predict (
> type "?predict.lm" without the quotes).
> ---------------------------------------------------------------------------
> 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.
>
> Krunal Nanavati <krunal.nanavati at cogitaas.com> wrote:
>
>> Hi Jean,
>>
>>
>>
>> Thank you very much for getting back to me.
>>
>>
>>
>> I tried the solutions that you have provided.
>>
>>
>>
>> First I tried the  coef(result) statement .and I got the below output
>>
>>
>>
>>> coef(result)
>>
>> (Intercept)            X       Volume
>>
>> -30.40275264   0.57786290   0.02594024
>>
>>
>>
>> Then, I simply selected this output from the R window, and pasted it
>> into an Excel Sheet, and it go pasted in the below manner.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> (Intercept)            X       Volume
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -30.40275264   0.57786290   0.02594024
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> So, here all the output is getting pasted in a single cell. What I am
>> looking for is something different.
>>
>>
>>
>> Here is what I am looking for
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> (Intercept)
>>
>> X
>>
>> Volume
>>
>>
>>
>>
>>
>> -30.40275264
>>
>> 0.57786292
>>
>> 0.02594024
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> So, once the beta values are placed in different cells, I can work on
>> those numbers individually to calculate elasticities.
>>
>>
>>
>> I tried with the other statements as well, but they are not  
>> addressing
>> this issue.
>>
>>
>>
>> Can you please help me out with this. I really appreciate your time  
>> and
>> effort.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Thanks & Regards,
>>
>>
>>
>> Krunal Nanavati
>>
>> 9769-919198
>>
>>
>>
>> *From:* Jean V Adams [mailto:jvadams at usgs.gov]
>> *Sent:* 26 July 2012 20:53
>> *To:* Krunal Nanavati
>> *Cc:* r-help at r-project.org
>> *Subject:* Re: [R] Working with Numbers generated from Regression
>> Output
>>
>>
>>
>> You can learn a lot from the help files.  Check out the help files  
>> for
>> the
>> lm() and summary.lm() functions
>>
>> ?lm
>> ?summary.lm
>>
>> You can extract the beta values in a few different ways.
>> These two will give you just the estimates in a vector:
>>
>> coef(result)
>> result$coef
>>
>> These two will give you the estimates and more in a matrix:
>>
>> coef(summary(result))
>> summary(result)$coef
>>
>> Jean
>>
>>
>> Krunal Nanavati <krunal.nanavati at cogitaas.com> wrote on 07/26/2012
>> 07:28:02
>> AM:
>>>
>>> Hi,
>>>
>>> I have a query on regression output generated by R.
>>>
>>>> result=lm( Y~X , data=trail)
>>>> summary(result)
>>>
>>> After running this 2 statements the following output is generated.
>>>
>>> Call:
>>> lm(formula = Y ~ X, data = trail)
>>>
>>> Residuals:
>>>    Min      1Q  Median      3Q     Max
>>> -245.30  -90.77  -30.30   54.99  532.78
>>>
>>> Coefficients:
>>>            Estimate Std. Error t value Pr(>|t|)
>>> (Intercept) 245.2982    62.1307   3.948 0.000376 ***
>>> X             0.5192     0.1752   2.963 0.005533 **
>>> ---
>>> Signif. codes:  0  ***  0.001  **  0.01  *  0.05  .  0.1     1
>>>
>>> Residual standard error: 169.1 on 34 degrees of freedom
>>> Multiple R-squared: 0.2052,     Adjusted R-squared: 0.1818
>>> F-statistic: 8.777 on 1 and 34 DF,  p-value: 0.005533
>>>
>>> From this output, I intend to use the beta values to calculate
>>> elasticities. Is this possible directly in R?
>>>
>>> If not, then when I paste this output in Excel, It is pasted as an
>> image,
>>> and thus I cannot use the beta values for calculating any other
>> metric.
>>>
>>> Can anyone please help me out!!!
>>>
>>> Thanks & Regards,
>>>
>>> Krunal Nanavati
>>> 9769-919198
>>
>> 	[[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.
>
> ______________________________________________
> 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.

David Winsemius, MD
Alameda, CA, USA

More information about the R-help mailing list