R help - Mar 2016 - HELP! Mann whitney in r

This may be really basic, but could you help me with this issue?
I have an excel file named table1.xls.
I need to input this table in r, in order to calculate mann whitney between
columns 1 and 2.
Could you please show me how to do this task?

	[[alternative HTML version deleted]]

Hi santib2002,
If you only have the XLS file, you could install the "xlsx" package
and read that into R.

install.packages("xlsx")
read.xls(table1.xls)

If you can load it into Excel and export it as CSV format, you can
read it with the read.csv function:

read.csv("table1.csv")

Jim



On Sun, Mar 20, 2016 at 11:43 AM,  <santib2002 at gmail.com>
wrote:
> This may be really basic, but could you help me with this issue?
> I have an excel file named table1.xls.
> I need to input this table in r, in order to calculate mann whitney between
> columns 1 and 2.
> Could you please show me how to do this task?
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.

Jim has graciously replied but:

1. Please do not double post -- that's spam;
2. This is a plain text list, so avoid  html -- it can get mangled
(though here it didn't).
3. Spend some time with an R tutorial or two. They typically cover
basic topics such as this, and there are many good ones on the Web. It
is often faster, and you'll learn a lot of good stuff so that you
won't need to post and hope here as often.

Cheers,
Bert
Bert Gunter

"The trouble with having an open mind is that people keep coming along
and sticking things into it."
-- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )


On Sat, Mar 19, 2016 at 5:43 PM,  <santib2002 at gmail.com>
wrote:
> This may be really basic, but could you help me with this issue?
> I have an excel file named table1.xls.
> I need to input this table in r, in order to calculate mann whitney between
> columns 1 and 2.
> Could you please show me how to do this task?
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.