You need data sets in rows, with each column being a field. That will facilitate import and export, as well as being the way that Excel expects to see its data. To switch the stuff you've already done, copy it and then switch to another page and do Edit, Paste Special... The dialogue box has a transpose option.To do more complex statistical analysis you should go to Tools,Add-ins and tick the Analysis Toolpak. This will give you an extra set of features under Tools,Data Analysis, including a regression wizard.
© Copyright 1998-2013, The Motley Fool Limited. All rights reserved. This material is for personal use only.The Motley Fool, Fool, and the "Fool" logo are registered trademarks of The Motley Fool, Inc.Place of Reg: England & Wales. Company Reg No: 3736872. VAT Reg No: 945 6990 68. Registered Office: 5th Floor, 60 Charlotte Street London W1T 2NU.
Page load time and server: