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|| |
|Sep 2010 to Aug 2011|| |
|Sep 2011 to Aug 2012|| |
|Sep 2012 to Aug 2013|| |
|Sep 2013 to Aug 2014|| |
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).
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
lines extending vertically from the boxes (whiskers) indicating variability outside the upper and lower quartilesFor "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
- 5 Years of Continuous Blogging, Part 1
Focus on single- and five-year views for total articles, articles with images, and recipe articles.
- 5 Years of Continuous Blogging, Part 2
Focus on numbers of words in articles and graphical representations.
- 5 Years of Continuous Blogging, Part 3
More details on collecting the data.
- 5 Years of Continuous Blogging, Part 4
Emphasis on data sorting and distribution of word count groupings.