Re: Please add me to this group
- To: mathgroup at smc.vnet.net
- Subject: [mg117100] Re: Please add me to this group
- From: Michael Stern <nycstern at gmail.com>
- Date: Wed, 9 Mar 2011 07:03:17 -0500 (EST)
You will probably get a lot of answers to this. In the simplest case, save your mathematica notebook into the same directory where your excel spreadsheet lives. You can then use something like the following to load the entire workbook: allData = Import[NotebookDirectory[] <> "data.xlsx", "Data"] And can extract each column with something like column1 = Transpose[allData[[1]]][[1]] column2 = Transpose[allData[[1]]][[2]] Cheers, Michael On 3/8/2011 5:32 AM, Len Horton wrote: > 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. > > 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. > > Sincerely, > > Len Horton > Atlanta