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>