Now I understand whats happening.
Get R Output is not what should normally be used
to transfer results of computations between R and Excel.
Get R Output tries to get really verbose output which simulates
the output you would get in RGui or RTerm.
It gives you even more, because, as you noticed,
when you do an assignment, it also displays
the value which was assigned.
The simple solution to your problem is that you
just run your code without the last statmeent and then
do a
Get R Dataframe and enter the expression
anova(aov1)
this will put the result in an Excel Range.
The brute force solution if you just want simulated output is
running the first to statements and then running the last statement
separately. If then you to Get R output, you will get only the output
of the last statement you ran.
Get R Output will always only give you the output of the last statement
block you ran through Run R.
D'Antuono, Mario wrote:
>
> Sorry Erich. I do not understand why my installation does this?
>
> The following output is returned when i GET R OUTPUT via RExcel.
>
> IS there a switch to turn off the echo?
>
> M.
>
>
>> setwd('C:/RxM/Examples/Roo')
> [1] "C:/RxM/Examples/Roo"
>> eg1 = read.csv('eg1.csv',header=TRUE)
> plot Block Treatment yield comments
> 1 1 1 D 4.6 NA
> 2 2 1 A 7.3 NA
> 3 3 1 C 5.5 NA
> 4 4 1 B 6.3 NA
> 5 5 2 A 6.6 NA
> 6 6 2 C 5.4 NA
> 7 7 2 D 4.1 NA
> 8 8 2 B 5.9 NA
> 9 9 3 B 5.6 NA
> 10 10 3 D 3.5 NA
> 11 11 3 C 4.9 NA
> 12 12 3 A 6.0 NA
>> aov1= aov(yield~ factor(Treatment)+factor(Block),data=eg1)
> Call:
> aov(formula = yield ~ factor(Treatment) + factor(Block), data = eg1)
>
> Terms:
> factor(Treatment) factor(Block) Residuals
> Sum of Squares 10.735833 1.715000 0.191667
> Deg. of Freedom 3 2 6
>
> Residual standard error: 0.1787301
> Estimated effects may be unbalanced
>> anova(aov1)
> Analysis of Variance Table
>
> Response: yield
> Df Sum Sq Mean Sq F value Pr(>F)
> factor(Treatment) 3 10.7358 3.5786 112.026 1.173e-05 ***
> factor(Block) 2 1.7150 0.8575 26.843 0.001016 **
> Residuals 6 0.1917 0.0319
> ---
> Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
>
> ________________________________
>
> From: [EMAIL PROTECTED] on behalf of Erich Neuwirth
> Sent: Sat 04-Oct-08 6:54 PM
> To: R (D)COM and RExcel server related issues
> Subject: Re: [Rcom-l] Installing RExcel on a windows machine withExcel
> 2002(sp3)
>
>
>
> I still do not understand exactly what happens
> in your problem.
> I do not get any output displayed either in Excel or in
> R when I do something like this.
> Please describe in detail what you are doing.
>
>
>
> D'Antuono, Mario wrote:
>> Sorry Erich.
>>
>> I thought it was the latest version RandFriends v2072 3.0-3 that we were
>> installing? from your WIKI page?
>>
>> I guess my question is why does RExcel need to set Rserver when it should be
>> part of the installation?
>>
>> My colleague managed to go down the RExcel menu and set the Rserver. Hurrah!
>> Thanks for your very good RExcel help file.
>>
>> As explained in my email she was using an IBM R50 laptop running Windows XP
>> 2002 SP3 and Excel 2002 sp3.
>>
>> All ok now. I am now aware of what to do if anything goes wrong. But not
>> sure why Rserver is not set?
>> Thank you.
>>
>>
>> Secondly, do you want me to send the second query to a separate email to the
>> RCOM newsgroup?
>> i have this data set and i selected the following lines in Excel sheet and I
>> said Run R in via REXCEL menu
>>
>>
>> eg1 = read.csv('eg1.csv',header=TRUE)
>> aov1= aov(yield~ factor(Treatment)+factor(Block),data=eg1)
>> anova(aov1)
>>
>> eg1.csv has 12 records
>> plot Block Treatment yield
>> 1 1 D 4.6
>> 2 1 A 7.3
>> 3 1 C 5.5
>> 4 1 B 6.3
>> 5 2 A 6.6
>> 6 2 C 5.4
>> 7 2 D 4.1
>> 8 2 B 5.9
>> 9 3 B 5.6
>> 10 3 D 3.5
>> 11 3 C 4.9
>> 12 3 A 6
>>
>> WHY DOES RExcel echo the data as well as each instruction? Can i switch this
>> off? i tried options(ECHO=FALSE) in R program but to no avail? Your advice
>> please?
>>
>> Kind regards,
>> Mario.
>>
>>
>> This e-mail and files transmitted with it are privileged and confidential
>> information
>> intended for the use of the addressee. The confidentiality and/or privilege
>> in this e-mail is
>> not waived, lost or destroyed if it has been transmitted to you in error. If
>> you received this
>> e-mail in error you must
>> (a) not disseminate, copy or take any action in reliance on it;
>> (b) please notify the Department of Agriculture and Food, WA immediately by
>> return e-mail to the sender;
>> (c) please delete the original e-mail.
>>
>> This email has been successfully scanned by
>> McAfee Anti-Virus software.
>> Department of Agriculture and Food WA
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Rcom-l mailing list
>> Rcom-l@mailman.csd.univie.ac.at
>> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
>> More information (including a Wiki) at http://rcom.univie.ac.at
>> <http://rcom.univie.ac.at/>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com <http://www.avg.com/>
>> Version: 8.0.173 / Virus Database: 270.7.5/1706 - Release Date: 10/3/2008
>> 6:17 PM
>>
>
> --
> Erich Neuwirth, University of Vienna
> Faculty of Computer Science
> Computer Supported Didactics Working Group
> Visit our SunSITE at http://sunsite.univie.ac.at
> <http://sunsite.univie.ac.at/>
> Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
> _______________________________________________
> Rcom-l mailing list
> Rcom-l@mailman.csd.univie.ac.at
> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
> More information (including a Wiki) at http://rcom.univie.ac.at
> <http://rcom.univie.ac.at/>
>
>
>
>
> This e-mail and files transmitted with it are privileged and confidential
> information
> intended for the use of the addressee. The confidentiality and/or privilege
> in this e-mail is
> not waived, lost or destroyed if it has been transmitted to you in error. If
> you received this
> e-mail in error you must
> (a) not disseminate, copy or take any action in reliance on it;
> (b) please notify the Department of Agriculture and Food, WA immediately by
> return e-mail to the sender;
> (c) please delete the original e-mail.
>
> This email has been successfully scanned by
> McAfee Anti-Virus software.
> Department of Agriculture and Food WA
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Rcom-l mailing list
> Rcom-l@mailman.csd.univie.ac.at
> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
> More information (including a Wiki) at http://rcom.univie.ac.at
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.173 / Virus Database: 270.7.5/1706 - Release Date: 10/3/2008
> 6:17 PM
>
--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
