Troubleshooting with the =countif() function.
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
Caveats: https://annkemery.com/qual-dataviz/ Tool: http://www.wordle.net/