Re: Import of NIST ANOVA data sets
- To: mathgroup at smc.vnet.net
- Subject: [mg100042] Re: [mg100010] Import of NIST ANOVA data sets
- From: Darren Glosemeyer <darreng at wolfram.com>
- Date: Fri, 22 May 2009 01:46:42 -0400 (EDT)
- References: <200905210417.AAA10078@smc.vnet.net>
Adrian wrote:
> Hello,
>
> I am using Mathematica 7 and if I bring the data set into Excel 2007
> then save it as an .xls file, Mathematica imports the data fine but
> the then the ANOVA fails (Error: "ANOVA::arg1:The 1st argument has
> unequal columns or rows."). If I save the .xls file as a CSV file,
> import it into Mathematica and run the ANOVA, it runs successfully.
> Any ideas on why the xls import is breaking the ANOVA?
>
>
> Thanks,
> Adrian.
>
I suspect this is because XLS files could have multiple sheets, and so
the imported result is a list containing the data for each sheet. In
your case, there may only be one sheet, but the result would still be a
list containing the data for that one sheet. If this is the case, you
could use
Import[file, {"Sheets", 1}]
to just import the contents of the first sheet, or use
Import[file][[1]]
to pick the first element (the first sheet) out of the imported result
for the entire file.
Darren Glosemeyer
Wolfram Research
- References:
- Import of NIST ANOVA data sets
- From: Adrian <morejunk@theward.com>
- Import of NIST ANOVA data sets