Re: Please add me to this group
- To: mathgroup at smc.vnet.net
- Subject: [mg117079] Re: Please add me to this group
- From: Yves Klett <yves.klett at googlemail.com>
- Date: Wed, 9 Mar 2011 06:59:29 -0500 (EST)
- References: <AD5346C5-1CE7-4C46-A163-9C2FA305E5C0@BELLSOUTH.NET> <4D71F9E6.8030506@gmail.com> <il52cg$nqv$1@smc.vnet.net>
Hi, you probably want to import your data with Import["file"] which should work fine with an excel sheet. To get the filename you can use the menu bar: Insert -> File Path... which opens the standard file selection dialog. If you select a file the filename (a string) will be pasted at the cursor location. Replace "file" with this string and evaluate the command. This should get you the importable data, probably a list or a matrix of entries. These can be manipulated into suitable input for other functions. Mind you, without examples it is not possible to help you any further in doing so. Kind regards, Yves Am 08.03.2011 12:02, schrieb Len Horton: > 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