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]] ______________________________________________ [hidden email] 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. |
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 <[hidden email]> 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 > 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]] ______________________________________________ [hidden email] 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. |
In reply to this post by Krunal Nanavati
Check str(lmobj). You can see the underlying structure of lm object. It is actually a list. You can access its individual components with $ operator.
Bye |
In reply to this post by Adams, Jean
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:[hidden email]] *Sent:* 26 July 2012 20:53 *To:* Krunal Nanavati *Cc:* [hidden email] *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 <[hidden email]> 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 ______________________________________________ [hidden email] 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. |
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:<[hidden email]> 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 <[hidden email]> 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:[hidden email]] >*Sent:* 26 July 2012 20:53 >*To:* Krunal Nanavati >*Cc:* [hidden email] >*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 <[hidden email]> 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]] > >______________________________________________ >[hidden email] 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. ______________________________________________ [hidden email] 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. |
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 Thanks & Regards, Krunal Nanavati 9769-919198 -----Original Message----- From: Jeff Newmiller [mailto:[hidden email]] Sent: 27 July 2012 12:11 To: Krunal Nanavati; Jean V Adams Cc: [hidden email] 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:<[hidden email]> 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 <[hidden email]> 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:[hidden email]] >*Sent:* 26 July 2012 20:53 >*To:* Krunal Nanavati >*Cc:* [hidden email] >*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 <[hidden email]> 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]] > >______________________________________________ >[hidden email] 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. ______________________________________________ [hidden email] 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. |
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:[hidden email]] > Sent: 27 July 2012 12:11 > To: Krunal Nanavati; Jean V Adams > Cc: [hidden email] > 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:<[hidden email]> 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 <[hidden email]> 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:[hidden email]] >> *Sent:* 26 July 2012 20:53 >> *To:* Krunal Nanavati >> *Cc:* [hidden email] >> *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 <[hidden email]> 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]] >> >> ______________________________________________ >> [hidden email] 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. > > ______________________________________________ > [hidden email] 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 ______________________________________________ [hidden email] 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. |
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:[hidden email]] Sent: 27 July 2012 14:41 To: Krunal Nanavati Cc: Jeff Newmiller; Jean V Adams; [hidden email] 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:[hidden email]] > Sent: 27 July 2012 12:11 > To: Krunal Nanavati; Jean V Adams > Cc: [hidden email] > 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:<[hidden email]> 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 <[hidden email]> 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:[hidden email]] >> *Sent:* 26 July 2012 20:53 >> *To:* Krunal Nanavati >> *Cc:* [hidden email] >> *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 <[hidden email]> 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]] >> >> ______________________________________________ >> [hidden email] 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. > > ______________________________________________ > [hidden email] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > and provide commented, minimal, self-contained, reproducible code. David Winsemius, MD Alameda, CA, USA ______________________________________________ [hidden email] 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. |
On Jul 27, 2012, at 3:10 AM, Krunal Nanavati wrote: > 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? The summary function returns a complex list object. You can see that list structure with this code: #Using the example in help(lm) ctl <- c(4.17,5.58,5.18,6.11,4.50,4.61,5.17,4.53,5.33,5.14) trt <- c(4.81,4.17,4.41,3.59,5.87,3.83,6.03,4.89,4.32,4.69) group <- gl(2,10,20, labels=c("Ctl","Trt")) weight <- c(ctl, trt) lm.D90 <- lm(weight ~ group - 1) # omitting intercept str(summary(lm.D90)) What you see at the console whaen you type summary(lm.D90) is somewhat different. It is the result of another function, print.summary(). It is not a visible function so when you type its name you get: > print.summary.lm Error: object 'print.summary.lm' not found But it has to be there and I took an educated guess that it was in the stats package and can see it by using the triple-colon infix function: stats:::print.summary.lm You could wrap 'as.character' around the summary object: as.character( summary(lm.D90)) I'm guessing you do not really want all of that complexity and would probably be better served by learning the proper extractor functions for regression or summary.lm arguments linked from the help(lm) page in the "See Also" section; ?lm ?coef ?vcov ?fitted ?residuals ?terms Notice that the extractor functions will return different objects from the model object than they do from the summary object: > coef( lm.D90) groupCtl groupTrt 5.032 4.661 > coef( summary(lm.D90) ) Estimate Std. Error t value Pr(>|t|) groupCtl 5.032 0.2202177 22.85012 9.547128e-15 groupTrt 4.661 0.2202177 21.16542 3.615345e-14 > > 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. As an example, copy the output of the three lines following the console call to "coef( summary(lm.D90) )" into an Excel spreadsheet. If the copied three cells should remain highlighted. Now click the Data menu and pick the "Text to Columns... " item and accept the defaults in the which should be "fixed" in the fist dialog, and the correct locations for the cell splits in the next ones. You should now get the results split into cells. Sometimes you need to adjust the guesses that the program makes for where you want splits to occur, but the little fixed-import dialog is fairly handy, so you should learn it. But ... further such questions are off-topic for this list, and you should be getting you instructions on an Excel forum. Also read: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows (Note: I'm not a regular user of R or Excel on Windows, but I believe the actions on the Excel for Mac 2011 should very similar to the behavior I dimly remember in the Windows version. I'm also old enough to remember the several years when Excel only existed on the Mac, but in those years I was using GLIM.) -- David > > Thanks for your time. > > Thanks & Regards, > > Krunal Nanavati > 9769-919198 > > > -----Original Message----- > From: David Winsemius [mailto:[hidden email]] > Sent: 27 July 2012 14:41 > To: Krunal Nanavati > Cc: Jeff Newmiller; Jean V Adams; [hidden email] > 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:[hidden email]] >> Sent: 27 July 2012 12:11 >> To: Krunal Nanavati; Jean V Adams >> Cc: [hidden email] >> 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:<[hidden email]> 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 <[hidden email]> 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:[hidden email]] >>> *Sent:* 26 July 2012 20:53 >>> *To:* Krunal Nanavati >>> *Cc:* [hidden email] >>> *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 <[hidden email]> 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]] >>> >>> ______________________________________________ >>> [hidden email] 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. >> >> ______________________________________________ >> [hidden email] 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 David Winsemius, MD Alameda, CA, USA ______________________________________________ [hidden email] 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. |
Free forum by Nabble | Edit this page |