Statistical Tools in Excel

• Calculating a confidence Interval: confidence_interval.xlsm, [demo]
• AB test significance: hypothesis testing proportion.xlsm, [demo]
• Histogram: histogram.xlsm, [demo]
• Box-plot: boxplot.xlsm, [demo]
• 2x Box-plot, side by side: boxplot2.xlsm, [demo]
• Tracking Excel usage with Google analytics - screencast

July 2014 - Tools: Excel