Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

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>