Group Abstract Group Abstract

Message Boards Message Boards

Import data from Excel and run the Anderson Darling test on it

Posted 8 years ago

I wanna import an excel .xlsx sheet into Mathematica and perform the AndersonDarling test on it. Unluckily I'm in a hurry and unluckily I'm a very early beginner wtih Mathematica, so I decided to ask for help in this platform. I got this error message but I do not have any idea how I can solve that issue.

    AndersonDarlingTest::rctnln: The argument {{{151.6,151.9,149.8,148.8},{151.9,150.9,148.8,147.9},
{150.5,150.9,148.2,147.9},{149.9,148.8,150.7,151.},{152.6,152.2,153.4,149.9},<<41>>,
{151.,152.27,153.87,150.93},{152.65,152.21,151.67,150.21},{153.6,151.19,152.56,154.01},
{150.92,154.21,149.75,151.33},<<49>>}} at position 1 should be a rectangular array of real
 numbers with length greater than the dimension of the array.

I kindly ask for some help and explanation, what I did wrong.

THANKS and BR Hans

POSTED BY: johann.spies
2 Replies
Posted 8 years ago

Excel by default imports a list of rectangular sheets. You could try Import[file, {"Data", 1}] to only import the first sheet, then the data should be rectangular.

POSTED BY: Sean Cheren
POSTED BY: Hans Michel
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard