5 Years of Continuous Blogging, Part 2

In my article about blogging 5 years (part 1), I emphasize quantities of articles over the last five years. This time, I emphasize numbers of words for articles. The images indicate distribution in scatter plots, a line chart, and a box-and-whiskers chart.

The scatter plot for the third year indicates a narrower stream of word counts than the other years. However, it's also the year with the fewest articles. The spread between high and low for word count is as follows:

Sep 2009 to Aug 2010	1323
Sep 2010 to Aug 2011	895
Sep 2011 to Aug 2012	613
Sep 2012 to Aug 2013	1277
Sep 2013 to Aug 2014	852

The line chart shows data points for high, average (mean), median, and low word counts. The box-and-whiskers chart displays the bunching of data. The "whiskers" in the box-and-whiskers graph display the end points to the "box". For each unit:

• The box represents the middle 50% of the word-count range.
• The whiskers each depict the other 50%—25% at each end.
• The line inside the box depicts the median of the word count (spreadsheet-sort of word counts by article and establishing the midpoint).

For each year's period, the line chart numbers for most words, fewest words, and medians coincide with end points and medians in the box-and-whiskers chart. Note that the fifth year "box" (smallest of the five year periods) shows that half the articles fall between approximately 400 and 600 words, with the median around 450.

Some handy resources on graphing, with the first two being the most helpful for me:

• Scatter Plots in Excel
• How to Create a Box and Whisker Plot in Excel 2010
• Box and whiskers plot
• Standard Deviation Calculator
• Handy Dummies website for visual reinforcement: Box-and-Whisker Charts for Excel

Excerpt from Box plot that summarizes "whiskers":

lines extending vertically from the boxes (whiskers) indicating variability outside the upper and lower quartiles

For "5 Years Continuous Blogging, Part 3", I will go into more detail about the road I traveled in obtaining and processing my data.

---

October 31, 2014: Links to the series

1. 5 Years of Continuous Blogging, Part 1
   Focus on single- and five-year views for total articles, articles with images, and recipe articles.
2. 5 Years of Continuous Blogging, Part 2
   Focus on numbers of words in articles and graphical representations.
3. 5 Years of Continuous Blogging, Part 3
   More details on collecting the data.
4. 5 Years of Continuous Blogging, Part 4
   Emphasis on data sorting and distribution of word count groupings.