Making Easy, Flexible Histograms with PivotTables

This post accompanies my segment on MyExcelOnline’s “Best Excel Tips of 2017 Podcast.” The first commandment of data analysis: KNOW THY DATA! It’s always smart to get a feel for your data’s distribution. Histograms offer a great way to visualize the distributions of a variable of interest. Download the exercise file here. A histogram is […]

Excel Conditional Formatting for Statistical Significance

This summer I am taking a course on measurement theory … which is as difficult as it sounds. But one of the complications of the course has little to do with sophisticated statistics or management theories. It is a problem faced by analysts everywhere, at any level of analysis: the formatting and presentation of the […]