How to calculate descriptive statistics for interval or ratio data in Microsoft Excel. Includes the following formulas: Essential data cleaning =count =countblank Measures of central tendency =average =median =mode Measures of dispersion =var =stdev =min =max =quartile
An important data cleaning step is to determine whether your dataset contains any duplicate entries. How to check your Excel spreadsheet for duplicate entries using: Pivot table tallies Color-coding with conditional formatting
Accompanying spreadsheet: excel_for_evaluation_filtering_unique_entries
The most obvious strategy for visualizing text-based data is the word cloud, also known as a tag cloud, where frequent words or phrases are shown in larger, bolder font, and less-frequent words or phrases are shown in small font. I’m not advocating for run-of-the-mill word…
Comments