|using excel for data mining||0.54||0.5||8948||25|
You can now import the data in the text files into a spreadsheet by following these steps: Open a blank worksheet in Excel. Go to Data | Import External Data | Import Data. (In Excel 2007, click the Data tab, click Get External Data, and then select From Text.) Click the text file you want to import, then click Import.How do I enable data analysis in Excel?
Select ‘Excel add-ins’ and then click on ‘Go’ button. Window named ‘Add-Ins available’ will open. Here check the checkbox for ‘Analysis ToolPak’ and complete the process by clicking on ‘Ok’. After enabling, go to the ‘Data’ tab, click on ‘Analysis’ group under it. Here you will find the ‘Data Analysis’ command.