Services & ResourcesWolfram ForumsMathGroup Archive

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

Re: Import of NIST ANOVA data sets

• To: mathgroup at smc.vnet.net
• Subject: [mg100060] Re: [mg100010] Import of NIST ANOVA data sets
• From: "M. Adrian Mattocks" <theadministrator at theward.com>
• Date: Fri, 22 May 2009 01:50:09 -0400 (EDT)
• References: <200905210417.AAA10078@smc.vnet.net> <4A1566E7.5090306@wolfram.com>

Thanks for your help, that was the exact issue.
The file only had one sheet but you still have to specify it.

Adrian.

-----Original Message-----
From: Darren Glosemeyer [mailto:darreng at wolfram.com] 
Sent: Thursday, May 21, 2009 10:36 AM
To: Adrian
Cc: mathgroup at smc.vnet.net
Subject: [mg100060] Re: [mg100010] Import of NIST ANOVA data sets

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>