Re: Please add me to this group
- To: mathgroup at smc.vnet.net
- Subject: [mg117115] Re: Please add me to this group
- From: "Kevin J. McCann" <Kevin.McCann at umbc.edu>
- Date: Thu, 10 Mar 2011 06:08:37 -0500 (EST)
- References: <il7qbb$duc$1@smc.vnet.net>
A bit more transparent is column1 = allData[[All,1]]; column2 = allData[[All,2]]; etc. Kevin On 3/9/2011 7:03 AM, Michael Stern wrote: > 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 >