Simplify Excel Formulas Using Named Ranges
A named range is a feature in Excel that allows you to easily reference individual cells or groups of cells within a workbook using a descriptive name…
Survey Question Tip #4 - Avoid Ambiguity
When writing survey questions, it is important to be as clear and specific as possible...
Mind the Mean
While the (arithmetic) mean can be an informative summary statistic, there are certain situations when the mean is not a good representation of a set of data...
Using & Constructing Likert Scales
Check out my guest post on the American Evaluation Association's (AEA 365) blog. The post shares some tips for using/constructing Likert scales...
Survey Question Tip #2 - Ask, don't lead
Survey questions should ask respondents to give their opinion, not leading them to confirm what we believe about an issue...
Survey Question Tip #1 - Ask one question at a time
Each question on a survey should only express one idea…