Posts Tagged ‘excel’
Blogger typology: quantitative analysis step 1
Sunday, January 4th, 2009
I’ve published the first dump of survey and “blog metrics” data from the blogger questionnaire as a spreadsheet on Google Docs. Many, many thanks to all of you who volunteered your information.
Please feel free to use this as you see fit for your own projects. I’ve anonymised this data (just because it’s best practice, not because I think any blogger would be mortally offended by having the world know what inspires them to blog!)
(more…)
Tags: amazon, analysis, bloggers, box plot, boxplot, conversation index, excel, getafreelancer, graph, mechanical turk, visualization
Posted in blogger typology, measurement, research | 5 Comments »
Referring to “this cell” using Excel conditional formatting
Sunday, December 28th, 2008
Since writing this post, three simpler, better ways of solving the problem have been submitted in the comments section. Feel free to read this post, but look to the comments for the solution!
If you already know about conditional formatting and navigated here via Google, please jump straight to the hack. If not, I hope the following introduction is useful. You might also like to check out the WikiHow introduction to conditional formatting in Excel. This post is actually concerned with an interesting hack that lets you reference the value of a cell itself when setting up formula-based conditional formatting rule.
Conditional Formatting
Excel’s conditional formatting feature is a boon to heavy spreadsheet users like me. It is a flexible and powerful tool that (among other things) lets me highlight data according to a set of rules so that I can easily spot the interesting bits in what would otherwise be an almost impossibly dense and meaningless cloud of numbers. Here’s an example; a table of the correlations between 32 different statements (taken from some ongoing work looking at a simple blogger typology.)
Tags: conditional formatting, excel, hack
Posted in hack, how to, research | 8 Comments »
how to: create alternate row-shading in Excel
Monday, December 31st, 2007
Why would I want to do this?
I think it’s easier to scan along lines if you colour alternate rows, particularly when you print out your sheets. Gridlines are somehow a little disorienting. You may not find this, and you may prefer the big black borders approach. But if you don’t, read on.
What’s wrong with the way I do it?
Well, if you’re doing it by hand, you’re going to run into two problems.
- Depending on how many rows you want to shade, it can take a long time.
- When you delete or add cells, you can throw off the whole thing, and have to start again
These are sufficiently irritating that it’s worth sharing this approach.
More to the point, I wanted to test out some new screen capture software (
Alternate row shading in Excel
Tags: excel
Posted in how to | 1 Comment »
