100th Anniversary of Variance

December 27th, 2018 by boxplot

This year (2018) is the 100th anniversary of a paper by R. A. Fisher, which introduced the statistical term “variance”. Variance is one of the toughest concepts in statistics, but it’s crucially important. Variance tells you how spread out your data are (yep, “are”; the word “data” is plural!). First, let’s get some terminology out of […]

Read More


Free Datasets

December 18th, 2018 by boxplot

A list of freely available data on the web. The first list is sites we think are the best for accessing quality datasets. Below that are additional sources by category. Best Sources Kaggle By far our personal favorite! There are dozens if not hundreds of quality datasets available here. ICPSR You have to create an account, […]

Read More


Installing & Running Jupyter Notebook

December 14th, 2018 by boxplot

Step 1: Install Anaconda Go to this download webpage on Anaconda’s site. Choose the correct link for your operating system, and then go through the installation process. Step 2: Prepare a folder for notebooks Choose or create a folder on your computer where you will store all Jupyter notebook files. Make sure you choose a place […]

Read More


Git Resources

December 12th, 2018 by boxplot

Resources for Learning Git Atlassian’s GitFlow Page This is a short tutorial article focused on a typical Git sequences.   try.github.io A list of Git Resources, broken down by type.

Read More


Python Resources

December 10th, 2018 by boxplot

A hand-curated list of resources for learning python, practicing python, and everything else python!

Read More


Common Python Errors

December 10th, 2018 by boxplot

This post lists out common python errors and how to handle them, including errors encountered during installation with homebrew.

Read More


Formatting Charts in Excel

March 31st, 2018 by boxplot

Formatting charts in Excel is no easy task. It’s time-consuming, and Excel is pretty fussy which doesn’t make things easier. In this post I’ll give general tips for formatting charts, and also go over a few common scenarios. Understand the Parts of a Chart First thing’s first: it’s important to get the syntax down pat […]

Read More


Grouping in PivotTables

March 27th, 2018 by boxplot

Grouping in PivotTables is a way of combining data to perform analyses without having to use functions. You can group numeric columns to turn them into categories, you can group date columns by date ranges to get even intervals, and you can group text columns to put together similar values. We’ll go through all three […]

Read More


Tables & Linking Data Structures in Excel

March 26th, 2018 by boxplot

Tables are one of the most important features of Excel, but are often overlooked. Tables and keeping analyses in Excel connected, will drastically increase your efficiency in Excel. Let’s start by understanding how they work with PivotTables. We’re going to use an R Dataset called DoctorContacts. Download the .csv file using this link (and save […]

Read More


Make a Bubble Plot in Excel

March 15th, 2018 by boxplot

Most people don’t know that bubble plots even exist in Excel. In this blog post, we’ll walk through how to take advantage of these very effective charts! They are great for comparing three quantitative variables at once. For a nice intro to bubble plots, check out Hans Rosling’s very famous Ted Talk. If you don’t […]

Read More


0 Shares
Share
Tweet
Share