Compile Textual Data and Visualize the Results Using Excel
This recipe takes data provided by textual analysis tools and uses Microsoft Excel to create graphs to aid in its interpretation.
This recipe is available as a PDF download.Ingredients
- An electronic text
- A List Words tool such as the TAPoR List Words Tool
- A Distribution tool such as the TAPoR Pattern Distribution Tool
- A Tidying tool such as the TAPoR Neko Transformer Tool
- Microsoft Excel or another spreadsheet application
This recipe needs a good exercise to show how to Compile Textual Data and Visualize the Results Using Excel?Steps
- Take an electronic text from a source such as Project Gutenberg;
- Tidy up the text using a tool such as TAPoR Neko Transformer Tool;
- Generate a list of words used in the text using the TAPoR List Words Tool;
- Generate a frequency distribution chart using TAPoR Pattern Distribution Tool for a particular word, phrase or partial word;
- Save the results to your computer as an XML file;
- Open the results in Microsoft Excel;
- Graph the results as a chart
Next Steps/Further Information
- List of All Recipes
- Exercise to Compile Textual Data and Visualize the Results Using Excel?
- Help with Particular Tools
- Background on Text Analysis
- Information about the TAPoR Frequency Distribution Tool
- Information about the TAPoR List Words Tool
- Information about the TAPoR XML Transform Tool