Working with Numbers generated from Regression Output
Hi David, Thanks for the reply. With your first alternative, I am getting the beta values in different cells in the excel file. Is there a way to get all the information generated by the summary function in different cells in a excel file, through the write function? Also, can you please elaborate on your third option. I went into the data tab in excel, and chose from text option, as I had pasted the console output of regression in a text file. But by doing this I am getting all the output in a single cell in excel. Thanks for your time. Thanks & Regards, Krunal Nanavati 9769-919198 -----Original Message----- From: David Winsemius [mailto:dwinsemius at comcast.net] Sent: 27 July 2012 14:41 To: Krunal Nanavati Cc: Jeff Newmiller; Jean V Adams; r-help at r-project.org Subject: Re: [R] Working with Numbers generated from Regression Output
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