MathGroup Archive 2011

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

Search the Archive

Re: Please add me to this group

  • To: mathgroup at
  • Subject: [mg117060] Re: Please add me to this group
  • From: Albert Retey <awnl at>
  • Date: Wed, 9 Mar 2011 06:56:03 -0500 (EST)
  • References: <AD5346C5-1CE7-4C46-A163-9C2FA305E5C0@BELLSOUTH.NET> <> <il52cg$nqv$>


> As a new user of Mathematica and as a purchaser of the Home Edition, 
> which does not include any support, I am trying to figure out how to 
> take data from an Excel spreadsheet into Mathematica to analyze and 
> graph.
> I have taken a couple of free seminars on line, but I have not been able 
> to figure out how to do just a few basic statistical things.  Each 
> column in my spreadsheet is a variable.  In order to produce a histogram 
> of one of those variables, I had to open the spreadsheet in Excel, copy 
> the column, then paste it into the curly braces inside the Histogram 
> function, then eliminate the carriage returns manually while inserting 
> commas manually in order to produce the Histogram.  Surely there must be 
> a faster way.

The usual way to handle this is to Import the data from the excel file:


which will import all sheets within the file. It is possible to restrict
the import to only e.g. one sheet, too. Once you have imported the data
you'd use Part or some other functions to extract the data you want to

> In the first place, I cannot tell where to place the Excel file so that 
> Mathematica knows where it is.  Anything you could do to get me started 
> would be much appreciated.

you would give it the full path to the file, as you would do for any
other program (something like C:\mystuff\myfile.xls on windows or
/home/me/myfile.xls on the other supported systems). The easiest way to
get that string is by Insert -> File Path, which opens a system specific
file open dialog which lets you choose the file in the usual way and
inserts the file name as a string at the current cursor point.



  • Prev by Date: Re: mathematica 6 saves notebook to an "empy" file
  • Next by Date: Re: Any recommendations for new hardware (quadcore/GPUs)?
  • Previous by thread: Re: Please add me to this group
  • Next by thread: Re: Please add me to this group